SQLite – Easy to use, dependable and good to use database for small applications.

2010-08-17 2 min read Database Linux

For last couple of days I am looking at <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite, a very footprint, file based Database.

SQLite is a C <a class="zem_slink" title="Library (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Library_%28computing%29">library that implements an <a class="zem_slink" title="SQL" rel="wikipedia" href="http://en.wikipedia.org/wiki/SQL">SQL database <a class="zem_slink" title="Database engine" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database_engine">engine. A large subset of <a class="zem_slink" title="SQL-92" rel="wikipedia" href="http://en.wikipedia.org/wiki/SQL-92">SQL92 is supported. A complete <a class="zem_slink" title="Database" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database">database is stored in a single disk file. The <a class="zem_slink" title="Application programming interface" rel="wikipedia" href="http://en.wikipedia.org/wiki/Application_programming_interface">API is designed for convenience and ease of use. Applications that link against SQLite can enjoy the power and flexibility of an SQL database without the administrative hassles of supporting a separate <a class="zem_slink" title="Database server" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database_server">database server. Version 2 and version 3 binaries are named to permit each to be installed on a single <a class="zem_slink" title="Server (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Server_%28computing%29">host.

There are already some cool tutorials on various blogs about sqlite, so I will just point to them for now.. More to come soon.

  1. <a href="http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html">http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
  2. <a href="http://freshmeat.net/articles/sqlite-tutorial">http://freshmeat.net/articles/sqlite-tutorial
  3. <a href="http://zetcode.com/databases/sqlitetutorial/">http://zetcode.com/databases/sqlitetutorial/<h6 class="zemanta-related-title" style="font-size: 1em;">Related articles by Zemanta <ul class="zemanta-article-ul"> <li class="zemanta-article-ul-li"><a href="http://www.sqlite.org/releaselog/3_7_0.html">SQLite 3.7.0 Released (sqlite.org)
  4. <li class="zemanta-article-ul-li"><a href="http://posterous.mclov.in/how-to-dump-out-sql-from-an-sqlite-database">How to dump out SQL from an SQLite database (posterous.mclov.in) <li class="zemanta-article-ul-li"><a href="http://themactrack.com/2010/07/20/sqlabs-announces-sqlitemanager-3-5-powerful-sqlite-database-manager/">SQLabs announces SQLiteManager 3.5 – Powerful SQlite Database Manager (themactrack.com) <li class="zemanta-article-ul-li"><a href="http://www.sqlite.org/draft/wal.html">SQLite 3.7: WAL (Write Ahead Logging) for better Concurrency and Performance (sqlite.org) <li class="zemanta-article-ul-li"><a href="http://elegantcode.com/2010/07/02/using-transactionscope-with-sqlite/">Using TransactionScope with SQLite (elegantcode.com) <div class="zemanta-pixie" style="margin-top: 10px; height: 15px;"><a class="zemanta-pixie-a" title="Enhanced by Zemanta" href="http://www.zemanta.com/"><img class="zemanta-pixie-img" style="border: medium none; float: right;" src="http://img.zemanta.com/zemified_e.png?x-id=c8094580-371f-4590-a748-7d6b69fe3c2d" alt="Enhanced by Zemanta" /><span class="zem-script more-related pretty-attribution">
comments powered by Disqus