S2E1: Andrew Atkinson, Software Engineer and Author

https://is1-ssl.mzstatic.com/image/thumb/Podcasts211/v4/77/f2/51/77f251ff-fc8d-60d2-52f8-19e3489cadf7/mza_11168506707378499369.jpg/600x600bb.jpg

Hacking Postgres

Ry Walker

22 episodes

9 months ago

All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week.

All content for Hacking Postgres is the property of Ry Walker and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week.

Technology

Business,

Entrepreneurship

S2E1: Andrew Atkinson, Software Engineer and Author

Hacking Postgres

35 minutes

1 year ago

S2E1: Andrew Atkinson, Software Engineer and Author

Andrew Atkinson is a Software Engineer who specializes in building high-performance web applications using PostgreSQL and Ruby on Rails. He wrote the book ‘High-Performance PostgreSQL for Rails’, published by Pragmatic Programmers in 2024.

Our discussion with Andrew spans the technical challenges of sharding and the concurrent evolution of Rails and Postgres. We'll pay homage to influential resources like Railscast, debate Rails' database tooling limitations, and discover tips from Andrew's new book.

In this episode we explore:

Why newer developers favor Postgres over MySQL
How Postgres might become a multi-primary database in the future
The complexities of database decisions in a Rails environment
Postgres innovations, such as composite primary keys and common table expressions, being supported from Active Record – the ORM for Ruby on Rails
Key insights from writing ‘High Performance PostgreSQL for Rails’

Links mentioned:

Andrew Atkinson on LinkedIn

‘High Performance PostgreSQL for Rails’ by Andrew Atkinson

Github rideshare

Postgres FM

Andrew Aktkinson’s interview on Postgres FM

Andrew Atkinson’s interview on Remote Ruby

Remote Ruby Podcast

GitHub doc: clarify logical decoding's deadlock of system tables

GitHub doc: Doc: fix grammatical errors for enable_partitionwise_aggregate

GitHub Convert README to Markdown