From: Scott Barron <linguist@...>
Date: 2004-11-19T03:47:10+09:00
Subject: Re: [ANN] postgres-pr (pure Ruby PostgreSQL)

On Fri, 19 Nov 2004 03:04:35 +0900, Michael Neumann <mneumann@ntecs.de> wrote:
> Michael Neumann wrote:
> 
> it's now available as postgres-pr version 0.1.0. If you've installed
> this and ActiveRecord, it should work out-of-the-box.
> 
> Regards,
> 
>    Michael

Michael,

Very sweet!  I'm playing with it and I've hit a few points of
incompatibility so far.  

First up, AR will allow you to leave out the host for the postgresql adapter, 
which effectively tells the postgres module to use the unix socket.  Your 
library seems to require it to be set to /dir for the directory the socket file 
resides in.  I rather prefer your method, but any existing Rails apps would 
have to change.

Next, AR is expecting that PGResult have [].  Mapping this to
@rows.res seems to fix the problem.

Next, your library doesn't seem to like integers that are quoted (eg
UPDATE foo set bar='' where id='1') and this makes a number of AR's
unit tests fail.

Finally, I haven't tracked down this problem just yet, but the AR unit
tests give a good deal of errors very similar to this one:

test_create(BasicsTest):
NoMethodError: undefined method `title=' for #<Topic:0x1027888
@attributes={}, @new_record=true>
    ./test/../lib/active_record/base.rb:817:in `method_missing'
    ./test/base_test.rb:108:in `test_create'

Where it is always failing on a method foo= for an AR class.

Using my own project, postgres-pr works out of the box, but the real
test seems to be making the AR unit tests pass.  I'm really glad you
started this project,  a gemmed, pure ruby postgres adapter will make
my life easier in a number of ways.  Thanks!

-Scott