New view for Dataview: Single Page Database (editable table)

Share & showcase
,
1

Hello, I would like to share with the community a new plugin I wrote, Single Page DB.

This is a custom Dataview script which can be used with dataview dv.view
and which allows you to edit properties stored in the frontmatter of a single markdown file through a convenient table interface.

With plugins such as DB Folder and dataview-inline-db, the content of your database is stored within multiples notes: each item is stored in a different note.

Yet I wanted to have the possibility to gather the whole database in a single note, stored in the frontmatter. Something like that:

---
tasks:
  - taskId: "task-1"
    title: "Complete project documentation"
    status: "In Progress"
    dueDate: "2023-06-30"
  - taskId: "task-2"
    title: "Fix bug in login system"
    status: "Pending"
    dueDate: "2023-06-25"
---

This custom view not only allows to display this data in a Dataview table, but also to easiliy edit it by clicking on a cell : after editing, the frontmatter is automatically updated.

This is just a first version which obviously needs further testing and could be much improved, but I nevertheless wanted to share it with the community since I couldn’t find anything else meeting precisely my needs.

4 Likes
2

Congrats on this plugin, and I wish you the best of luck with further development. I pushed an issue, or rather a feature request, in Consider doing a dedicated code block · Issue #1 · rafjaf/obsidian-dataview-singlepagedb · GitHub.

There I suggest to build your own code block allowing for a better definition of your parameters, and a little simpler overall approach.

3

Thank you for your feedback and suggestion.

I am afraid building my own code block would require to build a genuine plugin instead of just adding an additional view to Dataview plugin. This would IMHO require additional work without clear benefit. However, if you have any concrete suggestion to achieve this goal, do not hesitate to amend the code.

In any case, I uploaded a new version adding filtering and search capabilities.

4

If shouldn’t be that much work, I think. I’m just proposing to utilise the dataview library behind the scenes to make it simpler for the end user to use your work. You could still be using the view approach.

But maybe you would need some more code related to parse the code block, which could require some work.

5

Seems amazing, but I’ve ben trying to get this to work, and I think I just need a much more simple, step-by-step explanation of how to install this. I don’t want to use this for tasks, by the way, and maybe that’s what’s confusing me.

6

Actually you can name the property as you like, this does not have anything to do with tasks specifically. You will find the code to use in the dataviewjs block in the Github repository. Ideally I should create an example vault to illustrate it more clearly