Following up on the last post, I've implemented a small patch against PostgreSQL-JDBC, and sent it to on the PostgreSQL JDBC mailing list. Oliver Jowett then kindly wrote a small benchmark to test my changes, and it seems indeed to be quite a bit faster than the original version.
That said, I've also asked about using a binary protocol to connect to the database, and there has indeed been work on that. So we can hope to get a faster version sometime in the future, which does not require special handling of bytea fields any more.
Most of these examples are fairly standard ANSI-SQL so should work on most relational d atabases such as PostGreSQL, MySQL, Microsoft SQL Server, Oracle, Microsoft Access. Some examples i nvolving subselects or complex joins may not work in most versions of MySQL and some versions of Mic rosoft Access.to know more about JDBC driver visit here.
ReplyDeleteWell, it looks as if PostgreSQL is at least not directly supported. And it's not OpenSource ;-) But it's still good to see that there are alternatives, so thanks for the link.
Delete