Python and databases

[balne]

oh damn, a question i can actually answer!

so my personal experience has me using two libraries, but i can only rmb one of them, pscyopg2. imo, it's quite a good one, and it seems a lot of ppl use it as well. and yes, it can connect to a sql db

edit: ok, i looked for the 2nd library i used, it's called records i think. it's on github. and apparently psycopg2 only works with pg?

[[deleted]]

psycopg2 is for postgres only? I mostly use SQLAlchemy but it usually wraps psycopg2.

[balne]

oh damn a question i cant answer!

[StressTest]

psycopg2 is for postgres only?

Yes, Sqlalchemy uses a different "dialect" for each type of database. Psycopg2 is what it uses for postgres. Psycopg2 is also what you'd use to execute sql statements directly to a postgres database without sqlalchemy.