Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

Page History

Turn Off History

Other Projects That Interact With SQLite
  • ManagementTools: Programs to manage and query SQLite databases.
  • ConverterTools: Programs to convert SQLite databases from/to other database formats and DBMSes.
  • SqliteWrappers: Code to use SQLite in various programming languages.
  • SqliteOdbc: Driver to access SQLite through ODBC
  • SqliteNetwork: Code to use SQLite over Networks.
  • SqliteReporting: Tools for producing reports from SQLite databases.
  • SqlitePorts: Ports to other operating systems/environments, not officially supported.
  • SqliteCompetitors: Comparisons between SQLite and other database engines
  • SqliteUsers: A list of projects and programs that use SQLite.

Information On SQLite Internals


Notes On Compiling SQLite

Hints For Using SQLite More Effectively

  • ShellScript: Example shell scripts for creating databases.
  • InformationSchema: The information schema consists of a set of views that contain information about the objects defined in the current database.
  • SqliteWikiFaq: A FAQ style in the wiki, ask questions about Sqlite!
  • IdxChk: Utility to report index usage for a query.
  • UndoRedo: Techniques for implementing undo/redo in an application that uses SQLite as its primary data structure.
  • ConsoleForTclTk: Source code and examples for a Tk console for SQLite
  • TclDbEdit: A GUI SQLite database editor widget for Tcl/Tk
  • InteractiveTextFieldEditing: A demonstration of the edit() function that is built into the ConsoleForTclTk.
  • ForeignKeyTriggers: How to use triggers to implement foreign key constraints in SQLite.

SQLite Proposals

  • FullTextIndex: Full-text indexing for SQLite
  • LoadableExtensions: Load functions and virtual table definitions at runtime without relinking
  • VirtualTables: Proposed Virtual Table Mechanism For SQLite
  • StoredQueries: Stored Query (ala MS Access) / Stored Proc support for SQLite
  • Procedural_Language: Have Lua scripting language as procedural language for SQLite, I have a preview of womething like that, is the 3.3.10 with minor modifications and with lsqlite3.5 (lua sqlite3 bindings), where every opened database has Lua 5.1.1 as procedural language, in Lua we have a global var 'db' that refers to the actual database, we can use anything that can be used with lsqlite3, as well is the sqlite3 shell with the same additions as the sqlite3.dll, a small example is at

Information About This Wiki

Older Pages And Pages That Fit No Other Category


  • BlueSky: Ideas for enhancements to SQLite.
  • ClientServer: Ideas for Client/Server enhancements to SQLite
  • SqliteThree: Stuff related to sqlite version 3.
  • WhenToUseSqlite: Notes on when SQLite is an appropriate choice for a database engine.
  • SqliteWebSecurity: Solutions to encrypt and secure SQLite Databases used in Web Development.