4 ms·
PostgreSQL directly supports table sharding. https://pgdash.io/blog/postgres-11-sharding.html https://pgdash.io/blog/postgres-11-sharding.html Schema evolution
by SomeCallMeTim 6y ago
PostgreSQL directly supports table sharding. https://pgdash.io/blog/postgres-11-sharding.html https://pgdash.io/blog/postgres-11-sharding.html
Schema evolution is supported by pretty much every ORM you'd care to use; it's not the job of the SQL database to handle the migration. I'm using Prisma and you literally change the software spec for the schema and say "migrate", and it creates the migration SQL and applies it to the Postgres DB programmatically. That gets you deterministic schema evolution and not the "my schema isn't actually reliable" that NoSQL/no-schema databases rely on.
And then you have CockroachDB/YugabyteDB that give you extreme horizontal scalability, with full PostgreSQL compatibility...
And bang, the last reason to use MongoDB vanishes.
- HeyImAlex 6y agoI think a missing piece is making materialized views fast since there will always be cases where someone wants to denormalize to get around performance issues, even with well designed indexes.