Delphi 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) Alcinoe from arkadia.com: Open source components in Delphi (4..2007) for SQLite V3.x.x. find the object TalSqlite3Client to query the Sqlite3 and retrieve the result in XML format or the TalSqlConnectionPoolClient to manage pool of SqlLite3 connections and also a bench demo project to compare Sqlite3 vs Firebird Vs MySql DA-SOFT Technologies AnyDAC: High-speed, native data access components for SQLite, Firebird, MySQL, SQL Server, Oracle, PostgreSQL, Interbase, DB2, SQL Anywhere, Access, dbExpress, ODBC, that simplifies the task of building Delphi, C++ Builder and FPC database applications. Supports SQLite static linking, strong encryption, compression, UTF8 and UTF16, custom functions, collations and callbacks, DB events, online DB backup, etc. Read and watch more ! Devart Universal Data Access Components (UniDAC) - a library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, Lazarus and FreePascal. The list of supported databases includes Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, and SQLite. Devart dbExpress driver for SQLite is a database-independent layer that defines common interface to provide fast access to SQLite. For this database engine, dbExpress provides a driver as an independent library. 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. Fast and lean wrappers, browser, date/time and soundEx functions http://www.it77.de/sqlite/sqlite.htm ("Last update 28.05.2004") 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 7 to XE. http://www.itwriting.com/blog/?page_id=659. Last Update 4 Feb 2011. Delphi class for SQLite. http://www.torry.net/db/direct/db_directsql/tsqlite.zip (As of 30 April 2007, 'Error 404. Missing File.') LibSQL - Delphi/Kylix/Freepascal interface for SQLite, MySQL and ODBC32. http://sourceforge.net/projects/libsql Dataset descendant for SQLite: http://sourceforge.net/projects/sqlite4delphi (** dead project **)
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
SqliteWrap Simple Sqlite3 wrapper based on work of Tim Anderson. It have cleaned code and some additional features. http://www.ararat.cz/doku.php/en:sqlitewrap
The Open Source Synopse SQLite3 database Framework interfaces the SQlite3 database engine into pure Delphi code: database access, User Interface generation, security, i18n are handled in a safe and fast Client/Server AJAX/RESTful model. http://blog.synopse.info/category/Open-Source-Projects/SQLite3-Framework
SQLite3 for Delphi and FreePascal is a complete SQLite3 API translation for Delphi and FreePascal, as well as a simple Unicode-enabled object wrapper to simplify the use of this database engine. http://www.indasoftware.com/sqlite/
1）直接通过sqllite的dll（如sqlite3.dll），调用方法
2）直接使用封装好的Delphi控件，这类控件很多，推荐使用zeoslib，具体可参考：
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Fast and lean wrappers, browser, date/time and soundEx functions http://www.it77.de/sqlite/sqlite.htm ("Last update 28.05.2004") 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 7 to XE. http://www.itwriting.com/blog/?page_id=659. Last Update 4 Feb 2011. Delphi class for SQLite. http://www.torry.net/db/direct/db_directsql/tsqlite.zip (As of 30 April 2007, 'Error 404. Missing File.')
LibSQL - Delphi/Kylix/Freepascal interface for SQLite, MySQL and ODBC32. http://sourceforge.net/projects/libsql Dataset descendant for SQLite: http://sourceforge.net/projects/sqlite4delphi (** dead project **)
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
SqliteWrap Simple Sqlite3 wrapper based on work of Tim Anderson. It have cleaned code and some additional features. http://www.ararat.cz/doku.php/en:sqlitewrap
The Open Source Synopse SQLite3 database Framework interfaces the SQlite3 database engine into pure Delphi code: database access, User Interface generation, security, i18n are handled in a safe and fast Client/Server AJAX/RESTful model. http://blog.synopse.info/category/Open-Source-Projects/SQLite3-Framework
SQLite3 for Delphi and FreePascal is a complete SQLite3 API translation for Delphi and FreePascal, as well as a simple Unicode-enabled object wrapper to simplify the use of this database engine. http://www.indasoftware.com/sqlite/
使用SQL字符串连接
ADOQuery2.ConnectionString = 'Driver=SQLite3 ODBC Driver;Database=H:\Docum\Sqlite\World.db3;';
然后使用adoquery+dbgrid+datesource 挺方便的
就是加密方面还没搞懂.
其它方面还是挺不错的
代替access不错