[Pythonmac-SIG] python & postgresql: libpython?

[Bob Ippolito]

On Sep 29, 2004, at 8:22 PM, Scott Frankel wrote:

> New to databases, I'm doing some leg-work to see which open source db 
> to
> use:  postgresql or mysql.  Without trying to start a flame war, I 
> have questions
> regarding postgresql installation & python, which is the scripting 
> language I'd like
> to use to interface with it.
>
> The installation docs warn that I might have to rebuild part of my 
> python install
> to create a python shared library.
>
>
> Questions:
>
> - Does the standard 2.3 MacPython install build a shared library?  If 
> so, it doesn't
>   appear to be called "libpython," as the postgresql docs suggest.

It's a framework, linked to with "-framework Python" instead of 
"-lpython"

> - How would one rebuild part of the python install to create a shared 
> library?

Don't, but if you had to you would configure without --enable-framework.

> [and on thinner ice ...]
> - All things being equal (which they're not!), which db has more 
> robust/mature
>   python interfaces to choose from?

Anything but MySQL, in my experience.  There are several for PostgreSQL 
and the two or three that I have tried have all worked pretty well.

-bob