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.
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.
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.
Just bought his book!
Thanks so much!
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.
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.
Does Andy know Obie?
Rails? Nobody uses that 2007 technology anymore.
Django & PostgreSQL is heaven ❤
Well every time you commit code to GitHub or GitLab, guess what is being used;)
Haha who should we invite on to discuss Django + PostgreSQL?
@@NikolaySamokhvalovhaven’t both those sites suffered large hacks and database problems? 🤣🙄
I know many people at GH, all good.
@@michristofides Haki Benita could be a great guest to discuss Django and Rails!
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.