Unused tags stay listed in the sqlite DB

[alondmnt]

Unused tags stay listed in the sqlite DB. Could be that this is intended, and in that case my apologies.

Environment

Joplin version: 2.12.10 Platform: macOS OS specifics: Ventura 13.4.1 (arm64)

Steps to reproduce

1. Turn off note history (just to demonstrate that this is unrelated to history).
2. Add a new tag (used for the first time) to a note.
3. Remove the tag from the note using the tags dialog.
4. Check the tags table in the DB. You may verify that the tag ID is unused, e.g. in the tags_with_note_count view.

Describe what you expected to happen

I expected unused tags not to linger in the DB, as orphan tags can accumulate needlessly. I noticed that they are removed from the tags table when running the command "remove" from the tags context menu.

[CptMeetKat]

I'm happy to take this one on as my first issue

[github-actions[bot]]

Hey there, it looks like there has been no activity on this issue recently. Has the issue been fixed, or does it still require the community's attention? If you require support or are requesting an enhancement or feature then please create a topic on the Joplin forum. This issue may be closed if no further activity occurs. You may comment on the issue and I will leave it open. Thank you for your contributions.

[github-actions[bot]]

Closing this issue after a prolonged period of inactivity. If this issue is still present in the latest release, feel free to create a new issue with up-to-date information.

[personalizedrefrigerator]

For reference,

• this is how orphaned resources are currently handled
• an issue was raised here that should be considered while implementing a solution