Recent

Author Topic: Which is best embedded database for Lazarus  (Read 1699 times)

Prakash

  • Full Member
  • ***
  • Posts: 154
Which is best embedded database for Lazarus
« on: September 23, 2023, 08:11:30 pm »
Which is the best embedded database for Lazarus

Thaddy

  • Hero Member
  • *****
  • Posts: 13250
Re: Which is best embedded database for Lazarus
« Reply #1 on: September 24, 2023, 03:36:38 am »
Sqlite
I actually get compliments for being rude... (well, Dutch, but that is the same)

Zvoni

  • Hero Member
  • *****
  • Posts: 2033
Re: Which is best embedded database for Lazarus
« Reply #2 on: September 25, 2023, 09:04:17 am »
Agree with Thaddy.
For local, filebased, server-less Databases SQLite is the premier DB, with Firebird as a far away second
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

incendio

  • Sr. Member
  • ****
  • Posts: 260
Re: Which is best embedded database for Lazarus
« Reply #3 on: October 25, 2023, 05:38:18 am »
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

  • Hero Member
  • *****
  • Posts: 5054
  • My goal: build my own game engine using Lazarus
Re: Which is best embedded database for Lazarus
« Reply #4 on: October 25, 2023, 05:48:38 am »
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

 

TinyPortal © 2005-2018