SQLite JSON Superpower: Virtual Columns + Indexing
We absolutely love SQLite here at DB Pro. You'd be hard-pressed to find anyone who actively dislikes it. Sure, it has limitations, and I do mean limi...
Similar Articles (10 found)
🔍 66.0% similar
Python is, in a lot of ways, a very rich language. After years of using it, I still regularly discover new parts of the ecosystem, even in the standar...
🔍 65.2% similar
The State of Vector Search in SQLite
Making vector search fast, memory-efficient, and natural in SQLite.
I usually don’t like to reinvent the wheel, b...
🔍 65.2% similar
9 min read
Feb 02, 2026
Table of contents
01 The “Use the Right Tool” Trap02 Why This Matters Now: The AI Era03 “But Specialized Databases Are Better!...
🔍 62.8% similar
You don't know SQL. Aside from basic CRUD statements, you haven't used any advanced database features. This free ebook will share many recipes to make...
🔍 62.7% similar
I wrote a simple dynamodb style database with a python dictionary and a Google pygtrie ("trie" data structure)
It's still a toy but I kept adding feat...
🔍 62.4% similar
I wish there was some sort of an Access-like form/app builder tool for quickly building GUIs around SQLite databases. That's the one thing I miss. I'd...
🔍 60.4% similar
sqlite-utils 4.0a1 has several (minor) backwards incompatible changes
24th November 2025
I released a new alpha version of sqlite-utils last night—the...
🔍 58.3% similar
Build Your Own Database
A step-by-step guide to building a key-value database from scratch.
If you were to build your own database today, not knowing ...
🔍 57.1% similar
Category: All posts
"Your embeddings are out of sync again."
It's a message that haunts engineering teams trying to build AI applications. What starts...
🔍 56.5% similar
TL;DR:
· If you’re an engineer building realtime analytics or AI-powered features, you need the right data infrastructure coupled with the right devel...