oniony / TMSU

TMSU lets you tags your files and then access them through a nifty virtual filesystem from any other application.
Other
2.01k stars 115 forks source link

another app using the database? #278

Open hydrargyrum opened 4 months ago

hydrargyrum commented 4 months ago

I develop sit-tagger, an image file browser with its own file tagging database. I'm considering changing the database schema (which has been designed years ago) to be more like TMSU's one because it's better designed. A further option would be to even fully support TMSU databases. However, I need some features that are not present in TMSU database, so I have a few questions:

0ion9 commented 4 months ago

On question 2: I have been using additional tables (and triggers on file_tag) in my schema for years now and TMSU continues to work fine. This is on a moderately large database (31k tagged files)

My alterations were also mainly done using Python. TMSU does not to my knowledge do anything particularly exotic with SQLite, so there are probably other people who have successfully done this kind of thing with different languages.