Backup script is nearly working, except it's changing the permissions/ownership of db files. Which breaks the blog. Which has cost me at least one entry. Poot.

If I want to create a container for running automated tests, I need to give it databases in a known state. I can use dotnet ef to create empty databases (TODO: Look up how to seed a database without creating a migration, or at least make it optional. I can use SQL scripts to populate most of my databases, but creating a password for a test user is a bugger).

Alright, it's the password that's the main blocker. Options:

• create a password using the ui (once) and copy it out of the db. Fiddly, but only once.
• Use the spectre cli stuff to add a create password/user mode to the app.

That second option I like a lot. Let's do that.