βββ β ββ β¦ ββ β βββ
Warning
All tables on this page are generated by the Obsidian plugin
Dataview Serializer
which has to be run manually and is not part of the automatic GitHub Actions workflow.
As a result this note reflects the blogβs state at the last time when the plugin was run β take note when this page has been updated (see above).
Folder structure
All pages (besides those tagged with meta) are sorted in the following folder structure:
- Braindump: Unstructured, mostly short ideas
- Life: Cooking, beer brewing, personal stuff
- Notes: Short pages, collections of web resources
- Projects: Complete write-ups of projects, overview notes (entry points to topics spanning multiple pages)
- Writing: Longer guides & tutorials
Published pages
Tags by frequency
[Click me] Dataview query
TABLE WITHOUT ID
count, "#" + join((rows.tags), ", #") as Tags
FROM "public/Braindump"
OR "public/Life"
OR "public/Notes"
OR "public/Projects"
OR "public/Writing"
WHERE tags
AND draft = false
FLATTEN tags
GROUP BY tags
GROUP BY length(rows.rows) as count
SORT count DESC
count | Tags |
---|---|
31 | unfinished |
13 | quartz |
11 | german |
9 | docker |
8 | markdown |
7 | obsidian |
6 | recipe |
5 | barebone, media, selfhosted |
4 | books, bread, git, github, homelab, reading |
3 | guide, kitchen_log, resources |
2 | backup, beer, bookmarks, brewing, homebrewing, internal, proxmox, syncthing, synology, untested, windows |
1 | cheatsheet, k3s, latex, linux, overleaf, plants, powershell, python, truenas, videogames, vm, vpn, vscode, wg |
Pages by last updated
[Click me] Dataview query
TABLE WITHOUT ID
link(file.name, title) AS "Title", regexreplace(file.folder, ".*\/([^\/]+)$", "$1") AS "Folder", dateformat(updated, "yyyy-MM-dd") AS "Updated"
FROM "public/Braindump"
OR "public/Life"
OR "public/Notes"
OR "public/Projects"
OR "public/Writing"
SORT updated DESC
WHERE draft = false
AND file.folder != "public/zzz_static_files/my quartz config files"
Unpublished pages
Tags by frequency
[Click me] default
TABLE WITHOUT ID
count, "#" + join((rows.tags), ", #") as Tags
FROM "public/Braindump"
OR "public/Life"
OR "public/Notes"
OR "public/Projects"
OR "public/Writing"
WHERE tags
AND draft = true
FLATTEN tags
GROUP BY tags
GROUP BY length(rows.rows) as count
SORT count DESC
count | Tags |
---|---|
38 | unfinished |
11 | docker |
6 | python |
5 | german |
4 | coding, github, media |
3 | barebone, books, homelab, internal, reading, untested, videogames |
2 | arduino, electronics, homeassistant, recipe, vscode |
1 | backlinks-exclude, blog, bread, explorer-exclude, graph-exclude, homebrewing, kitchen_log, linux, machine_learning, mead, nsfw, quartz, raspi, recents-exclude, review, selfhosted, sqlite, synology, unraid, wg |
Pages by last updated
[Click me] Dataview query
TABLE WITHOUT ID
link(file.name, title) AS "Title", regexreplace(file.folder, ".*\/([^\/]+)$", "$1") AS "Folder", dateformat(updated, "yyyy-MM-dd") AS "Updated"
FROM "public/Braindump"
OR "public/Life"
OR "public/Notes"
OR "public/Projects"
OR "public/Writing"
SORT updated DESC
WHERE draft = true
AND file.folder != "public/zzz_static_files/my quartz config files"
Planned Dataview tables
- all Tags, sorted by frequency
- all published & unpublished pages
- list of pages without backlinks
- list of all pages with perma links
βββ β ββ β¦ ββ β βββ