Add "tags" support
SankethBK opened this issue · 3 comments
We need to introduce a new column of type json
into notes table, which will store all the tags for a note.
We should also support filter by tags eventually.
Up to take this one. Assign when available.
-
Will add tags as csv to sqlite db and write a helper to encode and decode.
-
Will add a text field with autocomplete to enter tags in the diary page.
Hey @sameer1612 , can you post the detailed approach. If we store it as csv column, will we able to search it via tags?
We don't need to implement search via tags in this issue, but it should be extendible for future development
Another appraoch would be create a new table with following columns: note_id
and tag_name
. This way we would be able to fetch all the tags which can be used for autocompletion, we can also search via tags this way.
But we need to write encoding and decoding logic while saving and syncing notes, similar to how we are doing for NoteDependencies
table