Advertisement · 728 × 90

Posts by Lalit Maganti

Thanks! I'm glad someone appreciated it, I spent a bunch of time getting something that looked nice and also tuning the UX e.g. for highlighting the marker when you hover the footnote and vice versa!

4 days ago 1 1 0 0

I only hit the weekly rate limit on once, one day before it was going to refresh anyway. Apart from that, never hit another limit.

5 days ago 3 0 0 0

AI has no sense of time. It sees a codebase as a snapshot but doesn't feel why decisions were made, reversed, or avoided. Losing a senior engineer hurts a team for similar reasons; AI never had that institutional memory to begin with.

6 days ago 28 1 1 0

At several points, I lost the mental model of the codebase. I had become the engineering manager who doesn't actually understand the code, the exact person I used to complain about. AI makes it dangerous to stop owning the "why" behind your implementation.

6 days ago 41 6 1 0

AI coding is a slot machine. You prompt, wait, and hope for a win. At 1am, I’d think "one more prompt" instead of actually solving the problem. When I got tired, my prompts got vague and the output got worse, but I’d just pull the lever again anyway.

6 days ago 39 4 2 1
Eight years of wanting, three months of building with AI For eight years, I’ve wanted a high-quality set of devtools for working with SQLite. Given how important SQLite is to the industry1, I’ve long been puzzled that no one has invested in building a reall...

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...

6 days ago 202 38 15 12

The result is a CLI and LSP that gives you rustc-style diagnostics for things like CTE column mismatches and function typos, all without needing an active database connection.

I wrote a full breakdown of the implementation and why 1:1 fidelity matters so much to me here:
lalitm.com/post/syntaql...

3 weeks ago 0 0 0 0

Writing a hand-rolled parser is where so many tools fall over, so syntaqlite uses SQLite’s own Lemon-generated grammar, adapted into a C/Rust stack.

If SQLite accepts it, syntaqlite does too. I tested it against 396k statements from the official SQLite test suite and got 99.7% agreement.

3 weeks ago 0 0 1 0
syntaqlite: high-fidelity devtools that SQLite deserves Most SQL tools treat SQLite as a “flavor” of a generic SQL parser. They approximate the language, which means they break on SQLite-exclusive features like virtual tables, miss syntax like UPSERT, and ...

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.

3 weeks ago 2 0 1 0
Rendering 100k trace events faster with exponential search We’ve recently been looking into optimizing rendering performance of the Perfetto UI on large traces. We discovered that there was some inefficiency in our data fetching logic, especially when you’re ...

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...

2 months ago 2 0 0 0
Advertisement

They basically solve two problems caused by AI coding agents:
1) Sandboxing to reduce the chances prompt injection ruining your life
2) Having "clean slates" where you can prototype freely and fast
All in all, I'm semi-won over. Won't be paying every month but it's a tool to add to the toolbelt.

2 months ago 2 0 0 0

Initially, I was very confused why these were getting so much attention given that Linux VPSes have been a thing for 2 decades but after trying them out and reflecting, I think I have an answer.

2 months ago 1 0 1 0
The surprising attention on sprites, exe.dev, and shellbox Over the last few weeks, three new products have announced themselves on Hacker News to great success, each making the frontpage: Sprites (fly.io) with 508 votes and hit #7 exe.dev with 457 votes and ...

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...

2 months ago 7 2 1 0
venn diagram. circles labeled "Angled lines" and "Different angled lines", they are filled with patterns of slightly different angled lines. the intersecting area is labeled Moire pattern and indeed has a moire pattern in it.

venn diagram. circles labeled "Angled lines" and "Different angled lines", they are filled with patterns of slightly different angled lines. the intersecting area is labeled Moire pattern and indeed has a moire pattern in it.

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

3 months ago 29 157 10 0

It's the guide I wish I had when I first started 3 years ago.

It covers how to build a comprehensive plain-text accounting system with Beancount. We're talking 18 accounts, 3 currencies and maximal automation.

🔗 lalitm.com/post/one-num...

3 months ago 0 0 0 0
One Number I Trust: Plain-Text Accounting for a Multi-Currency Household Two people. Eighteen accounts spanning checking, savings, credit cards, investments. Three currencies. Twenty minutes of work every week. One net worth number I actually trust. The payoff: A single, t...

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! 👇

3 months ago 1 0 1 0

You don't have to be a "Solver" dropping into fires. You can be an "Architect" building the foundation.

It’s okay to trade external validation for deep technical ownership.

Full essay here: lalitm.com/software-eng...

4 months ago 1 0 1 0
Advertisement

The mental model that saves me is the "Shadow Hierarchy."

I don't worry about impressing my VP. I worry about the Staff engineers in Pixel and Chrome telling their VPs: "We literally cannot debug the next phone without this tool."

That is un-fakeable influence.

4 months ago 1 0 1 0

In product, speed is currency. In infra, context is currency.

If you rotate teams every 18 months to chase the "spotlight," you never gain the pattern matching required to solve systemic problems. You fix bugs, but you don't build leverage.

4 months ago 1 0 1 0
Why I Ignore The Spotlight as a Staff Engineer Lately I’ve been reading Sean Goedecke’s essays on being a Staff+ engineer. His work (particularly Software engineering under the spotlight and It’s Not Your Codebase) is razor-sharp and feels painful...

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.

4 months ago 2 1 1 0

The secret sauce: gamification (leaderboard + t-shirts), hard limits (no bug >2 days), and critical mass (~40 people creates real momentum).

#EngineeringManagement #SoftwareEngineering #ProductProductivity

4 months ago 2 0 0 0
Burndown graph of bugs fixed

Burndown graph of bugs fixed

The results? 189 bugs fixed. A 2021 feature request finally implemented (took just 1 day!). Team morale through the roof. And users actually notice the polish.

4 months ago 1 0 1 0
We stopped roadmap work for a week and fixed 189 bugs It’s Friday at 4pm. I’ve just closed my 12th bug of the week. My brain is completely fried. And I’m staring at the bug leaderboard, genuinely sad that Monday means going back to regular work. Which is...

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.

4 months ago 1 0 1 0
TIL: Number in man page titles (e.g. sleep(3)) If you do Linux systems programming, you will have likely pored over man pages, either on the command line or, my personal preference, using the excellent man7.org or linux.die.net. I’ve always seen t...

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...

4 months ago 0 0 0 0
Preview
When Good Technical Writing Isn't Enough A response to "Don't Build an Audience"

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

4 months ago 2 0 0 0
Advertisement
When Good Technical Writing Isn't Enough Last week, I came across Don’t Build an Audience. It’s a fascinating post and has been occupying a lot of my “free thinking” time. I strongly suggest reading it as it’s well written and excellently ar...

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...

4 months ago 1 0 0 0
Preview
CAST(x AS STRING) casts to integer in SQLite Plus TIL: Diátaxis: Systematic technical documentation

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

4 months ago 0 0 0 0
CAST(x AS STRING) casts to integer in SQLite As an “SQLite consultant” for my local area of Google, I often have people come to me having written SQL like: SELECT CAST(bar AS STRING) AS baz FROM foo and ask me “Why is baz always an integer?! Hav...

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...

5 months ago 0 0 0 0
TIL: Diátaxis: Systematic technical documentation A few weeks ago, I wrote about “The Documentation System” and how valuable I found it. As I dug deeper into researching how best to apply the principles outlined there, I came across Diátaxis. Written...

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...

5 months ago 0 0 0 0