Teaching elephants to fish
summary
Shows a concrete, SQL‑centric schema‑as‑code workflow that goes from database creation to deployed change using Sqitch, FlywayDB, pyrseas, PostgresCompare and demos of running migrations and tests end‑to‑end; reports a state‑of‑Postgres survey with 500 respondents and ~50% new users; highlights that Babelfish limitations make automatic SQL Server compatibility partial not complete; points to community tools like DBAtools (PowerShell) that actually migrate clusters and suggests pragmatic community actions (monthly blogfest, #SQLhelp) to onboard newcomers.
AI-written summary · about
chapters (6)
- 0:00Start
- 1:33Who Is Time Scale
- 3:50Why Sql Server
- 6:07When Is the Last Time You Had To Join a Community
- 7:57State of Postgres Survey
- 17:28Dba Tools
related talks
23mWhat I’ve Learned Teaching Postgres to 200+ field engineers at Microsoft
20mCrossing The Streams: Adding PostgreSQL to Your SQL Server Skillset
58mHow to teach an elephant to dance rock'n'roll
32mBecause SQL is everywhere but you don't want to use it
01h 10mReal World Iterative Database Development
56mLightning Talks
46mSQL for Nerds
48mDevOps Discovery: Navigating the Database Landscape