Posts tagged #architecture
2 posts
-
AI Agents & SQL
Teaching My Chat App to Query Databases — A Dual-Model Text-to-SQL Agent
How I built a local text-to-SQL agent using two specialized models — Gemma3 for conversation and Qwen3 for tool calling — replacing the tedious SSH-psql-query workflow with natural language questions. Everything runs locally, nothing leaves my server.
-
LLM Systems
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.