Rails + Postgres

Postgres FM

Michael and Nikolay are joined by Andrew Atkinson, author of High Performance PostgreSQL for Rails, to discuss how Rails and Postgres work together — where the limits are, how people use the ORM, things that are improving, and some things we can do as a Postgres community to make it even better.
Here are some links to things they mentioned:

• Planet Argon survey https://rails-hosting.com/2022/#databases
• Active Record https://guides.rubyonrails.org/active_record_basics.html
• PostgreSQL specific usage of Active Record https://guides.rubyonrails.org/active_record_postgresql.html
• Multiple Databases with Active Record https://guides.rubyonrails.org/active_record_multiple_databases.html
• schema.rb vs structure.sql https://blog.appsignal.com/2020/01/15/the-pros-and-cons-of-using-structure-sql-in-your-ruby-on-rails-application.html
• activerecord-clean-db-structure (Ruby gem by Lukas Fittl) https://github.com/lfittl/activerecord-clean-db-structure
• GitLab’s migration_helpers.rb https://gitlab.com/gitlab-org/gitlab/-/blob/master/lib/gitlab/database/migration_helpers.rb
• SQLite https://www.sqlite.org
• PlanetScale’s foreign key support announcement video https://twitter.com/PlanetScale/status/1732070818958500083
• DoorDash Engineering Blog https://doordash.engineering/blog
• rails-pg-extras https://github.com/pawurb/rails-pg-extras
• Benoit Tigeot testing Peter Geoghegan improvement for large IN lists https://gist.github.com/benoittgt/ab72dc4cfedea2a0c6a5ee809d16e04d
• High Performance PostgreSQL for Rails (Andy’s book, 35% discount code “postgres.fm”) https://pragprog.com/titles/aapsql/high-performance-postgresql-for-rails
• Andy’s blog and website https://andyatkinson.com

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

• Michael Christofides, founder of pgMustard
• Nikolay Samokhvalov, founder of Postgres.ai

With special thanks to:

• Jessie Draws for the elephant artwork