After I rushed a merge of #429 for a user, I would like to keep these follow up ideas from that PR:
I like sqlite/global.ts. I also like "account-scoped" or "account- or org- scoped". All reasonable options.
Reading these docs did make me wonder if we could create an account-wide sqlite admin view, like we have for global blob storage, given that you already made the UI, @tmcw! Maybe go for it if fast and easy? Almost feels like a waste not to (unless it's harder than I realize)
I'd love the docs to have an "upgrade from global" section (though I'm not sure what the best name is) that explains how to upgrade from the old to the new sqlite.
I accomplish it here in this video: https://www.youtube.com/watch?v=hyb3ZDvAO9I and there are some things to learn there
The migration script is pretty straightforward: https://www.val.town/x/stevekrouse/dateme/branch/main/version/135/code/MIGRATE.ts
I did find that the new sqlite client wasn't 100% compatible with how I was using the old sqlite client, but it was a relatively quick fix (covered in the video)
After I rushed a merge of #429 for a user, I would like to keep these follow up ideas from that PR:
I like
sqlite/global.ts. I also like "account-scoped" or "account- or org- scoped". All reasonable options.Reading these docs did make me wonder if we could create an account-wide sqlite admin view, like we have for global blob storage, given that you already made the UI, @tmcw! Maybe go for it if fast and easy? Almost feels like a waste not to (unless it's harder than I realize)
I'd love the docs to have an "upgrade from global" section (though I'm not sure what the best name is) that explains how to upgrade from the old to the new sqlite.
I accomplish it here in this video: https://www.youtube.com/watch?v=hyb3ZDvAO9I and there are some things to learn there
The migration script is pretty straightforward: https://www.val.town/x/stevekrouse/dateme/branch/main/version/135/code/MIGRATE.ts
I did find that the new sqlite client wasn't 100% compatible with how I was using the old sqlite client, but it was a relatively quick fix (covered in the video)