search

zadam / trilium

Build your personal knowledge base with Trilium Notes
GNU Affero General Public License v3.0
26.16k stars 1.8k forks source link

Notion like database #822

Open thbkrshw opened 4 years ago

thbkrshw commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

+1

nhaouari commented 4 years ago

+1

chee commented 3 years ago

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