[fpc-other] Firebird vs PostgreSQL

[Graeme Geldenhuys]

On 2017-10-27 10:17, Mark Morgan Lloyd wrote:
> I think that a
> reasonable approach is to select Postgres for departmental or larger
> storage, or Firebird for something that's strictly local.

Once again... why must Firebird always be reduced to the “only for 
smaller database needs” environments?

That is exactly the point I was trying to make with my earlier reply. 
I’ve used Firebird in very busy production (Enterprise) environments 
with large amounts of users hitting the database server, and with large 
sets of data stored. Firebird performed fantastically well. So I really 
don’t see the need to reduce Firebird to only “smallish” environments. 
Firebird is a very well rounded database server, and the latest version 
introduces so very welcomed new features.

What Firebird is lacking is a really good "management studio" style 
application. FlameRobin is currently filling that space, but I 
definitely see space for improvement (tracing and profiling, some graphs 
explaining the results, graphical execution plans of queries etc). Maybe 
this is a good business opportunely for somebody to venture into.

Regards,
   Graeme

-- 
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/

My public PGP key:  http://tinyurl.com/graeme-pgp