Hi,
This isn't a Free Pascal question but I wanted to ask about the Firebird database [1] because it seems as the Free Pascal community uses it the most by far, so I hope it isn't too off-topic.

I've read the Firebird webpage and installed it but I can't seem to find documentation on how it compares to SQLite and PostgreSQL. My high level understanding is that it sits somewhere it between but I'm looking for more in depth comparisons on performance, data integrity tests and maybe even some real world experience anecdotes (+ive and -ive) on deployment, maintenance etc.

Thanks!
-deech

[1] https://firebirdsql.org/

Hi,

Comparasion of some basic features between database engines you can find at:
https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

L.

For use with fpc you have to look at the available interfacing libraries
- in most cases you should use some object-definitions covering the plain-C-language API.

For short:

* FirebirdSQL and PostgreSQL are both fully featured Client-Server databases. At Least FirebirdSQL does have an embedded mode to avoid server.
* SQLite is an embedded library with less features and smaller in size.