Notes about SQLite: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
Line 18: Line 18:
== 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 ==
== issues ==

Revision as of 08:56, 21 August 2009

Sources

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

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!