By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,676 Members | 2,262 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,676 IT Pros & Developers. It's quick & easy.

Python+SQL

P: n/a
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
Jul 18 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Op Wed, 12 May 2004 17:02:28 +0100, schreef 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 ?


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/Programm...thon-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.

Jul 18 '05 #2

P: n/a
Chris Stiles <s4*******@spamex.com> writes:
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.


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/
Jul 18 '05 #3

P: n/a
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" <s4*******@spamex.com>
To: <py*********@python.org>
Sent: Wednesday, May 12, 2004 12:02 PM
Subject: Python+SQL

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

Jul 18 '05 #4

P: n/a
"Jon Franz" <jf****@neurokode.com> writes:
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.


Thanks, i'll take a look at it.

--
chris
Jul 18 '05 #5

P: n/a
In article <qw************@random-node.example.org>, Chris Stiles wrote:
Is there an API that supports the 'table row expressed/mapped to object'
paradigm ?


SQLObject, MiddleKit, and several others.

Dave Cook
Jul 18 '05 #6

P: n/a
"David M. Cook" <da******@nowhere.net> writes:
In article <qw************@random-node.example.org>, Chris Stiles wrote:
Is there an API that supports the 'table row expressed/mapped to object'
paradigm ?


SQLObject, MiddleKit, and several others.


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

--
regards, chris
Jul 18 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.