The Blog
Notes from the workbench: how the games, tools and full-stack products on this site get built, plus source-led dives into the history and symbolism behind Bodhastra. Architecture decisions, stubborn bugs and cultural rabbit holes — written to be useful, not to pad a feed.
Why Does Scorpio Have Three Symbols? The Strange History of the Scorpion, Eagle and Phoenix
The scorpion is ancient. The eagle and phoenix arrived by a stranger route. Here is the sourced history behind Scorpio’s three famous symbols.
SQL Dialects Explained: MySQL vs PostgreSQL vs SQL Server. MySQL, PostgreSQL and SQL Server Don't Speak the Same Language
LIMIT or TOP? IFNULL or COALESCE? Every database speaks its own SQL. A quick, practical tour of the dialect differences that trip developers up — and how to stop memorising them.
What gets written here
Mostly the things that cost me a weekend. A bug with an actual diagnosis rather than a workaround, an architecture decision and the two I rejected, a migration that went sideways for a reason worth writing down. The test for a post is whether it would have saved me the weekend if somebody else had written it first.
Much of it comes straight out of building the tools on this site. The SQL posts are the research behind Query Studio — dialect differences, execution order, why an index is being ignored. The Git posts come out of Git Rescue, which is 56 recovery guides that all started as something going wrong on a real branch. The browser-storage and table-extraction posts are the reasoning behind Storage Inspector and Table Grabber.
The rest is games. Unity, WebGL, and the specific misery of merging a scene file — which is a solved problem that almost nobody writes down properly.
There are also source-led cultural essays drawn from building Bodhastra — not generic horoscope copy, but investigations into where familiar zodiac ideas came from, when they entered the tradition, and where the surviving sources disagree.
No newsletter, no popup, no reading-list gate. There is an RSS feed if you want to know when something lands, and a page about who is writing it.
2 posts · Page 1 of 1