76
edits
Changes
→Database Abstraction Layer: DB-API notes
http://wiki.python.org/moin/DatabaseProgramming/
Python has a an API to make it easy to move from one SQL-based DB to another called DB-API. Each DB may have multiple different modules available for it. If we settle on this solution then we should do some quick searches to make sure we pick the right modules. *MySQL: Yes [http://sourceforge.net/projects/mysql-python MySQLDB] used by SQLAlchemy*SQLite: Yes [http://www.python.org/doc/2.5.2/lib/module-sqlite3.html sqlite3] (included in Python 2.5 or greater) [http://oss.itsystementwicklung.de/trac/pysqlite pysqlite] both used by SQLAlchemy*BSDDB: No. The DB-API looks to be only for relational dbs. *ORM (Object Relational Mapper):no
=== <strike> Django </strike> ===
*MySQL: Yes
*SQLite: Yes
*BSDDB: No. could this be added since it uses a DB-API? I'm guessing it would be a lot of work but might be worth exploring.
[http://www.sqlalchemy.org/docs/05/dbengine.html#supported-dbapis supported dbs]
*ORM (Object Relational Mapper): yes but doesn't force it.
*mulitple database support?: maybe , need to confirm.
*Viability: Last release was January 24, 2009. They seem to have an established development team and user base. Project appears to be 3 years old,
