I need help to connect Postgres and Ruby on Rails Please

This is not true.

postgres-pr is the pure-Ruby postgres client

The other postgres libs are C bindings for the official libpq client.

The C bindings are more robust, fully featured, and faster.

jeremy

I was wondering if there are any real benchmarks using the pure ruby postgresql db driver versus the c-bindings one, or if people just ‘believe’ one is faster then the other.

(In Java land, pure Java oracle-JDBC driver is actually faster then the OCI/native wrapper one (type-4 versus type-2 I think) due to time taken in the conversion between native c-structs and Java objects. But I’m not sure Ruby has the same problem…)

Here follow some really dumb benchmarks: