“You will write ahead logs in Postgres or binlog in MySQL… replay the changes into a new system when the new schema… essentially zero application code changes.”
Sahil Walia · Software Engineering Radio - the podcast for professional software developers · Sahil Walia on Schema Changes and Data Migrations
Play from 40:50
40:50
Audio streams from the publisher’s own feed. Verbatim does not host or copy it.
What was described
enable logical replication (Postgres WAL or MySQL binlog) and replay the transaction log into the new schema in real time
Said nearby on the same subject
“I use Supabase, which is just a great database as a service... I can import and export, you know, Postgres or SQL... I have it replicated back to a cloud backup just so I always have my data”
“We put a lot of effort into real-time monitoring as these models are working, making sure you have good telemetry into what's happening and can intervene in real time”
“The shared folder is that bar… there’s a folder of real accepted work… runbooks… rules file… corrections log… these turn agents into something you can actually trust.”
“Experienced logging issues… photo and say, hey, this photo is an indicator of this problem… real-time location services and moisture meters… upload that data and give the model greater context”