Aducom’s SQLite: Open source (NewBSD) Delphi (4..2007) C++ (BCB5, 6, 2007) and 2009/2010 components for SQLite V2.8.x and V3.x.x. (like TASQLiteDB, TASQLiteQuery, TASQLiteTable, TASQLiteUpdateSQL and others). No need for the BDE but Delphi standard edition is not supported. Support for static linking (no dll needed), utf-8, utf-16 and unidirectonal dataset. (updated 1 dec 2009)
RemObjects AnyDAC: High-speed, universal data access engine for SQLite, Firebird, MySQL, MS SQL Server, Oracle, PostgreSQL, Interbase, MS Access, IBM DB2, Sybase ASA, DbExpress, ODBC, that simplifies the task of building CodeGear Delphi, C++Builder and Free Pascal Compiler database applications. (commercial)
ZeosLIB: The ZeosLib is a set of database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle, DB/2, SQLite (2.8.x & 3.x – in cvs) for Delphi, Kylix, C++ Builder, Lazarus
DISQLite3: The fully embedded, no-DLL SQLite3 solution for Delphi (D4, D5, D6, D7, D2005, D2006, D2007, D2009) including FTS1, FTS2, FTS3, R-Tree, and encryption. DISQLite3 compiles with Delphi standard / personal and does NOT require sqlite3.dll. It provides the complete SQLite3 API, is regularly updated, very small, well documented, tightly integrated, and carefully optimized. As a result, DISQLite3 outperforms sqlite3.dll up to 50% for common operations. Free personal edition.
Simple SQLite 3.0 wrapper, no TDataset or databinding, but fast and easy to use. Free for any purpose. Uses external sqlite3.dll for easy updating. Supports Delphi 2009. http://www.itwriting.com/blog/?page_id=659. Last Update 16 October 2008.
SQLitePass library : SQLite Pass is a simple set of components designed for Lazarus-fpc and Delphi, to give access to SQLite databases. This project is open source, released under LGPL license. Those libraries and components are free.SQLite Download : http://source.online.free.fr