Blog archive
231 of 231 articles
I Was Never Trying to Become a Better Component
From allergy to IgE, from an external brain to AI, and from Mobin to Mobin-less
Building a Resilient Event-Driven Data Lakehouse: MinIO Bucket Notifications to Apache Kafka
Eliminate object storage polling and prevent race conditions using MinIO’s native Kafka notification engine and the Sentinel Marker pattern.
From a 49-Second KPI Request to an 840-Millisecond Response
Introduction A customer-reported issue initially appeared to be a backend or database performance problem. A KPI request with thousands of selected elements was taking almost 50 seconds to complete, which was unacceptab…
One Pipeline, Three Ways to Consume It: Designing Multi-Channel KPI Distribution on ClickHouse
Every hour, our pipeline turns 15 million raw measurement rows into hundreds of per-cell, per-technology KPIs and writes them to ClickHouse. I’ve written before about how we keep that calculation correct — partitioned…
From Database-Backed Sessions to JWT Authorization in NestJS
An AI-assisted migration guided by a detailed SRS and protected by end-to-end tests
Vibe Coding Your Everyday Math: Turning Personal Questions into Small, Trustworthy Tools
Most of the decisions we agonize over in daily life are really just messy calculations wearing a disguise. Should I rent or buy? Which grocery run actually costs less per meal? Is this loan offer better than that one?…
Generate a Guided Wizard for End Users from the Derived Flow Graph
Turning your backend, frontend, e2e tests, and Swagger spec into a queryable knowledge graph — and using it to build a smarter, AI-assisted…
How I Would Build MobinAI: A GraphRAG Chatbot for 200+ Technical Articles
I have published more than 200 technical articles covering Go, PostgreSQL, ClickHouse, Kafka, system design, backend architecture, and artificial intelligence.
Why Large Database Refactors Need Isolated Development Databases
A practical workflow for running legacy and refactor branches safely when their migration histories diverge
Query Federation: A Practical Guide to Modern Data Virtualization
How to query everything without moving anything Why This Matters Every growing engineering org eventually hits the same wall: data ends up scattered across a relational database here, a warehouse there, a pile of Parque…
Stop Picking an AI Model. Start Picking a Capability.
Why I built a gateway that routes coding agents by job, not by vendor
How I Made a Chatbot With My Knowledge: Turning My Technical Articles into a GraphRAG Assistant
As software engineers, our personal blogs and notes often end up as chronological archives — hundreds of Markdown files, JSON payloads, and code repositories scattered across years of work. Traditional vector search…
Me Against Myself: From Rebellious Idealism to Pragmatic Systems Thinking
From "your system is not open source" to "how can I change your system's properties" I have spent twelve years arguing with people who build closed systems. I did not notice, until recently, that the longest, most exhau…
Unified AI Orchestration: Setting Up 9router, Model Combos, and Cline in VS Code
When working with autonomous coding agents like Cline, managing multiple upstream AI providers — such as Google AI Studio, OpenRouter, and premium OAuth subscriptions — quickly becomes a maintenance bottleneck. Rate…
Complete Technical Migration Strategy: Migrating Legacy Django Auth to Keycloak & OpenFGA via ETL
A production-ready, four-phase ETL strategy for migrating legacy Django authentication to Keycloak and fine-grained authorization to OpenFGA.
From 3NF MySQL to Fast Search: Building a CDC-Powered Read Model
Normalized MySQL is great for writing data correctly. It’s not great for serving it fast. Once a project entity spans tasks, members, documents, orders, and comments, every “project overview” request turns into a wall o…
Architecting Search Engines: A Deep Dive into Meilisearch Internals, Vector Retrieval, and Algolia
The design of application search has undergone a fundamental transformation over the past decade. Traditionally, software architectures relied on either SQL relational string operations (LIKE '%term%') or heavy analytic…
Architecting an Open-Source Search Engine: From Algolia Internals to Vector Similarity and Qdrant
High-performance discovery platforms demand sub-50ms query latency, search-as-you-type prefix matching, real-time data synchronization, and semantic vector retrieval. Commercial SaaS solutions like Algolia have long dom…
How an AI Prompt Turned a Complex Multi-Database ETL Project Into Hours of Work
In large organizations, data rarely lives in one place. Some information is stored in Oracle databases, while other datasets live in PostgreSQL.
When Your Domain Talks to Stripe, A DDD Cautionary Tale
A real-world dissection of a circular dependency in a billing module, and how Domain-Driven Design gives you the vocabulary — and the tools…