Simon Willison’s Weblog

Subscribe

Wednesday, 16th December 2020

I get asked a lot about learning to code. Sure, if you can. It's fun. But the real action, the crux of things, is there in the database. Grab a tiny, free database like SQLite. Import a few million rows of data. Make them searchable. It's one of the most soothing activities known to humankind, taking big piles of messy data and massaging them into the rigid structure required of a relational database. It's true power.

Paul Ford

# 5:35 am / databases, paul-ford, sqlite

Release github-to-sqlite 2.8.2 — Save data from GitHub to a SQLite database
Release dogsheep-beta 0.10 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Monday, 14th December 2020
Thursday, 17th December 2020

2020 » December

MTWTFSS
 123456
78910111213
14151617181920
21222324252627
28293031