siddhartha.work
HomeBlogAbout
siddhartha.work

Writing

Technical deep-dives and thoughts on building systems.

Tags:aiarchitecturesoftware-engineeringmcpsearchsqliteastretrievalcontextospostgresqlmongodbdatabasemigrationbackendjsmonnode.jsgostartupperformance
Why AI Coding Agents Get Lost in Large Codebases
Aug 6, 2026•3 min read•
---
Why AI Coding Agents Get Lost in Large Codebases
Modern large language models are becoming dramatically better at reasoning about code. Yet, developers still struggle to get consistent, accurate answers from AI coding assistants.
aiarchitecturesoftware-engineeringmcp
Designing a Local-First Context Engine for AI Coding Assistants
Aug 4, 2026•8 min read•
---
Designing a Local-First Context Engine for AI Coding Assistants
Why AI coding assistants don't need more context—they need better context.
aisearcharchitecturesqlite+3 more
MongoDB to PostgreSQL Migration: What We Learned Moving 130M Rows
Apr 29, 2026•14 min read•
---
MongoDB to PostgreSQL Migration: What We Learned Moving 130M Rows
We migrated 2M MongoDB documents to 130M PostgreSQL rows — not because we were broken, but because we could see the break coming. Here's the full story.
postgresqlmongodbdatabasemigration+7 more

siddhartha.work

SDE at Jsmon · Competitive Programmer · Writing about systems, databases, and AI engineering

Quick Links

  • Home
  • Blog
  • About

Subscribe to my newsletter

Get an email whenever I write a new post. No spam, ever.

© 2026 Siddhartha Katiyar. All rights reserved.