
Scaling Postgres Episode 51 | Value of SQL | Window Functions | DB Migrations | Data Storage
Get New Episodes Weekly!
In this episode of Scaling Postgres, we review articles covering the value of SQL, window functions, scaling database migrations and efficient data storage.
Content Discussed
- [YouTube] Breaking PostgreSQL at Scale
- SQL: One of the Most Valuable Skills
- How to Calculate a Cumulative Percentage in SQL
- What’s new in PostgreSQL 11
- Move fast and migrate things: how we automated migrations in Postgres
- Performance best practices for using Azure Database for PostgreSQL – Connection Pooling
- PostgreSQL Deep Dive: How Your Data Model Affects Storage
- FOSDEM PostgreSQL Track
- FOSDEM Databases Track
- [YouTube] What's new in PostgreSQL 11
- [YouTube] Deploying PostgreSQL on Kubernetes
- [YouTube] Hacking PostgreSQL
- [YouTube] Around the world with Postgres extensions
- [YouTube] Data Modeling, Normalization and Denormalization
- What’s up with SET TRANSACTION SNAPSHOT?
- An Overview of the Index Changes in PostgreSQL 11