Tuesday, January 05, 2010

SQLite

SQLite is a compact database engine. Here is the brief description about SQLite, “SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.”

There is no need of any installation here. You just copy your database file along with rest of your application and you are off using all database capabilities. You have tables, views, triggers, transactions everything barring SP support. Lack of SP support might be an issue but do you really need SPs in small level applications where most of the things might be mere CRUD. You will not get these features if you are using flat/xml file or for that sake windows registry also. This makes this small database eligible for all your quick applications. It also supports most of SQL-92 standard, so if you grow big and need enterprise level server, you can move to SQL Server/Oracle any day. Here is the list of links that you will find helpful when working with SQLite.

  1. SQLite dll - http://www.sqlite.org/
  2. SQLite Tutorial - http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
  3. SQLite with .net - http://www.mikeduncan.com/sqlite-on-dotnet-in-3-mins/
  4. SQLite .net data provider - http://sqlite.phxsoftware.com/
  5. SQLite Administrator - http://sqliteadmin.orbmu2k.de/ 

Good luck with SQLite.

No comments: