Simple and Awesome Database Tricks
summary
Concrete, hands‑on Postgres techniques with examples: using EXPLAIN ANALYZE to find a table scan on a 10,000‑row test table and cut runtime nearly in half with indexes, enabling pg_stat_statements (it stores ~5,000 recent queries), generating time series with generate_series to plot flights (81 flights at 04:00 on 1999‑06‑01), jsonb and range types, uuid‑ossp, PostGIS spatial queries, Scenic views and functions, and foreign data wrappers — shows commands, migrations, and results.
AI-written summary · about
chapters (27)
- 0:00DATABASE TRICKS Simple and Awesome
- 0:18@BARRETTCLARK
- 1:05DATABASE TOOLS
- 4:55DIFFERENT ENVIRONMENTS ARE DIFFERENT
- 5:36EXTENSION?!
- 5:54ActiveRecord migration?
- 6:06edit postgres config postgresql.conf
- 9:50DATA TYPES
- 10:06API PAYLOADS
- 10:23STORE THE PAYLOAD!!
- 12:57FOR MORE ON RANGE TYPES
- 14:17DATA INTEGRITY Benefits
- 14:47PREMATURE OPTIMIZATION? YMMV
- 15:05WORKING WITH DATA
- 15:50COMMON TABLE EXPRESSION AKA: CTE OR WITH QUERY
- 19:08SCENIC GEM
- 22:42MEDIAN
- 23:17STRUCTURE AND EXTENSIONS
- 24:22ETL Extract, Transform. Load
- 24:57BACKUP & RESTORE
- 25:273RD PARTY FUNCTIONS
- 25:49INSTALLATION
- 29:293 CLOSEST AIRPORTS San Francisco
- 30:21MAPS
- 32:11MULTI-TENANT APP
- 32:22BONUS TIP!!
- 33:19DATA VISUALIZATION TOOLKIT
related talks
45mSELECT 'amazing_features' FROM "postgresql"
42mPostgreSQL Tips & Tricks For App Devs
49mSELECT 'amazing features' FROM "postgresql"
30mLesser known features of PostgreSQL
29mSELECT 'amazing_features' FROM "postgresql"
29mPostgres Demystified
46mUse PostgreSQL to Step Up Your Game
21mA Guided Tour Through Postgres Internals with Elizabeth Garrett Christensen