3 ms·
Fantastic! I'm mostly a MySQL user, but the more I read about Postgres, the more I like.
by michaelmior 14y ago
Fantastic! I'm mostly a MySQL user, but the more I read about Postgres, the more I like.
- throwawayG9 14y agoI moved away from MySQL to PostgreSQL recently, you can do it too =). Just be sure to read about its differences and how to tune it for performance.
- michaelmior 14y agoThat's my biggest concern about making the switch. I've gotten used to the performance characteristics of MySQL and some of it's quirks. Some small side projects on Heroku have been pushing me to learn more Postgres and perhaps I'll use it for something more important soon.
- jaytaylor 14y agoI used to be really, really into MySQL, but since getting into Postgres I've come around to preferring it. They're both good.. but anecdotally Postgres is more developer friendly and generally easier to deal with in production. Postgres also comes with features that blow MySQL away in terms of flexibility and letting you do truly cool stuff. One example: Advanced query optimization with partial or reverse indexes.
- crypto5 14y agoOne of the things I am missing in postgresql is compressed tables. It's actually big game changer in some cases.