A database specialist discusses his journey, the pronunciation of SQL, PostgreSQL vs MySQL performance, transactions and locking in Rails, choosing PostgreSQL over MySQL, the use of pgbouncer, and join tables vs Array or JSON columns for modeling relationships.
28:38
forum Ask episode
web_stories AI Snips
view_agenda Chapters
auto_awesome Transcript
info_circle Episode notes
question_answer ANECDOTE
PostgreSQL Adoption via Heroku
Andy Atkinson initially used PostgreSQL because it was the default database on Heroku.
This convenient starting point led him to further explore and appreciate PostgreSQL's capabilities.
question_answer ANECDOTE
MySQL Truncation Woes
Andy Atkinson had a negative experience with MySQL truncating data exceeding column limits.
This truncation issue, where a name lost characters, pushed him further towards PostgreSQL.
question_answer ANECDOTE
PostgreSQL Scalability at EdTech Startup
Andy Atkinson witnessed PostgreSQL's scalability at an education startup.
A simple PostgreSQL setup handled substantial load without complex technology by scaling vertically.
Get the Snipd Podcast app to discover more snips from this episode
Ruby for All