PostgreSQL by far, what an incredible and feature-packed database.

the encryption by default is nice but I find pgAdmin to be way overkill and (at least on Mac) you can't install the command line client without installing pgAdmin

@elco I've used postgres before, but it's just SQL to me. Curious - what makes postgres special compared to Maria, or MS SQL Server?

@deadPix3l selecting stuff between dates is really nice in Postgres

Also an actual Boolean type

@deadPix3l I've not ever used Maria, but I use MS SQL Server for work and I much prefer Postgres over it. The largest complaint I have about MS SQL Server is the lack of MVCC. We have a decently concurrent workload and we often run into issues of select queries slowing down during large updates (something that Postgres handles a bit more gracefully). And the workaround that previous developers have had was to just use "NOLOCK" in every single query that was slow; and trying to get current developers to move away from that approach is difficult.