[Grok-dev] Grok and PostgreSQL, where do I start?

[Peter Bengtsson]

Thanks Brandon,

That's great. I don't understand it but it looks like there's light at 
the end of that tunnel if I read the manual.

For the particular problem I'm facing today I might just do my own 
'import psycopg' since there is no model to talk about here and the 
tables already exist in a running database.


Brandon Craig Rhodes wrote:
> Peter Bengtsson <peter at fry-it.com> writes:
> 
>> Are there any documention on this yet?
>> If not, where do I start?
> 
> When I want to use PostgreSQL from Grok, I always use SQLAlchemy
> through the "zalchemy" connector that Christian Theune maintains, and
> use as documentation an email that I wrote to this list back in August
> (and which I plan to format as a tutorial just as soon as we have that
> new Grok web site up, which should be any day now):
> 
>    http://mail.zope.org/pipermail/grok-dev/2007-August/001901.html
> 
> Note that if you're using SQLAlchemy 0.4, like me, because you can't
> live without some of the new features, then the default "zalchemy"
> you'll get from the PyPI egg won't work (it won't ever commit your
> transactions automatically, at least).  The best candidate that I know
> of for a 0.4-compatible zalchemy exists at:
> 
>    http://svn.zope.org/z3c.zalchemy/branches/darrylcousins-sqlalchemy04-experiment/
> 
> which you'll have to svn:external into your project as a buildout.cfg
> development-egg until Christian decides the way forward for official,
> eggified 0.4 compatibility.  (Since SQLAlchemy 0.3 and 0.4 are simply
> incompatible APIs, I've advocated he just create a "zalchemy04" so
> that old zalchemy users still on 0.3 don't get broken by the egg
> upgrading to 0.4-compatible code; but I haven't heard back from him
> about what, exactly, he plans to do.)
> 
> Again, I hope to have better documentation up as soon as there's a new
> web site to place it on.
> 

-- 
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com