HN
Modern SQLite: Features You Didn't Know It Had
SQLite ships with a JSON extension that lets you store and query JSON documents directly in tables. You can keep your schema flexible while still using SQL to slice and dice structured data.
Example: extracting fields from a JSON column:
You can also create indexes on JSON expressions, making queries over semi-structured data surprisingly fast.
SQLite’s FTS5 extension turns it into a capable full-text search engine. Instead of bolting on an external search service, you can keep everything in a single database file.
Example: building a simple search index:
You get ranking, phrase queries, prefix searches, and more—without leaving SQLite or managing a separate service.