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

  • ToDo: Projects the core developers would like to work on
  • FeatureRequests: SQLite Feature Requests
  • ProposedIncompatibleChanges: Proposed extensions to SQLite often mentioned on mailing list
  • FullTextIndex: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
  • ProceduralLanguage: Have Lua scripting language as procedural language for SQLite
  • TabCompletion: Auto-complete SQL table and field names from the command line

Information About This Wiki

  • 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.