http://www.sqlalchemy.org/docs/05/dbengine.html#dbengine_supported SQLite!=pysqlite

Issue #1145 resolved
Former user created an issue

DBAPI 4 SQLite

Thanks for your perfect tool to get objects easily dropped in and snatched out of DBases (even different ones) without getting in SQL-trouble...

BUT: I just read your instructions and found that you still recommend pysql as DBAPI for SQLite.

I personally prefer sqlite3 (usable in python >=2.5.0 afair) as already shown here: http://docs.python.org/lib/module-sqlite3.html

The other DBAPIs seem ok for me - okay M$DB I will never use hopefully :-)

Regards, Steffen

Comments (3)

  1. Michael Trier

    Well the way it works is that it tries to import pysqlite2. If that doesn't work then it tries to fallback to importing sqlite3 available in 2.5 or greater. If you have 2.5 or greater you won't need the dbapi, provided it was compiled in there. So therefore the need for the dbapi is only for people running < 2.5. Besides basically pysqlite2 and sqlite3 are the same thing.

  2. Log in to comment