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

Elmar Haneke elmar at haneke.de
Wed Nov 7 11:43:28 CET 2018

> 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
  * SQLite is an embedded library with less features and smaller in size.

More information about the fpc-pascal mailing list