Application Development Challenges with Postgres
summary
Practical survey of using Postgres as an app backend that names real pain points and concrete tools: ORMs, query builders, PG Promise, JDBC limits, testing tactics including mini fixtures, debugging headaches from opaque logs and no statement tracing in functions, and performance surprises tied to planner statistics. Covers migration realities like transactional DDL and Postgres 11’s fast add-column, mentions PG Mustard, PG Admin, PG Badger, and emerging things around Postgres 18 external EXPLAIN and schema evolution tooling. Good if operating Postgres without a dedicated DBA.
AI-written summary · about
chapters (8)
- 0:00The accidental database user
- 5:17Vernacular database design
- 5:53Application development lifecyle
- 8:34Interacting with Postgres
- 11:22Data modeling and extensions
- 13:48Data access layer needs
- 14:49Evolution of data access
- 15:32Testing, debugging, and growth
related talks
50mPostgreSQL gotchas for app developers
53mTop Development Mistakes When Working with PostgreSQL
21mDriving the Future of PostgreSQL Adoption
21mDiscovering Postgres...
01h 12mWorkshop: Postgres for Frontend Developers (Part 1)
51mHow Postgres is misused and abused in the wild
29mPostgres Demystified
47mPostgres & Beyond