I just published a deep-dive into the 250-hour build behind syntaqlite, a SQLite formatter and LSP I built using AI agents. AI agents were the only reason built this after 8 years of wanting but there's a psychological toll to AI-assisted engineering. The post-mortem: lalitm.com/post/buildin...

For a long time, I’ve wanted a reliable, fast formatter and LSP for SQLite SQL. One that actually models SQLite’s weird/specific features, like virtual tables, application-defined functions, and the various flags that change the language. So I started building syntaqlite.

Hit a case in Perfetto where even the venerable binary search was still too slow! I ended up discovering an algorithm that I hadn't heard of before called exponential search. Wrote up what I learned at lalitm.com/post/exponen...

Just wrote up some thoughts after trying out all the "VPS as a service" products which reached the Hacker News frontpage over the past month - lalitm.com/trying-sprit...

I made a venn diagram to help you understand Moiré patterns.

Been quiet for the last few weeks because I was cooking this up! I know it's resolution season, so if you're engineering-minded and want absolute control over your money (handling everything from daily spend to cross-border investments) I wrote a blog post for you! 👇

I’ve been reading a lot of Staff+ advice that says you need to be "fungible," chase executive priorities, and move fast. As a Senior Staff engineer in infra/devtools, I found that advice is a recipe for burnout.

Every quarter, our 45-person eng team stops ALL roadmap work for an entire week. No new features. No meetings. Just fixing the small stuff that's been annoying us and our users.

I'm a bit ashamed to say it's only today I learned what the number in Linux man page titles (e.g. the "3" in `sleep(3)`) is: lalitm.com/til-number-i...

Just sent my latest newsletter rounding up the last week of posts to my blog: lalitm.substack.com/p/when-good-...

After reading a fascinating article called "Don't Build An Audience", I've been doing a lot of soul searching about the type of technical writing I like and how to get people to see it. Wrote down my thoughts in a new post: lalitm.com/on-why-i-wri...

Just sent my latest newsletter rounding up the last week of posts to my blog: lalitm.substack.com/p/castx-as-s...

After the nth time of explaining to someone why in SQLite `CAST(x as STRING)` casts to an integer, I decided to write something explaining why so I can just point people to it: lalitm.com/cast-x-as-st...

Wrote up a new discovery I made of Diátaxis (diataxis.fr). It, and it's precursor, the Documentation System, have revolutionized how I think about techinical documentation lalitm.com/til-diataxis...