Postgres FM | Rails + Postgres

March 1, 2024 • 45 Minutes

Rails + Postgres

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: