MODERN SQLITE: FEATURES YOU DIDN'T KNOW IT HAD

Summary from the TLDR Dev newsletter

Modern SQLite now extends its capabilities beyond basic storage with features like built-in JSON support and the FTS5 extension for full-text search. For advanced analytics, it has SQL features like window functions and common table expressions, while the write-ahead logging (WAL) mode boosts concurrency and performance.