Which embedded database to use in a Delphi application?

database delphi desktop embedded-database
Darrel picture Darrel · Oct 21, 2008 · Viewed 30k times · Source

I am creating a desktop app in Delphi and plan to use an embedded database. I've started the project using SQlite3 with the DISQLite3 library. It works but documentation seems a bit light. I recently found Firebird (yes I've been out of Windows for a while) and it seems to have some compelling features and support.

What are some pros and cons of each embedded db? Size is important as well as support and resources. What have you used and why?

Answer

gabr picture gabr · Oct 21, 2008

I'm using Firebird 2.1 Embedded and I'm quite happy with it.I like the fact that the database size is practically unlimited (tested with > 4 GB databases and it works) and that the database file is compatible with the Firebird Server so I can use standard tools for database management and inspection. Distribution consists of dropping few files in your exe folder.

Simultaneous access from multiple programs is not supported but simultaneous access from multiple threads is (as long as you ensure that only one 'connect' operation is in progress at any given moment).

Related questions

How can I add fields to a clientdataset at runtime?

I have a TClientDataSet, which is provided by a TTable’s dataset. The dataset has two fields: postalcode (string, 5) and street (string, 20) At runtime I want to display a third field (string, 20). The routine of this field is getting the …

Read More
Borland Database engine on Windows 10 (1703)

Since Win10pro (1606) Borland Database Engine worked fine. I installed Win10pro build 1703 and when i run Database Desktop, it open saying that private and working dirs are invalid or undefined (administrator mode) and then, clicking OK, just closes. In …

Read More
Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]

I'm using Delphi XE5 on Windows 7 64bit and just trying FireDAC component. I'm using one TFDConnection component to connect to local MySQL database (v5.6.15). I already put the libmysql.dll (32bit v5.6.15) into my Project folder, the EXE folder and …

Read More