Building a Low-Cost Go RAG Chatbot with pgvector, Semantic Caching, and Payload CMS
How showmic-bot combines Go stdlib net/http, pgx, Neon pgvector, multi-tier semantic caching, and Payload CMS syncs to stream grounded answers for pennies.
Writing
Production notes on PostgreSQL indexing over tens of millions of rows, Neon serverless branching, secrets management with Doppler, Go + pgvector RAG pipelines, and AWS/cloud infrastructure trade-offs. Every guide focuses on latency, operational cost, and failure modes observed in live systems.
How showmic-bot combines Go stdlib net/http, pgx, Neon pgvector, multi-tier semantic caching, and Payload CMS syncs to stream grounded answers for pennies.
A production comparison of running Next.js App Router on Netlify, Cloudflare Workers (OpenNext/vinext), and Railway standalone containers.
Practical PostgreSQL indexing lessons from a 50M-row legacy migration: composite B-Tree column ordering, GIN tsvector vs pg_trgm, and keyset pagination.
Contact
If you're hiring for a Staff, Principal, or Lead role (remote or onsite), or building something in healthcare, fintech, or AI, email me and we can talk it through.
Open to full-time and part-time roles (remote or onsite)
Also on Toptal. Email is the best way to start a conversation.