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

[Elmar Haneke]

> 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.