On Aug 11, 1:11 pm, j...@agliodbs.com (Josh Berkus) wrote:
> > Is there an easier way of going about this other than replacing the
> > postmaster / postgres components?
>
> I'd start with creating my own extended version to psql (the client
> library), I suppose. But since I don't really know what kind of
> "transformations" you have in mind, any advice is going to be purely
> speculative.
>
Thanks for the response Josh.
I'm not sure that psql is the right thing for me to do though, since I
want to build a back-end component that takes the place of the
existing postmaster. Very possible I misunderstood you though.
To clarify, essentially what I want to do is this:
Client [ psql | JDBC driver | pgAdmin | etc. ] issues a Query
[ "Select * from sales" ] | | \/
My new component intercepts this, and decides if it wants to do
something | | \/
If it does not, it simply passes this on to the real PostgreSQL server
running somewhere | | \/
If it does, it passes the request over to my new server (via sockets),
does its work, and pass back the results | | \/
The client gets the results back, either from PostgreSQL or from my
new server, and goes about its way.
