I wrote an epic introduction to the new JSON write API I introduced this week in the first of the Datasette 1.0 alphas.
The post includes two new demos and instructions on how you can try it out yourself:
Conversation
The first demo is an extension of a scraper I wrote a while ago with my shot-scraper browser automation tool
I now have a GitHub Actions workflow that scrapes news.ycombinator.com/from?site=simo and writes the data to this Datasette Cloud table using the new API simon.datasette.cloud/data/hacker_ne
read image description
ALT
1
1
9
... and once that scraped data is in Datasette, I can use the datasette.io/datasette/data datasette-atom plugin to turn it into an Atom feed, which I can then subscribe to in NetNewsWire!
read image description
ALT
2
5
The 2nd demo explores what it will be like to build apps that use Datasette as a read-write backend
You can try out a demo at todomvc.datasette.io - though be warned that I've configured it to drop the data every 15 minutes, so don't add anything that you want to keep!
GIF
read image description
ALT
Replying to
If you want to try out the API yourself you have two options: you can install it on your own machine (detailed instructions here: simonwillison.net/2022/Dec/2/dat), or click these links in turn:
latest.datasette.io/login-as-root - to sign in as root
latest.datasette.io/-/api - to try the API explorer
read image description
ALT
1
3