Migrating to Postgres

Migrating to Postgres Sean Callahan shared his story of migrating the CockroachDB to PostgreSQL with a single script ending up saving more than $100,000 annually and discovering dozens of queries which were easy to replace on the pure PostgreSQL, than in CockroachDB due to difference in query planners and available tooling. #postgresql #db #casestudy

Since early 2022, Motion was on CockroachDB. Cockroach has many qualities going for it: effortless horizontal scaling, especially when…

 

u4l1mkzfqb8s5

Wrong ways to use the databases, when the pendulum swung too far | LUU.IO

Wrong ways to use the database or decision pendulum Observing downsides of a particular technology - like a database - can force you to switch to a complete opposite, say picking up MongoDB after issues with scaling PostgreSQL. The problems start when the new tech is completely incapable of providing you even a fraction of necessary guarantees. But no more spoilers - grab an interesting story of one technical rewrite. #db #casestudy

 

r7besn6t2crlm