#Postgres
5 notas · última:
Build a full stack app with Rust, Next.js and Docker
The article walks through a simple full stack app built bottom-up with PostgreSQL, a Rust API, Next.js 14, and Docker Compose, then tests CRUD endpoints and the frontend.
33/60 Days System Design Questions
A daily.dev system design prompt: an order service that only stores current state can't reconstruct a billing dispute, and the post argues event sourcing is the real fix, not a patch.
Postgres Full Text Search in Ecto
The post shows how to add username search in an Ecto model with Postgres pg_trgm, including a GIN index, a composable query function, and a note on using similarity when the % operator limit must be set per query.
Zero-downtime Postgres migrations - the hard parts
A Postgres migration caused 15 seconds of API downtime because adding a foreign key locked a heavily used referenced table. The post explains why and lists ways to reduce lock-related downtime.
MySQL is done. It's the Postgres Age.
The post argues that Postgres has absorbed many jobs once split across several tools, from schemaless data and queues to search and geo indexing, while MySQL offers no clear advantage.