An exploration of why SQLite is becoming a production-ready database for modern web apps, discussing its simplicity, concurrency issues, and recent advancements.
Introducing sqlite-vec, a new SQLite extension for vector search written entirely in C. It's a stable release and can be installed in multiple ways. It runs on various platforms, is fast, and supports quantization techniques for efficient storage and search.