Asi HN: Best database you've ever used?
I am not looking for anything specific and just want to hear about some options. Personally have enjoyed PlanetScale's branching a lot. Feel free to comment what was so good about the database you've used.
I am not looking for anything specific and just want to hear about some options. Personally have enjoyed PlanetScale's branching a lot. Feel free to comment what was so good about the database you've used.
My 2 cents to start the discussion:
Postgres is my go to choice, because I like that I has a lot of built-in types and I love CTEs.
PlanetScale (Vitess) was great because I loved the branching and schema migrations a lot, but unfortunately it's expensive and I like to self-host.
I've used DB2, Sybase, Postgres, mysql, Oracle, and a little SQL Server. Long ago I worked in a Sybase shop and management said we must move to Oracle. Sybase had a nice programming language that made things easier and clearer than Oracle, all i remember is that it involved creating temp tables and then querying against them. I think Sybase is no longer very popular but SQL Server was based on it and may have similar stuff. Postgres is pretty ubiquitous and it is pretty good IMHO. The DBAs at a recent job all said SQL Server is better but there is the $/windows server stuff you have to do to use it.