JSON to SQLite With sqlite-utils
How to get JSON into a local SQLite database fast.
sqlite
3 posts
Constructing SQLite Tables for Notebooks and Search
SQLite full text search setup via APSW for all the notebooks on this website, inspired by the APSW FTS5 Tour).
SQLite FTS5 Tokenizers: `unicode61` and `ascii`
The SQLite FTS5 (full-text search) extension includes the built-in tokenizers unicode61, ascii, porter, and trigram, implemented in fts5_tokenize.c. APSW provides a Python API to use those.