Just dropping in (long time HN lurker, first time HN poster) to say thanks for such a great capability in datasette and datasette-lite. I use sqlite_utils in numerous solutions to insert/upsert various json data into sqlite databases for various purposes. I use datasette/datasette-lite to host data products for consumers who need rapid insight but are not "sql jockeys."

I think this mutation capability would be great for some of my data logging workflows. I push json formatted telemetry data from different types of devices/sensors over tailscale to a central collector. Combined with clickhouse's adapter to sqlite databases, this could make for a very nice self-contained data reporting framework where all the source data flows through datasette to a set of sqlite files organized by topic. It will be important to me in deploying new event senders to have straightforward authentication I can bake pre-authenticated connection schemes into standard images that are installed without customization. Alternatively, configuring datasette so a specific set of ip addresses / cidrs is just granted insert to specific dbs/tables would work fine.

Thanks again. Great stuff!