This is documentation for running Dendron using sqlite as the metadata backend. It is currently a #stage.germ feature
WARNING: we currently do not support windows for the SQLite metadata backend
Switching to using sqlite as the metadatacan result in 30x speed up on lookup queries (50k notes, queries complete in ~5ms vs +150ms). The search is based off the SQLite's built-in FTS5 extension.
- Make sure you have
sqliteavailable on your local machine.
- Add the following setting in dendronrc.yml or dendron.yml.
workspace: metadataStore: sqlite
- Reload your workspace
You should notice a
metadata.db file in the same directory as your
dendron.yml. This file contains all the metadata for your workspace and will be used for lookup queries during runtime