This is thanks to sqlite-vec, a new vector search extension for SQLite written entirely in C and with no dependencies.

How To Master Advanced JSON Querying in SQLite: An Expert’s Guide 

Learning the Basics: How To Use JSON in SQLite 

How SQLite helps you do ACID 

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.

Whether you are a developer, data analyst, QA engineer, DevOps person, or product manager - SQLite is a perfect tool for you. Here is why.

Preview: The SQLite Llibrary as a .NET assembly
The latest pre-release of SQLitePCLRaw contains a new bundle package called SQLitePCLRaw.bundle_cil. This package is like SQLitePCLRaw's other "bundle" packages except that it involves no P/Invoke and no platform-specific shared libraries. Instead, bundle_cil provides the SQLite library as a pure .NET assembly which was compiled by Llama. 

SQLite as a document database 

Microsoft.Data.Sqlite 5.0 is available now on NuGet. Update today and let me know if you run into any issues.