Fun with Datasette

SQLite is the world's most widely deployed database, but the single local file nature and mediocre sqlite3 Python stdlib module make it not very fun to play with.

Thankfully, sqlite-utils and datasette by simonw solved most of my pain points when working with SQLite, and now I love exploring what the relational database has to offer and I've been using it in many of my projects, and deploying it everywhere!

My Datasette Instances

Personal

See also: posts tagged data for more details about these projects.

• Data of this blog: https://data.teddysc.me (Private: https://pdata.teddysc.me)
• For gallery.teddysc.me (with embeddings and classifications): https://gallery-data.teddysc.me
• For microfeed.teddysc.me: https://microfeed-data.teddysc.me

Research

• https://kelly.datasette.teddysc.me (https://github.com/tddschn/llm-gender-bias-public)
  • See also Exploring In-Browser Data Analysis Solutions

and another 20+ private instances for various projects.

Just messing around

• https://ncsu-arc-datasette.teddysc.me/ncsu-arc/nodes (Data Collection and Manipulation on the Command Line)