Python+SQL

[Chris Stiles]

What are my options for using Python and SQL - specifically mysql ? So far
I've found pysqldb and python-mysql on sourceforge, but the official
references don't seem to include anything.

Is there an API that supports the 'table row expressed/mapped to object'
paradigm ?

--
regards, chris

[Lennaert Goris]

Re: Python+SQL

Op Wed, 12 May 2004 17:02:28 +0100, schreef Chris Stiles:
[color=blue]
> What are my options for using Python and SQL - specifically mysql ? So far
> I've found pysqldb and python-mysql on sourceforge, but the official
> references don't seem to include anything.
>
> Is there an API that supports the 'table row expressed/mapped to object'
> paradigm ?[/color]

if i remember correctly python has an sql api. A google on python sql api
gave me the following two adresses.

http://www.amk.ca/python/writing/DB-API.html

http://www.wellho.net/forum/Programming-in-Python-and-Ruby/

Python-and-SQL-the-DB-API-and-Gadfly.html

First adres seems to be the most promissing.

hope I was of some help.

[Brian Gough]

Re: Python+SQL

Chris Stiles <s4fu-oirs@spamex.com > writes:
[color=blue]
> What are my options for using Python and SQL - specifically mysql ? So far
> I've found pysqldb and python-mysql on sourceforge, but the official
> references don't seem to include anything.[/color]

The database SIG has the most official information on the DB-API and
modules which conform to it: http://www.python.org/topics/database/

--
Brian Gough

Network Theory Ltd,
Publishing the Python Manuals --- http://www.network-theory.co.uk/

[Jon Franz]

Re: Python+SQL

The official references don't include anything since the modules are just
implementations of the DBAPI standard - getting to know that standard will
help you immensely.

http://www.python.org/sigs/db-sig/status.html

Alternately, try using PDO (Python Database Objects). You will still need a
DBAPI complaint module for PDO to work correctly, but it is designed to be
easy to use and provides some nice features like column-access-by-name,
while still being lightweight and very fast. Oh, and its free.

http://pdo.neurokode.com

~Jon Franz
NeuroKode Labs, LLC


----- Original Message -----
From: "Chris Stiles" <s4fu-oirs@spamex.com >
To: <python-list@python.org >
Sent: Wednesday, May 12, 2004 12:02 PM
Subject: Python+SQL

[color=blue]
> What are my options for using Python and SQL - specifically mysql ? So far
> I've found pysqldb and python-mysql on sourceforge, but the official
> references don't seem to include anything.
>
> Is there an API that supports the 'table row expressed/mapped to object'
> paradigm ?
>
> --
> regards, chris
>
>[/color]

[Chris Stiles]

Re: Python+SQL

"Jon Franz" <jfranz@neuroko de.com> writes:[color=blue]
> Alternately, try using PDO (Python Database Objects). You will still need a
> DBAPI complaint module for PDO to work correctly, but it is designed to be
> easy to use and provides some nice features like column-access-by-name,
> while still being lightweight and very fast. Oh, and its free.[/color]

Thanks, i'll take a look at it.

--
chris

[David M. Cook]

Re: Python+SQL

In article <qw7jvhzl9n.fsf @random-node.example.or g>, Chris Stiles wrote:
[color=blue]
> Is there an API that supports the 'table row expressed/mapped to object'
> paradigm ?[/color]

SQLObject, MiddleKit, and several others.

Dave Cook

[Chris Stiles]

Re: Python+SQL

"David M. Cook" <davecook@nowhe re.net> writes:[color=blue]
> In article <qw7jvhzl9n.fsf @random-node.example.or g>, Chris Stiles wrote:
>[color=green]
>> Is there an API that supports the 'table row expressed/mapped to object'
>> paradigm ?[/color]
>
> SQLObject, MiddleKit, and several others.[/color]

Thanks Dave, i'll take a look at these also.

--
regards, chris