Тёмный
No video :(

Rails + Postgres | Postgres.FM 086 |  

PostgresTV 💙💛
Подписаться 4,1 тыс.
Просмотров 326
50% 1

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RU-vid's auto-translation of them from English to your language; try it and share it with people interested in 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 rails-hosting....
* Active Record guides.rubyonr...
* PostgreSQL specific usage of Active Record guides.rubyonr...
* Multiple Databases with Active Record guides.rubyonr...
* schema.rb vs structure.sql blog.appsignal...
* activerecord-clean-db-structure (Ruby gem by Lukas Fittl) github.com/lfi...
* GitLab’s migration_helpers.rb gitlab.com/git...
* SQLite www.sqlite.org/
* PlanetScale’s foreign key support announcement video / 1732070818958500083
* DoorDash Engineering Blog doordash.engin...
* rails-pg-extras github.com/paw...
* Benoit Tigeot testing Peter Geoghegan improvement for large IN lists gist.github.co...
* High Performance PostgreSQL for Rails (Andy’s book, 35% discount code “postgres.fm”) pragprog.com/t...
* Andy’s blog and website andyatkinson.com/
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
Check out postgres.fm to subscribe to the audio-only podcast, see guest profiles, and more.

Опубликовано:

 

27 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@patrick99e99
@patrick99e99 5 месяцев назад
Just bought his book!
@andatki
@andatki 5 месяцев назад
Thanks so much!
@Drgnslyr123
@Drgnslyr123 5 месяцев назад
It's easier to make changes as a dev when you don't have to reverse walk the migrations to grab the latest source of truth. What I do is store all functions, tables, triggers, etc in separate files, then I have another file that determines the order and structure. It runs this into something called a shadow DB then we diff it with your live dev DB to generate migrations.
@andatki
@andatki 5 месяцев назад
Is this available as open source code? I am curious about the idea of a shadow DB and whether that makes the DX of schema evolution faster or easier. One practical limitation I've experienced is that making any schema changes requires having the full application environment installed and configured, and this tight coupling feels unnecessary in some scenarios.
@pycontiki
@pycontiki 5 месяцев назад
Does Andy know Obie?
@pycontiki
@pycontiki 6 месяцев назад
Rails? Nobody uses that 2007 technology anymore. Django & PostgreSQL is heaven ❤
@NikolaySamokhvalov
@NikolaySamokhvalov 6 месяцев назад
Well every time you commit code to GitHub or GitLab, guess what is being used;)
@michristofides
@michristofides 5 месяцев назад
Haha who should we invite on to discuss Django + PostgreSQL?
@pycontiki
@pycontiki 5 месяцев назад
@@NikolaySamokhvalovhaven’t both those sites suffered large hacks and database problems? 🤣🙄 I know many people at GH, all good.
@andatki
@andatki 5 месяцев назад
@@michristofides Haki Benita could be a great guest to discuss Django and Rails!
@andatki
@andatki 5 месяцев назад
Interestingly, the Python language is even older than Ruby (1991 vs. 1995) and the Rails framework came out a bit before Django, around 2004 or 2005. Do you know of some things in Django for PostgreSQL that you prefer to what Rails offers? Always curious to see what things look like in other frameworks.
Далее
ChatGPT for Data Analytics: Full Course
3:35:30
Просмотров 255 тыс.
Solving distributed systems challenges in Rust
3:15:52
Просмотров 230 тыс.