3 ms·
I worked for many years with MySQL and then started working in a company that used PostgreSQL. Things I liked from PostgreSQL: - Better SQL standard support
by wageslave99 3y ago
I worked for many years with MySQL and then started working in a company that used PostgreSQL. Things I liked from PostgreSQL:
- Better SQL standard support (modernish?).
- JSONB type, also with indexes! Very useful to have JSON fields to allow dynamic fields or avoid sub-querying some tables (i.e. I mean caching some computed results in a JSON field).
I have to say that it was in the 2018-2019, maybe MySQL has improved since then.