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

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.
  • ImportingFiles: How to import a variety of file formats into a SQLite database.
  • ScrollingCursor: How to optimise queries to limit the number of rows returned to achieve either scrolling windows or paged (i.e. page X of Y) results.

SQLite Proposals

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.