Notes about SQLite

From OpenPetra Wiki

Revision as of 20:55, 30 May 2009 by Pokorra (talk | contribs) (1 revision)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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

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

Retrieved from ‘https://wiki.openpetra.org/index.php?title=Notes_about_SQLite&oldid=62’