in Delphi Picks :: An embedded database is a database that does not run in a separate process, but instead is directly linked (embedded or integrated) into the application requiring access to the stored data. An embedded database is hidden from the application's end-user and requires little or no ongoing maintenance.
Read the full article to locate Embeddable Databases For Your Delphi Projects
Related:
What about mysql (or it’s variants). Using zeoslib or the native c-API it’s perfectly possible to include an embedded mysql database.
@Mark: Thanks for noticing. Added.
I think that you should add the price for each when you are developing commercial applications.
For example, I’m not sure mySQL is free (http://www.mysql.com/oem/)
But Firebird and postgree are.
as far as I can see MySQL is free without certain features available in certain editions, but i’m not sure either.
MySQL it is not ‘free’, it can be licensed under GPL (+FLOSS License Exception) or a commercial license – see http://en.wikipedia.org/wiki/MySQL#Support_and_licensing
BerkeleyDB, Interbase ToGo, MSSQL CE
We’ve used TurboDB (not a free solution either). http://www.turbodb.de/
Dont fall for the FUD, MySQL is free and if that ever changes there are several GPL/Free clones which perform identicle if not better (Drizzle, mariaDB, Percona)
Also dont forget NoSQL
NexusDB, all in one exe file
The list misses at least Interbase XE Desktop edition.
There is also Microsoft SQL Sever compact edition, it is a bit complicated to get the driver right, but then it is very powerful – and still free.
And for completeness Blackfish should probably also be mentioned.
- Olaf
Perhaps it’s usefull for many readers to know which database is free of charge and which isn’t. Advantage Local Server is free to use in your projects and has a free Manager written in Delphi.
We are using Absolute DB, its a wonderful product.
I have successfully used SQLite in some of my Delphi projects. Works perfectly.
Advantage Local Server (see @marcel) is excellent for small db projects. And its FREE. Zero Maintenance. http://www.sybase.com/products/databasemanagement/advantagedatabaseserver
MySQL Community Edition is the freely downloadable version of MySQL. All the other editions of MySQL cost money and that includes the MySQL Embedded. See
http://www.mysql.com/products/
I would suggest that MySQL Community Edition is not suitable as an embedded database in the sense that something like SQLite is.