What components can I use to use SQlite database with Delphi 6?
8 Answers
Try Zeos Library at http://zeos.firmos.at/portal.php.
It works well with SQLite and others.
It is free and you get the source code too.
My Answer is AnyDAC in this case. We here currently use it and it works. Especially when you think that you get more than just what the database can do. http://www.da-soft.com/anydac/
The new DevArt UniDac components has Sqlite provider
Unidac isn't free, but it's highly recommend and has very stable and fast providers, support Oracle, MS SQL Server, MySql, Interbase,PostgreSql and now Sqlite.
I use LiteDAC (components for SQLite by Devart) and like it much, because It allows to link the SQLite library statically into your application and has built-in SQlite encryption! So I recommend it highly
In Delphi XE7, FireDAC was integrated into Delphi.
Embarcadero purchased DA-SOFT in 2013, and FireDAC is their renamed AnyDAC.
Embarcadero plans to support and continue development of FireDAC, so it is now an excellent choice to be your Data Access Component for SQLite.