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.
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.
This is my running notebook from production—wins, failures, tradeoffs, and the thinking behind technical decisions. Less theory, more reality.
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.
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.
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.
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.
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.
Have a suggestion or found an issue? Let me know!