Notes about SQLite: Difference between revisions
Jump to navigation
Jump to search
| (6 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
* ADO.NET 2.0 Provider for SQLite http://sourceforge.net/projects/sqlite-dotnet2 | * 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 | ** see HowTo section in the forum http://sqlite.phxsoftware.com/forums/10.aspx | ||
** Note: for Linux, you need at least sqlite > 3.6.1 installed | |||
* [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 wxSQLite+ (GPL) | ** http://cfred.free.fr/download.php#wxsqliteplus wxSQLite+ (GPL) | ||
** http://sqlitestudio | ** http://sqlitestudio.pl SQLite Studio (GPL) (Timotheus: works fine with unencrypted files) | ||
** http://sqliteman.com/ Sqliteman (GPL) | ** http://sqliteman.com/ Sqliteman (GPL) (Timotheus: does not seem to work in 64 bit Windows) | ||
== restrictions == | == restrictions == | ||
| Line 13: | Line 14: | ||
* 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 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 sequences (need a workaround: use eg. http://www.sqlite.org/faq.html#q1 AUTOINCREMENT) | ||
* no foreign key constraints | * NOT ANYMORE: no foreign key constraints (see http://sqlite.org/foreignkeys.html) | ||
== purpose == | == purpose == | ||
SQLite is easy to install, and therefore is useful for setting up demo systems for evaluation of OpenPetra.org | SQLite is easy to install, and therefore is useful for setting up demo systems for evaluation of OpenPetra.org | ||
== tools == | |||
* in PetraTools, see project SQLiteConsole; | |||
** this is a command line program that allows you to run SQL queries against your SQLite database, even when it is encrypted. I had problems finding a client that connects to our encrypted database on Windows. (On Linux, we cannot use encryption at the moment, so any other graphical SQLite client should work) | |||
== issues == | |||
* on Linux, I have not figured out yet, which dll to use; | |||
** ManagedOnly.dll does not work with encryption, error: System.Data.SQLite.UnsafeNativeMethods:sqlite3_key; see also http://sqlite.phxsoftware.com/forums/p/1508/6579.aspx#6579 | |||
** the other dll also does not run on Linux, even with sqlite3 = 3.6.10; System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop | |||
* for the moment: it works with ManagedOnly.dll, and empty password; only use for testing and development, not for production mode! | |||
Latest revision as of 07:33, 30 Ocak 2016
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
- Note: for Linux, you need at least sqlite > 3.6.1 installed
- 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.pl SQLite Studio (GPL) (Timotheus: works fine with unencrypted files)
- http://sqliteman.com/ Sqliteman (GPL) (Timotheus: does not seem to work in 64 bit Windows)
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)
- NOT ANYMORE: no foreign key constraints (see http://sqlite.org/foreignkeys.html)
purpose
SQLite is easy to install, and therefore is useful for setting up demo systems for evaluation of OpenPetra.org
tools
- in PetraTools, see project SQLiteConsole;
- this is a command line program that allows you to run SQL queries against your SQLite database, even when it is encrypted. I had problems finding a client that connects to our encrypted database on Windows. (On Linux, we cannot use encryption at the moment, so any other graphical SQLite client should work)
issues
- on Linux, I have not figured out yet, which dll to use;
- ManagedOnly.dll does not work with encryption, error: System.Data.SQLite.UnsafeNativeMethods:sqlite3_key; see also http://sqlite.phxsoftware.com/forums/p/1508/6579.aspx#6579
- the other dll also does not run on Linux, even with sqlite3 = 3.6.10; System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop
- for the moment: it works with ManagedOnly.dll, and empty password; only use for testing and development, not for production mode!