Pontifications

Using Checkvist, I’m tagging and taking Firefox desktop user feedback with notes and notes (e.g. see Checkvist SUMO notes and tags for Firefox 66)
Checkvist is great but it’s not a searchable database and it’s not something others can query.
So my idea is to use the Checkvist API, and some software (hah! but easy since I’ve done this countless times with MongoDB) and convert to JSON, store the JSON in SQLite and host the SQLite via datasette (see How to turn a list of JSON objects into a Datasette) in the cloud. That way other folks who don’t want to work with outlines and don’t know to work with outlines but do know SQL can easily query using SQL or JSON API.
Previously relevant:
- checkvist has a nice open api for making expandible/collapsible html from checkvist outlines
- cvss-to-sqlite Prequel to blog post about Datasette: Convert CSV files into a SQLite database. Browse and publish that SQLite database with Datasette