hmm, that is a tricky situation and I've found myself there a few times.
I feel like it might need a third source of information, like a schema that remembers database shape/state. Then, when you switch branches, you could do a `dbdiff` or something to get the differences between schema and database? I'm sure there's a ton I'm simplifying and leaving out, of course.
Well, wait (lol, you get train of thought), you _should_ be able to reconstruct the shape of the database purely from the migrations. So shape that db in memory, then compare to the actual database shape. Produce a diff and then :magic: and you run the correct SQL commands to match the database to the migrations.
klove 🐍🦀 /
npub1ma…4zj7v
2024-09-05 17:21:06
in reply to nevent1q…d6fg
Author Public Key
npub1mac22g92f9xgxjzujy0zqmgtqqjq6xv5mhat5szr5vw33a9q44tsr4zj7vPublished at
2024-09-05 17:21:06Event JSON
{
"id": "1a0a0049d58e3f683e83e4ebaaa44ed13e3413486d36b1e5a5084514f075d6c8",
"pubkey": "df70a520aa494c83485c911e206d0b00240d1994ddfaba4043a31d18f4a0ad57",
"created_at": 1725556866,
"kind": 1,
"tags": [
[
"p",
"df70a520aa494c83485c911e206d0b00240d1994ddfaba4043a31d18f4a0ad57"
],
[
"p",
"9c031ba3d4464f56ce895aff6098269c9ed4ff45f2a256ac82aca11db5ca97fe"
],
[
"e",
"d04b9ea43baee00d3efaddc293eee0d2b71b44639cce8074b4452a8b8355f8f5",
"",
"reply",
"9c031ba3d4464f56ce895aff6098269c9ed4ff45f2a256ac82aca11db5ca97fe"
],
[
"e",
"6fc26fb2b44bdd2de2cbe4b8cc033a3473a1d7ec15674109542f9a704d977fc2",
"",
"root",
"df70a520aa494c83485c911e206d0b00240d1994ddfaba4043a31d18f4a0ad57"
],
[
"proxy",
"https://tech.lgbt/@klove/113086094822226251",
"web"
],
[
"proxy",
"https://tech.lgbt/users/klove/statuses/113086094822226251",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://tech.lgbt/users/klove/statuses/113086094822226251",
"pink.momostr"
],
[
"-"
]
],
"content": "hmm, that is a tricky situation and I've found myself there a few times.\n\nI feel like it might need a third source of information, like a schema that remembers database shape/state. Then, when you switch branches, you could do a `dbdiff` or something to get the differences between schema and database? I'm sure there's a ton I'm simplifying and leaving out, of course.\n\nWell, wait (lol, you get train of thought), you _should_ be able to reconstruct the shape of the database purely from the migrations. So shape that db in memory, then compare to the actual database shape. Produce a diff and then :magic: and you run the correct SQL commands to match the database to the migrations.",
"sig": "fca21c16d3dd7744f03d54d00c96daf446b1480631cc8cd649a0dbfdc22d0fcfcc5164266388d971ed8822f383ebd3b62bd2723585624bffe99f1331b550994f"
}