Notes about SQLite

Sources

• http://www.sqlite.org/
• ADO.NET 2.0 Provider for SQLite http://sourceforge.net/projects/sqlite-dotnet2
  • see HowTo section in the forum http://sqlite.phxsoftware.com/forums/10.aspx

• List of Management Tools for SQLite: you can run queries, navigate through the database, etc.
  • http://cfred.free.fr/download.php#wxsqliteplus wxSQLite+ (GPL)
  • http://sqlitestudio.one.pl SQLite Studio (GPL)
  • http://sqliteman.com/ Sqliteman (GPL)

restrictions

see also http://www.sqlite.org/omitted.html

• no access permissions (other than file permissions); this is not so much a problem, because we use our own tables for access permissions anyways
• no sequences (need a workaround: use eg. http://www.sqlite.org/faq.html#q1 AUTOINCREMENT)
• no foreign key constraints

purpose

SQLite is easy to install, and therefore is useful for setting up demo systems for evaluation of OpenPetra.org