Teaching My Chat App to Query Databases — A Text-to-SQL Agent
How I built a local text-to-SQL agent using Ollama tool calling and Gemma3, replacing the tedious SSH-psql-query workflow with natural language questions in a chat interface.
Resolving Dependencies,
One Idea at a Time.
A logbook of building and scaling data systems in the real world. I write about data engineering, distributed systems, analytics infrastructure, and the lessons that only show up in production.
5
Posts
18
Topics
Welcome
This is my running notebook from production—wins, failures, tradeoffs, and the thinking behind technical decisions. Less theory, more reality.
Latest Posts
Building an AI Chat System with Practical Memory, Search, and Multimodal Intelligence
A behind-the-scenes engineering deep dive into building a production AI chat system. Memory management, context compression, web search integration, and the infrastructure decisions that make it work.
Deploying to the Cloud: My Infrastructure Journey
From GCS buckets and expensive load balancers to Firebase's serverless architecture. A journey through cost optimization, architecture decisions, and lessons learned deploying a production portfolio site.
Building a Production K3s Blog: Architecture Deep Dive
From a mini PC to a full production blog platform. Deep dive into the K3s architecture, monitoring stack, GitOps deployment, and lessons learned running a self-hosted blog on a homelab cluster.
Two Sites, Two Paths
Firebase for a serverless portfolio versus a self-hosted Kubernetes cluster for a full-featured blog. Why I chose different deployment strategies for different needs, and what I learned from each.