DB access without object-relation mapping?

[Tim Henderson]

On Jul 29, 11:20 am, kj <so... at 987jk.com.invalid> wrote:
> 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::DBI.)  So what's the
> standard Python way to send SQL directly to a Postgres database
> and get back results?
>
> TIA!
>
> kynn
>
> --
> NOTE: In my address everything before the first period is backwards;
> and the last period, and everything after it, should be discarded.

Hi,

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

Tim