News for hackers. Stuff that matters.
Re:Show HN: Datasette – Create and publish an API for SQLite... by toomuchtodo on Monday November 13, 2017 @09:04PM (#15692030)
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.
Re:Show HN: Datasette – Create and publish an API for SQLite... by technomalogical on Tuesday November 14, 2017 @09:52PM (#15701135)
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