using datasette to explore sqlite .db files

[infominer]

I found this tool for exploring the sqlite files. I've been wondering, because the syntax for querying database is a bit arcane, from my perspective, what the simplest way to get started playing with these datasets?

Meet Datasette!

% pip3 install datasette

% datasette planetid.db

...

...

INFO:     Uvicorn running on http://127.0.0.1:8001 (Press CTRL+C to quit)

A tool for exploring and publishing data http://datasette.readthedocs.io/

[infominer]

Just found this related repository:

https://github.com/dogsheep/dogsheep.github.io

Dogsheep is a collection of tools for personal analytics using SQLite and Datasette.

Big internet companies know a lot about us. By exporting that data back out of them we can see what they know and maybe learn something interesting about ourselves.

Read more about Dogsheep on my blog: simonwillison.net/tags/dogsheep

Then there's a handful of tools for transforming your data exports from various services into sqlite, to be explorable via Datasette

• twitter-to-sqlite uses the Twitter API or Twitter's "export your data" zip archive to create a database of your tweets, followers, people you follow, favourited tweets and much more besides.
• healthkit-to-sqlite converts your Apple HealthKit export into a database, with details of your heart rate, workouts, step count and more.
• swarm-to-sqlite imports your checkin history from Foursquare Swarm.
• inaturalist-to-sqlite imports the wildlife and plants you have spotted on iNaturalist.
• google-takeout-to-sqlite imports data from Google Takeout, which can include your Google Maps location history, your search history on Google and more to come.
• genome-to-sqlite imports your genome from 23andMe into a SQLite database.
• github-to-sqlite imports repositories you have created or starred on GitHub.
• pocket-to-sqlite imports articles you have saved using Pocket.
• goodreads-to-sqlite by Tobias Kunze imports your reading history from Goodreads.
• pinboard-to-sqlite by Jacob Kaplan-Moss saves your bookmarks from Pinboard.