SQLite Tags Benchmark: Comparing 5 Tagging Strategies
Research: SQLite Tags Benchmark: Comparing 5 Tagging Strategies
I had Claude Code run a micro-benchmark comparing different approaches to implementing tagging in SQLite. Traditional many-to-many tables won, but FTS5 came a close second. Full table scans with LIKE queries performed better than I expected, but full table scans with JSON arrays and json_each() were much slower.
š¬ In the Mouth of Madness

Hm. Somehow, the plot was a bit unsatisfactory. But there's still lots to like: the theme song is one of my favourites by Carpenter, the gory practical effects are great, I liked the characters, the humour, the atmosphere. Good one, but (after first watch) not my most-liked Carpenter film.
š Recommended!
19.03.2026
18.03.2026
300+ issues of the UK music magazine NME from 1969-1983...
300+ issues of the UK music magazine NME from 1969-1983. The ads alone are incredible.
Daring Fireball
⢠John Gruber
StopTheMadness Pro and StopTheScript Extensions for Safari
Daring Fireball
⢠John Gruber
Actual Headline in the Actual New York Times: āTrump Jokes About Pearl Harbor in Meeting With Japanās Leaderā
Javier C. HernƔndez, reporting for The New York Times:
He was responding to a question about why Japan and other allies had received no advance notice of the U.S.-Israeli assault on Iran.
āWe didnāt tell anybody about it because we wanted surprise,ā he said. āWho knows better about surprise than Japan, OK? Why didnāt you tell me about Pearl Harbor, OK? Right?ā
There was some laughter from the officials and journalists gathered in the room. āYou believe in surprise, I think, much more so than us,ā he added.
As Trump sinks further into dementia and his presidency slides further into disarray, his administration, in a sick way, gets funnier and funnier.
Link: nytimes.com/2026/03/19/us/politics/trump-japan-pearl-harborā¦
Daring Fireball
⢠John Gruber
āEveryone but Trump Understands What Heās Doneā
ā The Tenth Muse is an art discovery engine. Over...
āThe Tenth Muse is an art discovery engine. Over 120,000 artworks from museums and institutions ā searchable by feeling, mood, atmosphere, era, and medium.ā
Daring Fireball
⢠John Gruber
The Day Mark Simonson Discovered Type Design
marksimonson.com/notebook/view/the-day-i-discovered-type-design/
Mark Simonson:
Just by coincidence, I discovered a copy of U&lc magazine in the graphics classroom. U&lc was published by ITC, the International Typeface Corporation, a typeface publisher, and the designer and editor was the legendary Herb Lubalin. Iād never seen such beautiful typography and design. It was a motherlode for an aspiring typophile like me. [...]
I decided right then that someday, somehow, I wanted to design typefaces.
Link: marksimonson.com/notebook/view/the-day-i-discovered-typeā¦
Daring Fireball
⢠John Gruber
Googleās New Sideloading Restrictions for Android Include a 24-Hour Waiting Period
androidauthority.com/google-android-sideloading-unverified-apps-new-rules-3650343/
Typos Have Plagued Us for Centuries . Thereās the...
Typos Have Plagued Us for Centuries. Thereās the 1631 Bible that says āthou shalt commit adulteryā but James Joyce resisted some of his corrections: āThese are not misprints but beauties of my style hitherto undreamt of.ā
Paris now has a cycling network bigger than Amsterdam...
Paris now has a cycling network bigger than Amsterdam and āmore daily trips in Paris are now made by bike than by carā.
Daring Fireball
⢠John Gruber
Hacker News Discussion on Shubham Boseās āThe 49MB Web Pageā
683: I Didnāt Want to Melt My Rug
The Human City

Photographer and drone pilot Pio Andrea Peri captured this overhead photo of a Sicilian city called Centuripe. Perched atop hilltops, the city looks like a person from above ā even on Google Maps. (via daily overview)
Tags: drones Ā· pareidolia Ā· photography Ā· Pio Andrea Peri
Thoughts on OpenAI acquiring Astral and uv/ruff/ty
Oil and gas prices surge after energy plant strikes
Daring Fireball
⢠John Gruber