Is there any really excellent reason to use PostgreSQL over MySQL/MariaDB for an app like #Readlebee or any other federated app? I know MySQL much better and could develop for it much faster, but if PostgreSQL is inherently better at storing and retrieving records concurrently or something like that, I'd be willing to stick with using it.

Follow

@Readlebee I know and love Postgres, but not MySQL. I do know there are some nice features Postgres has that MySQL doesn't — queryable JSON columns, materialized views... MySQL is less supportive of triggers, stored procedures, subqueries, ... To me MySQL feels like a Honda Civic. Reliable, but nothing fancy. Postgres is more lux. Still gets you to the same place, just a little more comfortably (and fun!)

Sign in to participate in the conversation
Librem Social

Librem Social is an opt-in public network. Messages are shared under Creative Commons BY-SA 4.0 license terms. Policy.

Stay safe. Please abide by our code of conduct.

(Source code)

image/svg+xml Librem Chat image/svg+xml