10

What components can I use to use SQlite database with Delphi 6?

Johan
  • 74,508
  • 24
  • 191
  • 319
Alejandro Jourdan
  • 353
  • 1
  • 2
  • 16
  • 1
    http://stackoverflow.com/questions/222699/which-embedded-database-to-use-in-a-delphi-application might be interesting to you. – lothar May 11 '09 at 23:01

8 Answers8

7

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/

Michael
  • 81
  • 1
  • 2
  • Great article about AnyDAC and SQLite - http://www.da-soft.com/blogs/developing-delphi-applications-with-sqlite-and-anydac.html – oodesigner Nov 11 '10 at 07:23
7

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.

Alan Fletcher
  • 310
  • 1
  • 4
6

I'm using DISQLite3 in FeedDemon and recommend it highly.

Nick Bradbury
  • 1,745
  • 13
  • 14
3

I have successfully used ASqlite from http://www.aducom.com.

It's free, open source software.

SeanX
  • 1,851
  • 20
  • 28
3

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.

Mohammed Nasman
  • 10,992
  • 7
  • 43
  • 68
2

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

JackD
  • 597
  • 4
  • 7
2

We just validated our Synopse SQlite3 framework for Delphi 6.

You've got a whole Client/Server ORM framework, using SQLite3 3.7.3 for its data storage. It's fast and light. And there is some User-Interface dedicated classes (Screen auto-generation, reporting with direct pdf export...).

See http://synopse.info/forum/viewforum.php?id=2

A. Bouchez
  • 209
  • 1
  • 2
  • I've extracted the SQLite3 wrapper out of the ORM. And you have even an abstract DB layer, so that you can change later to any other database engine, if needed, just by changing the class type used. See http://blog.synopse.info/post/2011/07/22/SynDBSQLite3%3A-SQLite3-direct-access – Arnaud Bouchez Aug 18 '11 at 11:57
0

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.

lkessler
  • 19,819
  • 36
  • 132
  • 203
  • 1
    But the questioner asked about using Sqlite with Delphi 6, which pre-dates FireDAC by a long way – MartynA Jul 11 '15 at 20:53
  • @MartynA - Wouldn't this be a useful answer to have here for other people who come across this question but have XE7 or later? – lkessler Jul 12 '15 at 05:37
  • I guess so, but owners of XE7+ wouldn't have to look much further than the OLH. I'll have to remind myself of the Sqlite driver I used with D7 and maybe add it to the list if it's not already there. – MartynA Jul 12 '15 at 07:36