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.

Getting Started

  1. Make sure you have sqlite available on your local machine.
  2. Add the following setting in dendronrc.yml or dendron.yml.
  metadataStore: sqlite
  1. 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