Http Frontend implemented using pgsql?
I had a thought that it might be interesting to have a simple C fronted
that converts HTTP to and from some pgsql friendly structure and delegates
all the core logic to a stored procedure in the database.
This might make it easier to hack on the API without worrying about memory
management and buffer overflow vulnerabilities.
Is this a brain wave or a brain fart?
On Sat, Mar 31, 2012 at 6:27 AM, Dobes Vandermeer <dobesv@gmail.com> wrote:
I had a thought that it might be interesting to have a simple C fronted that
converts HTTP to and from some pgsql friendly structure and delegates all
the core logic to a stored procedure in the database.This might make it easier to hack on the API without worrying about memory
management and buffer overflow vulnerabilities.Is this a brain wave or a brain fart?
Something along the lines of a stripped down mod_libpq?
http://asmith.id.au/mod_libpq.html
If we had something along the lines of JSON <-> Row/setof in core, I
could see this being a very nice "RPC" mechanism for PostgreSQL.
Plain HTTP still give's you the session/transaction control problem of
stateless clients, but maybe coupled with PgPool you could cobble
something together...
a.
--
Aidan Van Dyk Create like a god,
aidan@highrise.ca command like a king,
http://www.highrise.ca/ work like a slave.