In Praise of PostgreSQL

Re:In Praise of PostgreSQL by kstrauser on Thursday August 05, 2021 @02:25PM (#28077573)

I worked with a company a long time ago that was using Interbase as the backend for a few websites. It had the interesting property that if you were using the command line client to connect to the server, and you used ^Z to pause the client, then the server would hang for all clients until you resumed it.

I know it’s completely unreasonable to judge Firebird today for Interbase 20 years ago, but admit that’s still the first thing that pops to my mind.

Do you feel Firebird offers something SQLite doesn’t?

[ Parent | on HN ]

Re:In Praise of PostgreSQL by open-source-ux on Thursday August 05, 2021 @03:30PM (#28078382)

Nothing beats the nimbleness, simplicity and speed of SQLite, but it is not a client/server database engine (although it is often used for that purpose due to its speed).

Firebird can be used as a proper client/server database engine. It supports static data types and stored procedures (unlike SQLite). It sits somewhere between SQLite and PostgreSQL. So it may be worth evaluating if you don't want the heft of PostgreSQL but need features missing from SQLite.

[ Parent | on HN ]