Notes about SQLite: Difference between revisions
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
* [http://www.sqlite.org/cvstrac/wiki?p=ManagementTools List of Management Tools for SQLite]: you can run queries, navigate through the database, etc. | * [http://www.sqlite.org/cvstrac/wiki?p=ManagementTools List of Management Tools for SQLite]: you can run queries, navigate through the database, etc. | ||
** http://cfred.free.fr/download.php#wxsqliteplus (GPL) | ** http://cfred.free.fr/download.php#wxsqliteplus wxSQLite+ (GPL) | ||
** http://sqlitestudio.one.pl SQLite Studio (GPL) | ** http://sqlitestudio.one.pl SQLite Studio (GPL) | ||
Revision as of 15:09, 9 June 2009
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)
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