DB access without object-relation mapping?

[kj]

Python noob here.

I want to write a script that creates and populates a simple Postgres
database.

The word on the street is to use something like SQLAlchemy for
database access in Python, but my experience in the past with
packages that perform automated SQL generation has been awful, so
I always return to lighter-weight solutions that allow me to write
my own SQL. (E.g. when coding in Perl I've used Perl's DBI package
and drivers, rather than the likes of Class:BI.) So what's the
standard Python way to send SQL directly to a Postgres database
and get back results?

TIA!

kynn

 

[Tim Henderson]

Python noob here.

I want to write a script that creates and populates a simple Postgres
database.

The word on the street is to use something like SQLAlchemy for
database access in Python, but my experience in the past with
packages that perform automated SQL generation has been awful, so
I always return to lighter-weight solutions that allow me to write
my own SQL.  (E.g. when coding in Perl I've used Perl's DBI package
and drivers, rather than the likes of Class:BI.)  So what's the
standard Python way to send SQL directly to a Postgres database
and get back results?

TIA!

kynn

Hi,

I believe there are a couple of options but pyscopg, and PyGreSQL seem
to be popular.

Tim

 

[Paul Boddie]

 So what's the
standard Python way to send SQL directly to a Postgres database
and get back results?

Take a look at this page:

http://wiki.python.org/moin/DatabaseInterfaces

I've used psycopg2 and pyPgSQL successfully, although pg_proboscis
looks very interesting, too.

Paul

 

[kj]

I believe there are a couple of options but pyscopg, and PyGreSQL seem
to be popular.

Great. Thanks!

kynn