Cache OpenAI Embeddings with SQLite for Low-Cost Astro Builds
Published
Welcome to my blog! I am a software engineer based in Southern California, and I love sharing my thoughts and
experiences about all things tech. From software development and programming to the latest tech trends and news,
you'll find it all here on my blog. Follow along to stay up to date and get insights from a real-life software
engineer living and working in SoCal. Thanks for visiting!
Latest Blog Posts
Avoid repeated OpenAI API calls by caching embeddings with SQLite. A lightweight, cost-effective solution to keep your Astro site builds fast and affordable. 
Refining “Similar Posts” for Relevance and Simplicity
PublishedAn inside look at improving the “Similar Posts” component using OpenAI embeddings and cosine similarity, with a clean 1–3 post display based on semantic relevance. 
Add 🤖 AI‑Powered Similar Posts 🔍 to Your Astro Blog — Here’s How
PublishedLearn how to enhance your Astro blog with intelligent “Similar Posts” using cosine similarity and embeddings. A static-friendly, semantic approach to content discovery without a server.