Recent

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

Packs

  • Sr. Member
  • ****
  • Posts: 365
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: 16156
  • Censorship about opinions does not belong here.
Re: Which is best embedded database for Lazarus
« Reply #1 on: September 24, 2023, 03:36:38 am »
Sqlite
If I smell bad code it usually is bad code and that includes my own code.

Zvoni

  • Hero Member
  • *****
  • Posts: 2737
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: 291
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: 5376
  • 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

Fantablup

  • Full Member
  • ***
  • Posts: 171
Re: Which is best embedded database for Lazarus
« Reply #5 on: March 27, 2024, 04:17:52 am »
I always used Firebird in my desktop apps when i need a database engine, because it can easily act as a desktop database and also as a powerful database on a server.
Now i use PostgreSQL database engine for embedded, because this also can be run easily on a cheap hosting.
Firebird is the best i think, but when you cannot run it on a cheap hosting, it becomes an issue. So, i decided Postgre after many years with Firebird. Postgre has almost all the things Firebird have and vice versa.

If i only need some small data saving i just use JSON files as a small database.

incendio

  • Sr. Member
  • ****
  • Posts: 291
Re: Which is best embedded database for Lazarus
« Reply #6 on: March 27, 2024, 04:26:50 am »
I always used Firebird in my desktop apps when i need a database engine, because it can easily act as a desktop database and also as a powerful database on a server.
Now i use PostgreSQL database engine for embedded, because this also can be run easily on a cheap hosting.
Firebird is the best i think, but when you cannot run it on a cheap hosting, it becomes an issue. So, i decided Postgre after many years with Firebird. Postgre has almost all the things Firebird have and vice versa.

If i only need some small data saving i just use JSON files as a small database.
What's the problem with Firebird on cheap hosting?

Fantablup

  • Full Member
  • ***
  • Posts: 171
Re: Which is best embedded database for Lazarus
« Reply #7 on: March 27, 2024, 04:33:00 am »
it don't exists.
With cheap, i mean like A2 hosting and these ones.

Even if i love Firebird the most, because of the fast and stable engine, and very small, but yet more powerful than most, there are these issues that made me switch.

When i need a cheap test hosting, i cannot do it with Firebird, because it does not exists cheap hostings for Firebird.
And when customers also need cheap hostings. there are none existing that exists for a long time.

One period years ago, it started to come some hostings that was cheap and with Firebird, but they are gone now.

Also, one big issue with Firebird is that when trying to contact the Firebird team it has been impossible in the latest years. I only got failed mail back :), and many of the links on the official website actually does not work last time i tried.
« Last Edit: March 27, 2024, 04:42:49 am by Fantablup »

incendio

  • Sr. Member
  • ****
  • Posts: 291
Re: Which is best embedded database for Lazarus
« Reply #8 on: March 27, 2024, 04:45:24 am »
it don't exists.
With cheap, i mean like A2 hosting and these ones.

Even if i love Firebird the most, because of the fast and stable engine, and very small, but yet more powerful than most, there are these issues that made me switch.

When i need a cheap test hosting, i cannot do it with Firebird, because it does not exists cheap hostings for Firebird.
And when customers also need cheap hostings. there are none existing that exists for a long time.

One period years ago, it started to come some hostings that was cheap and with Firebird, but they are gone now.

Also, one big issue with Firebird is that when trying to contact the Firebird team it has been impossible in the latest years. I only got failed mail back :), and many of the links on the official website actually does not work last time i tried.
Depend on your hosting's OS, you can install Firebird by yourself. I have done this many times, no problem at all.

Always choose ubuntu for my hosting.

Fantablup

  • Full Member
  • ***
  • Posts: 171
Re: Which is best embedded database for Lazarus
« Reply #9 on: March 27, 2024, 04:51:48 am »
Depend on your hosting's OS, you can install Firebird by yourself. I have done this many times, no problem at all.

Always choose ubuntu for my hosting.

Me too...

I have done this for years on any OS. It is super easy to install, and fast to do, withing minutes.
The issue is when you need it on a web hosting.

incendio

  • Sr. Member
  • ****
  • Posts: 291
Re: Which is best embedded database for Lazarus
« Reply #10 on: March 27, 2024, 04:54:34 am »
Depend on your hosting's OS, you can install Firebird by yourself. I have done this many times, no problem at all.

Always choose ubuntu for my hosting.

Me too...

I have done this for years on any OS. It is super easy to install, and fast to do, withing minutes.
The issue is when you need it on a web hosting.
So, you use it for web hosting. I never use firebird for web hosting, can't comment on this matter.

Fantablup

  • Full Member
  • ***
  • Posts: 171
Re: Which is best embedded database for Lazarus
« Reply #11 on: March 27, 2024, 04:59:27 am »
No, i dont. That is the issue. It don't exists any cheap Firebird hostings that has been up for a while, and are stable over time.
That is one of the reasons i do not use Firebird anymore.

Say, if you do any database development on a desktop application, today it is almost a must to also be able to have the database on the web. Not always, but this option is important if future requests is coming your way.

Today on my cheap web hosting i can anytime test all my applications on the web with Postgre.
Even if i want Firebird, it is impossible. So, that is why i also use Postgre as engine in my new applications. It is bigger in size compared to Firebird(100 MB) if you install it with only the runtime files. 100 MB is anyway nothing today.

Firebird i think today is around 10 mb or little more, but still more powerful than Postgre.
« Last Edit: March 27, 2024, 05:04:49 am by Fantablup »

ginoo

  • Jr. Member
  • **
  • Posts: 84
Re: Which is best embedded database for Lazarus
« Reply #12 on: March 27, 2024, 08:59:32 am »
it don't exists.
With cheap, i mean like A2 hosting and these ones.

Even if i love Firebird the most, because of the fast and stable engine, and very small, but yet more powerful than most, there are these issues that made me switch.

When i need a cheap test hosting, i cannot do it with Firebird, because it does not exists cheap hostings for Firebird.
And when customers also need cheap hostings. there are none existing that exists for a long time.

One period years ago, it started to come some hostings that was cheap and with Firebird, but they are gone now.

Also, one big issue with Firebird is that when trying to contact the Firebird team it has been impossible in the latest years. I only got failed mail back :), and many of the links on the official website actually does not work last time i tried.
Depend on your hosting's OS, you can install Firebird by yourself. I have done this many times, no problem at all.

Always choose ubuntu for my hosting.

Me too, and I haven't had any problems

 

TinyPortal © 2005-2018