|
|
|
|
|
by Veratyr
3823 days ago
|
|
I'm no expert but in my (limited) experience, there are some super handy datatypes and features that PostgreSQL supports that MySQL doesn't: - Arrays, particularly with GIN indexes. This makes things like tagging fantastic in Postgres. Instead of putting your tags in another table, you throw them in an array and you can do all kinds of things like set intersection-like queries. - JSON. Postgres can store data as JSON and index and query the JSON. This essentially gives you MongoDB type queries. I'm sure there's more but these are my favourite Postgres features. |
|