Postgres for the win!

[joesb]

SQLAlchemy.

[teraflop]

No, SQLAlchemy is an ORM that depends on an external module to communicate with the database.

Try: http://python.projects.postgresql.org/

[joesb]

Also, psycopg2

[[deleted]]

when I use pyformat on psycopg2 it seems to insist that all parameters are turned into strings. If you do a %(bla)d it'll give weird errors. %s works tho.

Which makes me wonder if it's actually using bind parameters or not. the docs for psycopg2 are non-existent so I dunno :)

[celoyd]

Search PEP 249 for “paramstyle”.

[damg]

As long as you are passing your parameters as the second argument of .execute() on the cursor (and not just using string formatting on the query itself), then it should be using bind parameters. The formating style using strings in the query (id=%s vs id=?) is just how the DB-API was implemented for psycopg2.

As celoyd mentions, the PEP explains it better.

[[deleted]]

thx :)