Forum > Databases

Which is best embedded database for Lazarus

(1/3) > >>

Packs:
Which is the best embedded database for Lazarus

Thaddy:
Sqlite

Zvoni:
Agree with Thaddy.
For local, filebased, server-less Databases SQLite is the premier DB, with Firebird as a far away second

incendio:
Depend on the complexity of your application.

Sqlite is fast and simple but do not support stored procedure and integrity constraint.

Only suitable for simple database operation.

I would choose Firebird instead for long run development.

Handoko:
Each database has its own advantages and disadvantages:

TDBF
No client lib and easy to use. But may have a potential license issue:
https://forum.lazarus.freepascal.org/index.php/topic,60100.msg448769.html#msg448769

SQLite
Release in public domain license but it has its own disadvantages:
https://forum.lazarus.freepascal.org/index.php?topic=20826.0

Firebird Embedded
Can be upgraded to work in client-server environment but the installation is a bit challenging:
https://forum.lazarus.freepascal.org/index.php/topic,64344.msg494860.html#msg494860

Navigation

[0] Message Index

[#] Next page