Writing
Notes on building a universal database IDE — engineering, security, product and the occasional rant.
Letting a language model write SQL once is easy. Letting it recover from a real database error — five times in a row — turns out to take an opinionated little state machine. Here's what's inside ours.
Read articleEvery connection string in DB AI Magic is sealed with AES-256-GCM before it touches our database. A walk through the key hierarchy, decrypt budget and audit story.
Read articleHow we stream paged result sets from Postgres into AG Grid over a Socket.IO channel, cancel mid-flight, and keep the UI responsive when a query goes long.
Read articlePlugging real table and column metadata into the Monaco language service so suggestions match your actual database — not a generic SQL grammar.
Read articleThe product principle behind DB AI Magic: an analyst, a PM and an engineer should all be able to safely talk to the same database without filing a ticket.
Read articleA single TypeScript interface, twenty-five wildly different wire protocols. What we learned about generalising the parts that matter — and resisting the temptation to generalise the parts that don't.
Read article