[fpc-pascal] Firebird vs. SQLite vs. PosgreSQL

[aditya siram]

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/

[LacaK]

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.

Post by aditya siram
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/
_______________________________________________
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

[Elmar Haneke]

Post by aditya siram
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.

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.

_______________________________________________
fpc-pascal maillist - fpc-***@lists.freepascal.org
http://li