On: Show HN: Datasette – Create and publish an API for SQLite databases

[toomuchtodo]

You would run this on the same VM or other compute as your SQLite database. You should still be able to perform scheduled updates (cron?) to the underlying SQLite database.

[technomalogical → toomuchtodo]

The database is opened immutably, so my guess is you’d either make a copy and update or regenerate it from another source (a la Simon’s CSV to sqlite tool. You could have a symlink that points to the current DB