Skip to content
Astro Digital Garden

Obsidian Dataview

Dataview is a live index and query engine over your personal knowledge base. You can add metadata to your notes and query them with the Dataview Query Language to list, filter, sort or group your data. Dataview keeps your queries always up to date and makes data aggregation a breeze.

— Obsidian Dataview ↗

Dataview is a plugin for Obsidian ↗. However, we can build our own “Dataview” with BrainDB:

  • Use remark-code-hook ↗ to catch all code blocks with the dataview language
  • Treat the code as SQL and execute wiht BrainDB
  • Translate the result to MDAST (or HTML)

Installation

  1. Install BrainDB

  2. Install dependencies

    Terminal window
    pnpm add @braindb/remark-dataview

  3. Configure Astro. See note about Rehype Plugins for Code.

    astro.config.mjs
    import remarkDataview from "@braindb/remark-dataview";
    import { getBrainDb } from "@braindb/astro";
    

    const bdb = getBrainDb();
    await bdb.ready();
    

    export default defineConfig({
      markdown: {
        remarkPlugins: [[remarkDataview, { bdb }]],
      },
    });

Examples

Alphabetical index

Query:

```dataview list root_class=column-list
SELECT upper(substr(frontmatter ->> '$.title', 1, 1)), dv_link()
FROM documents
WHERE (frontmatter ->> '$.draft' IS NULL OR frontmatter ->> '$.draft' = false)
  AND frontmatter ->> '$.tags' IS NOT NULL
ORDER BY frontmatter ->> '$.title'
LIMIT 4;
```

Output:

A

B

Recently changed

Query:

```dataview list root_class=column-list
SELECT date(updated_at / 1000, 'unixepoch'), dv_link()
FROM documents
WHERE (frontmatter ->> '$.draft' IS NULL OR frontmatter ->> '$.draft' = false)
  AND frontmatter ->> '$.tags' IS NOT NULL
ORDER BY updated_at DESC
LIMIT 3;
```

Output:

2024-12-30

2024-12-29

Task list

Query:

```dataview list
SELECT dv_link(), dv_task()
FROM tasks JOIN documents ON documents.path = tasks.from
WHERE (frontmatter ->> '$.draft' IS NULL OR frontmatter ->> '$.draft' = false)
  AND frontmatter ->> '$.tags' IS NOT NULL
ORDER BY updated_at DESC, path, tasks.start
LIMIT 2;
```

Output:

Link previews

  • Handle non-HTML links (images, PDFs)
  • Handle footnotes

Tags list

Query:

```dataview list root_class=column-list
SELECT '#' || tags.value as tag, dv_link()
FROM documents, json_each(frontmatter, '$.tags') tags
WHERE (frontmatter ->> '$.draft' IS NULL OR frontmatter ->> '$.draft' = false)
  AND frontmatter ->> '$.tags' IS NOT NULL
ORDER BY tag
LIMIT 3;
```

Output:

#code-fences