Steampipe.io lets you run sql against a variety of services, including hypothes.is. This strikes me as a nice way to perhaps develop a workflow from hypothesis to obsidian (there are any number of ways one could do this).
These are my notes for getting it up and running.
At the terminal, with brew installed (running on mac)
brew tap turbot/tap
brew install steampipe
steampipe plugin install hypothesis
Then add my developer key for hypothesis to the config file for steampipe, which lives at
There is a dashboard for hypothesis at https://github.com/turbot/steampipe-samples/tree/main/all/hypothesis . Copy those files to text editor, save with .sp extension. Then at the terminal, fire ’em up with
Queries can be run at the query prompt, via
. Or you can save your queries as a file, and pipe the results to output. So, I make an empty file and put this query into it:
query = 'tag=media&tag=review';
I save it as `query1`, no file extension. Then, at the terminal prompt,
$ steampipe query query1 > output.csv
The resulting output file actually uses the `|` character as a separator, so once I remember to specify that when opening in Excel, a lovely file of annotations. I have to run now, but I can see opening this file in Obsidian.md and then refactoring it so that I end up with one note per annotation.
…god I hate the gutenberg editor here on wordpress.com. It sucks…