My first python package on PyPi: visible-to-sqlite
For a while now I’ve been working on-and-off with data I’ve exported from various apps and exploring it with Datasette. One set of data I’ve been particularly interested in exploring is from an app called Visible, a health tracker designed for various chronic illnesses.
Details
The code is up on GitHub and published to PyPi. It’s heavily inspired by healthkit-to-sqlite and the rest of the Dogsheep family, not to mention built on top of sqlite-utils, so huge shout out to Simon Willison who’s behind all these tools. If you’re familiar with Datasette or Dogsheep nothing here should be surprising, and even if you haven’t I think it’s still pretty straightforward to use!
Export and download your data
In the Visible app go to Profile > Data Export > Export CSV to download the file. Transfer it to your computer.
Install and run it
In your terminal, navigate to the directory with your export file.
Install it.
pip install visible-to-sqlite
Run it on your data.
visible-to-sqlite export.csv visible.db
And start exploring your data!
datasette visible.db