Browsing Tag
database
207 posts
Insert Operation: How a B+-Tree Grows Without Losing Order
Hello, I’m Maneshwar. I’m working on git-lrc: a Git hook for Checking AI generated code. AI agents write…
Manticore Search 17.5.1
Manticore Search 17.5.1 has been released. This maintenance release includes bug fixes, minor improvements, and updated recommended library…
Prometheus #1
Why We Use Grafana Alongside Prometheus In modern systems, we usually have servers and workloads running across different…
Pager Lifecycle Functions: Pinning Pages, Running Transactions, and Making Them Stick in SQLite
Hello, I’m Maneshwar. I’m working on FreeDevTools online currently building “one place for all dev tools, cheat codes,…
🚀 How We Reduced API Response Time by 60% in Node.js Using Caching, Query Optimization & Performance Profiling
Performance issues in backend systems rarely come from one obvious bug. In our production system, a high-traffic API…
Concurrency Control and Database Recovery in SQLite
Hello, I’m Maneshwar. I’m working on FreeDevTools online currently building **one place for all dev tools, cheat codes,…
EP 6.3: Master-Slave Architecture
In system design, the Master-Slave (or Leader-Follower) architecture is one of the most fundamental patterns used to achieve…
An Algebraic View of Databases
Hello, I’m Maneshwar. I’m working on FreeDevTools online currently building **one place for all dev tools, cheat codes,…
SQLite in Python: The Underrated Database for Side Projects
Stop spinning up Postgres for every project. SQLite might be all you need. Why SQLite? Aspect SQLite Postgres…
Context Mesh Lite: Hybrid Vector Search + SQL Search + Graph Search Fused (for Super Accurate RAG)
I spent WAYYY too long trying to build a more accurate RAG retrieval system. With Context Mesh Lite,…