[fpc-other] Firebird vs PostgreSQL

[Graeme Geldenhuys]

On 2017-10-28 13:34, Mark Morgan Lloyd wrote:
> One of the (numerous) things I'm wrestling with at the moment is
> PostgreSQL replication...

Speaking of PostgreSQL, I just realised that tiOPF’s 3-hourly unit test 
runs don’t include tests against PostgreSQL. I’m busy setting that up now.

This morning I read through some PostgreSQL documentation, and some of 
the SQL syntax is pretty nice. I do curse the fact that they too (like 
Microsoft SQL Server) supports XML field types. I so *hate* the usage of 
that at work. In two companies I’ve now seen the XML field types being 
used as the “lets dump everything in there because we are too fucken 
lazy to implement real database design”. It is so hard to find 
information when they are hidden in XML fields, and also makes SQL 
queries 10x harder. Obviously it also means your application is not 
portable to other relation database servers. Vendor lock-in yet again! I 
curse the person that came up with the XML field data type concept!!

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