Notes about SQLite

From OpenPetra Wiki
Jump to navigation Jump to search



see also


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


  • 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)


  • 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
    • 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!