[jruby-user] [ANN] ruby-pg for JRuby

John Shahid

unread,

Feb 26, 2015, 1:06:05 PM2/26/15

to us...@jruby.codehaus.org

Hi everyone,

Sorry for the double post. I posted this earlier to the announcements mailing list, but didn't get any feedback. So I'm posting here in the users mailing list hoping to get more audience.

Some of you might have come across the JRuby friendly ruby-pg gem https://github.com/headius/jruby-pg. Unfortunately I started this work more than a year ago. I didn't have time to fix the issues that were reported or keep it up to date with the ruby-pg gem. Recently, I got some leisure time and rewrote a big chunk of the gem to make it compatible with 0.17.1. I've tested the gem with JRuby 1.7.18 and all the tests pass. The active record (v3.2.21) tests pass as well.

That makes confident to release the gem, may be a release candidate for now. It looks like the ruby-pg guys are willing to merge the changes in their repo but it might take a while to do so. I think this gem should be released separately for the now. Unless I get any feedback soon, I'll go with jruby-pg.

Cheers,

JS

Tim Uckun

unread,

Feb 26, 2015, 3:32:25 PM2/26/15

to us...@jruby.codehaus.org

What would be the advantage of this gem vs the JDBC gems?

John Shahid

unread,

Feb 26, 2015, 6:59:52 PM2/26/15

to us...@jruby.codehaus.org

good question. there are two advantages that i can think of, first is asynchronous io and second is that jruby-pg is a drop in replacement for the ruby-pg gem. also afaik the jdbc interface of postgresql has some limitations regarding large object api and others that i don't remember off the top of my head. granted this isn't something that everyone needs, especially new projects, but it was a blocker to switch to jruby for some teams in the past.

cheers,

js

Tim Uckun

unread,

Feb 26, 2015, 7:14:04 PM2/26/15

to us...@jruby.codehaus.org

Great. Thanks for doing the hard yards!.

Do you have any performance numbers? Will the async IO result in better performance?

John Shahid

unread,

Feb 27, 2015, 6:56:54 PM2/27/15

to us...@jruby.codehaus.org

Sorry about the late response. No, I currently don't have benchmark numbers for the current implementation. I'd love to throw a benchmark tool at it if one already exists for ruby-pg or rails for example. I'm also not sure how the async IO is related to performance. It is a different way of handling IO, you can use threads, async IO or some hybrid strategy. Each has it's own cons/pros regarding resource usage.