Private Semantic Search: Building an Offline Vector Search Engine with SQLite and Ollama
Learn how to build a 100% offline, privacy-first semantic search engine for your markdown notes using Ollama embeddings and SQLite's vector extensions.
Next Harizon
Thoughts, experiments, and field guides on local AI, minimalist web development, and database-free architecture.
Featured Article
Articles Grid
Running Local LLMs on Old Hardware: A 2026 Practical Guide
Your 2019 ThinkPad with 8GB of RAM can run real AI models. Here is the exact setup, model picks, and performance numbers.
Offline AI for Sensitive Documents: The Complete Setup Guide
Stop uploading contracts, medical records, and legal docs to ChatGPT. Build a fully offline document analysis system in 30 minutes.
Static Site Search in 2026: The Complete Guide (No Database Required)
Search on a static site sounds impossible. It is not. Here are three approaches that work, from simple JSON to WASM-powered full-text search.
Vanilla JavaScript vs React for Small Projects: The Honest 2026 Comparison
React is 42KB before you write a line of business logic. Vanilla JS is 2KB. For small projects, the math is simpler than you think.
Ollama vs LM Studio in 2026: What Actually Changed
Both tools got major upgrades this year. Ollama raised $88M and added cloud tiers. LM Studio launched a headless server. Here is what matters.
The $0/Month Hosting Stack Every Solo Developer Should Know in 2026
Free tiers got generous. Here is a complete production stack for literally zero dollars.
Building AI Agents Without LangChain: The 2026 Guide
LangChain has 1,800+ GitHub issues and your agent has 3 tools. You do not need a framework — you need 150 lines of Python.
Side Project Validation for Developers: The Weekend Sprint
The developer graveyard is full of beautiful apps nobody asked for. Here is how to validate your idea in 48 hours.
SQLite FTS5 for Static Site Search Engines
Why use heavy databases? Learn how to generate static SQLite databases with FTS5 virtual tables to query index text instantly with SQL in client browser.
Vanilla CSS Grid Layouts for Blog Archives
Ditch CSS framework bloat. Learn how to write a highly responsive, modern, auto-fitting blog card layout using pure native CSS grid and clamp values.
Zero-Dependency Local AI Agents: Skip LangChain
Why you don't need heavy frameworks like LangChain to build functional local AI agents. How to use vanilla Python or JS with Ollama's direct API.
Build an Ollama Client That Runs on 0.5MB RAM
Framework fatigue is real. Build a fully featured, beautiful chat interface for Ollama using only plain HTML, CSS, and Vanilla JavaScript.
Static Site Search Engine Without a Database
A database is overkill for search on a static blog. Learn how to pre-build a lightweight JSON index and query it in the browser with simple JS.
Deploying Private SQLite Databases for Free
Want to host dynamic side projects for free? Here is how to deploy SQLite on free tiers with automated Litestream streaming backups.
Six Months of Agentic Coding — What I Learned
I spent six months using AI coding agents daily. Here's what surprised me, what frustrated me, and what I'd tell someone starting today.
How I Structure AI Prompts for Code Generation That Actually Works
The difference between AI-generated spaghetti and production-ready code is the prompt. Here's the framework I use every day.
Boring SaaS Ideas That Actually Make Money in 2026
The sexiest startup ideas get the most attention and the least revenue. Here's why boring software makes millionaires.
Build a Contact Form Without a Backend
Static sites are great until someone says "can you add a contact form?" Here's how to handle it without spinning up a server.
Core Web Vitals Explained for Developers Who Don't Care About SEO
Google's performance metrics sound intimidating. They're actually just three simple questions about your site.
Dark Mode with Pure CSS (No JavaScript Required)
Everyone uses JavaScript for dark mode. Here's how to build a multi-theme system with zero JS using CSS radio inputs.
Why I Stopped Using Git Branches for Solo Projects
Controversial opinion: if you're the only developer, feature branches are ceremony without value. Here's what I do instead.
Ollama vs LM Studio: Which Local AI Tool Wins in 2026?
Both tools let you run AI locally. But they take wildly different approaches — and the "best" one depends on what kind of developer you are.
How to Run an LLM on a 4GB RAM Laptop
Think you need a $3,000 GPU to run local AI? Absolutely not. Here's the guerrilla guide to running real LLMs on old hardware.
Self-Hosted AI for Private Document Analysis
Stop uploading sensitive documents to ChatGPT. Build a fully offline document analysis system that never touches the internet.
The Solo Developer Tech Stack That Costs $0/Month
You don't need a budget to ship a real product. Here's a complete production stack built entirely on free tiers.
The Developer's Guide to Writing Technical Blog Posts That Rank
Your brilliant tutorial has 3 views — all from your own browser. Here's how to fix that without becoming an SEO guru.
How to Validate a Side Project Idea in One Weekend
The developer graveyard is full of beautiful apps that no one asked for. Here's how to check if your idea has legs.
Vanilla JavaScript State Management Without a Framework
Redux has 1,800 GitHub issues. Your homemade state manager will have zero. Here's how to manage complex app state in plain JS.
Your Website Loads in 6 Seconds? Here's How to Hit Under 1 Second
Most websites are slow because of easily fixable mistakes. Here's a prioritized checklist that makes the biggest impact.