Skip to content

Essays

Writing

Laravel and WordPress in production, LLM work that had to pay for itself, and what broke on the way.
RSS

Topics

1 of 43 essays

All Laravel 20 PHP 17 AI / LLMs 15 Performance 15 Architecture 12 WordPress 11 Anthropic 8 DevOps 7 RAG 7 pgvector 6 Career 5 PostgreSQL 4 TypeScript 4 Deployment 3 MySQL 3 Open Source 3 Security 3 React 2 Testing 2 WooCommerce 2 Caddy 1 Cloudflare 1 Docker 1 Dokan 1 Gutenberg 1 Pest 1 Redis 1 SQLite 1 Tailwind CSS 1 Vite 1

2026

Apr 25
· 9 min read

RAG on SQLite: Pure-PHP Cosine Similarity Without pgvector

How I built RAG retrieval against a SQLite database using pure-PHP cosine similarity — when it scales, when it doesn't, and the migration path to pgvector.

Laravel AI / LLMs RAG Performance

About SQLite

Everything Al Amin Ahamed has written about SQLite — written after shipping rather than before, so what is in here is what the constraint turned out to be and what I got wrong first.