Notes about SQLite: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
(sqlite studio)
Line 7: Line 7:
* [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.one.pl SQLite Studio (GPL)
** http://sqlitestudio.one.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 ==

Revision as of 12:36, 17 March 2011

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!