Notion like database

[thbkrshw]

I've nearly anything I need in Trilium, but I'd like to know if it's possible to implement notion like database?

It's based on a simple table, but with lots of functionality behind the scene: https://www.notion.so/Intro-to-databases-fd8cd2d212f74c50954c11086d85997e

Every row is a block (as everything is a block in notion), that can have many attributes, and could queried like a DB, with different way of visualizing it.

How to you think it's implementable? With a note for every row?

[zadam]

That functionality looks pretty cool, but I don't see it realistic to implement all that in Trilium anytime soon.

But there are bits which are quite low-hanging fruit and could be relatively easy - e.g. having "smart" table (widget) which would be backed by a user-definable SQL query - each row can be a note but also whatever else you choose. However this would be a read only view and you would have to click through (open in tab) to the actual note to be able to edit the content.

Similarly I have a plan to introduce a chart widget which would be backed by a SQL query (or script).

[thbkrshw]

Thank you for your quick response :)

A view based on a SQL query seems to be a good way to begin this, especially with how many attributes every note had. Will try to look into something.

[leoossa]

+1

[nhaouari]

+1

[chee]

https://github.com/mabeyj/trilium-collection-views