**Other Projects That Interact With SQLite**
*: SqliteUsers and BigNameUsers: Lists of projects and programs that use 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
**Information On SQLite Internals**
*: DateAndTimeFunctions: Notes on how the new (experimental) date and time
functions for SQLite work.
*: MultiThreading: Notes on multithreading issues using SQLite.
*: InMemoryDatabase: Notes on how to use SQLite for in-memory tables.
*: SqliteTclPackageWrapper: Code to use SQLite package in Tcl.
*: PerformanceConsiderations: Situations in which SQLite does and doesn't perform well compared to and other database engines.
*: LanguageNotes: Hints
*: DatabaseCorruption: A log of all known bugs in SQLite that might
lead to database corruption.
*: DatabaseIsLocked: What is the "database locked" error and how to avoid it.
*: LibraryRoutineCalledOutOfSequence: Information on the "library routine
called out of sequence" error and ways to troubleshoot it.
**Notes On Compiling SQLite**
*: HowToCompile: Notes on compiling SQLite for various architectures.
*: ReadLine: License for the use of readline in sqlite.exe and hints for OSX
*: BuildOnWindowsWithTcl: A hack to build on windows using TCL.
*: SqliteBuildProcess: A described of the steps the Makefile has to go
through in order to construct SQLite
*: TheAmalgamation: Information about SQLite as a single big C code file.
*: CompilingFts: Instructions to compile fts3 with SQLite 3.5.x
*: PerlNotes: Includes instructions to compile a new DBD::SQLite with the latest SQLite source
**Hints For Using SQLite More Effectively**
*: ShellScript: Example shell scripts for creating databases.
*: SampleCode: Example C code for creating / writing to / reading from a database.
*: SimpleCode: Quickstart C code for executing any SQL against an SQLite database. Very basic but fully functional nevertheless.
*: 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 a 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.
*: ProxyLocking: Overview of proxy locking, a file locking mode for network file systems.
**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
**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.