Go offline with the Player FM app!
Rails + Postgres
Manage episode 403999952 series 3369151
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
109 episodes
Manage episode 403999952 series 3369151
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
109 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.