Using Obsidian

Hosting Obsidian Vault

Obsidian Sync

Alternatives to Obsidian Sync:

  • use of Git on mobile via Termux
    • installed on Pixel 7
    • may require root for accessing file system (outside com.termux app data directory)
    • see Termux Wiki Getting Started
  • P2P sync agents like Syncthing
    • security?

Databases in Obsidian

Aim: Replicate Notion databases inc. speed and UI quality.

Dynamic views (Create dynamic tables using data stored in note properties) is on the Obsidian Roadmap (link) in the section Planned

Obsidian Forum posts:

TLDR: Nothing is as good as of December 2024. See Has anyone found a good way to replicate Notion’s databases in Obsidian, or offline databases with direct file storage like Obsidian?

Obsidian Database Plugin - Łukasz Tomaszkiewicz

Project: https://github.com/tomaszkiewicz/obsidian-database-plugin

Not (obviously) visible as community plugin. Have to install manually 👉 Obsidian - Installing Plugins Manually

  • Try this plugin

Very slow e.g. for displaying a database of papers with author and publication date lag is noticeable.

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.

General Format of a DQL Query

Every query follows the same structure and consists of

  • exactly one Query Type with zero, one or many fields, depending on query type
  • zero or one FROM data commands with one to many sources
  • zero to many other data commands with one to many expressions and/or other infos depending on the data command

Source: https://blacksmithgu.github.io/obsidian-dataview/queries/structure/

Query Types

The Query Type determines how the output of your dataview query looks like. It is the first and only mandatory specification you give to a dataview query. There are four available: LISTTABLETASK and CALENDAR.

Source: https://blacksmithgu.github.io/obsidian-dataview/queries/query-types/