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 standard library. In particular, there are a few modules ...
Similar Articles (10 found)
🔍 66.0% similar
SQLite JSON Superpower: Virtual Columns + Indexing
We absolutely love SQLite here at DB Pro. You'd be hard-pressed to find anyone who actively dislike...
🔍 64.9% 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.0% 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...
🔍 61.4% similar
There are books & many articles online, like this one arguing for using Postgres for everything. I thought I’d take a look at one use case - using Pos...
🔍 61.1% 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...
🔍 59.0% similar
21 minutes
Introduction to PostgreSQL Indexes
Who’s this for
This text is for developers that have an intuitive knowledge of what database indexes are...
🔍 58.2% similar
There’s a tried-and-true architecture that I’ve seen many times for supporting your web services and applications:
- PostgreSQL for data storage
- Red...
🔍 57.9% 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.6% 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!...
🔍 57.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...