Which is best embedded database for Lazarus

[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

[Fantablup]

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]

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]

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.

[incendio]

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]

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]

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]

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.

[ginoo]

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