Database Scaling | Software Sauce ep 5

Scaling databases is one of those things that looks simple until it isn't.

Welcome to Software Sauce Ep 5, our series where Lyra engineers break down real tech problems to help you learn, build, and level up.

This episode is hosted by Jacob, who walks through how to actually scale a database, from a single Postgres instance through to replicated, sharded, cached infrastructure.

We cover:
→ Vertical vs horizontal scaling, and when each one is the right call
→ Read replicas in practice, and how replication lag affects user-facing flows
→ How indexes help reads and what they cost on writes
→ Sharding, and how to choose a shard key you can live with long term
→ Connection pooling, the N+1 problem, and where ORMs add overhead
→ Caching with Redis and materialised views, and how to think about invalidation

If you work on anything backed by a database, this one is worth a watch.

What do you want us to cover next in Software Sauce?

#lyra #sydney #softwaresauce #databases

Видео Database Scaling | Software Sauce ep 5 канала Lyra