Hi,
I am sure most of you have seen some blog post [1] on the mysql proxy
[2]. It basically allows you to proxy calls to the server. Inside the
proxy you can write scripts (language is LUA) to do all sorts of funky
things like auditing, r/w splitting by master/slave [2], connection
pooling etc.
I am not the one to judge the feasibility of taking the code and adding
postgresql (or if mysql ab would even be willing to accept such a code
contribution). Of course the code could also get forked. Either way the
end result would be a GPL'ed app.
A proxy always seems like a slightly hacky solution to various problems
that could be addressed on a different level. But it does enable a lot
of things what probably take much more work to do "properly".
regards,
Lukas
[1] http://jan.kneschke.de/2007/6/25/mysql-proxy-0-5-0-released
[2] http://dev.mysql.com/downloads/mysql-proxy
[3] http://jan.kneschke.de/2007/8/26/mysql-proxy-more-r-w-splitting