Episode 40
40: Edd Mann - You Should Switch to Postgres
In this episode, Adam talks to Edd Mann, host of Three Devs and a Maybe, about the advantages of using PostgreSQL over MySQL, common obstacles people running into when switching to Postgres, and deciding when to push work into the database instead of doin
April 19, 201651m 47s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Sponsors:
- Laracasts, use coupon code FULLSTACK2016 for 50% off your first month
- Rollbar, sign up at https://rollbar.com/fullstackradio to try their Bootstrap Plan free for 90 days
Links:
- Refactoring to Collections, Adam's book
- Edd's Blog
- PostgreSQL
- ACID
- Using JavaScript in Postgres
- Partial Indexes
- Using JSON in Postgres
- Common Table Expressions
- Postgres.app
- Navicat for Postgres
- pgAdmin
- Bruce Momjian's homepage, recommended by Edd
- Explaining the Postgres Query Optimizer
- PostgreSQL Internals Through Pictures
Topics
technologysoftwarewebdevelopmentproductstartup