SELECT 'amazing features' FROM "postgresql"
summary
Practical tour of PostgreSQL features that replace glue code: shows readable refactors with common table expressions, aggregates and pivoting with window functions, per-row subqueries via join lateral, deduplication with row_number, UUIDs via `uuid-ossp` instead of serial sequences, domain types and regex constraints to prevent corruption, triggers + LISTEN for lightweight push, recursive CTEs and l_tree for hierarchies, foreign data wrappers to query files, APIs or remote DBs, and deployment choices from Cloud SQL to AlloyDB, Yugabyte, Crunchy and Clever Cloud.
AI-written summary · about
chapters (18)
- 0:00PostgreSQL features intro
- 1:28PostgreSQL history
- 3:36SQL as declarative language
- 6:25CTEs for readability
- 8:53Window functions in pipelines
- 12:52Row number for corruption
- 16:04Lateral joins for subqueries
- 18:33UUIDs vs serial IDs
- 23:10Constraints and types for data
- 28:05PostgreSQL as message broker
- 30:15ltree for hierarchical data
- 33:28Recursive CTEs explained
- 36:00Foreign data wrappers
- 39:57Connecting to other systems
- 41:01PostgreSQL anti-patterns
- 43:53PostgreSQL beyond database
- 46:25PostgreSQL in cloud
- 48:57Conclusion & Q&A
related talks
45mSELECT 'amazing_features' FROM "postgresql"
29mSELECT 'amazing_features' FROM "postgresql"
48mSELECT 'amazing_features' FROM "postgresql"
44mSELECT 'amazing_features' FROM "posgresql"
34mSimple and Awesome Database Tricks
46mUse PostgreSQL to Step Up Your Game
30mLesser known features of PostgreSQL
29mPostgres Demystified