3 ms·
Based on this comment, I started looking into JRuby support for the pg gem. I think it's possible; I have started stubbing it out, and the Postgresl JDBC driver
by headius 14y ago
Based on this comment, I started looking into JRuby support for the pg gem. I think it's possible; I have started stubbing it out, and the Postgresl JDBC driver publishes additional interfaces that provide everything folks here have been asking for.
I'm looking for help filling it out. Here's the mostly stubbed extension:
https://github.com/headius/jruby-pg https://github.com/headius/jruby-pg
And here's the docs for pgsql's hidden interfaces (cast the JDBC objects to these, and you're good to go):
http://jdbc.postgresql.org/documentation/publicapi/index.html http://jdbc.postgresql.org/documentation/publicapi/index.htm...
- wolfeidau 14y agoGreat news, would be a welcome addition to JRuby! Interested to do some testing as it comes together and see what I can help with.
- sheff 14y agoThis would be brilliant, as Postgres is one of the most commonly used databases with Rails (generally, and also because of Heroku) so having feature parity between the pg gem and JDBC drivers that you can use with, for example, Torquebox would be great, especially for people wanting to migrate to JRuby. I did some basic benchmarking with one of the JRuby 1.7 preview releases and was impressed enough with the speed benefits to want to try it out with a small app on Torquebox when JRuby 1.7 was released. Thanks to joevandyk and xiljin for pointing out the search_path and datatype support situation before I undoubtedly encountered them myself - and love the fact that headius has immediately leapt in to try and fix things :-)
- funny_falcon 14y agoMay be it would be better to reimplement protocol, like postgres-pr does but using java ? Protocol is rather simple, and postgres-pr could be used as a reference (it implements meaningfull subset).