Mar 01 2024 45 mins 37
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
