Database design

The database design is so simple, you can’t really call it a design. It’s got two fields: filename and tag. That’s it! One line per tag per file, so one file having 10 tags is stored as 10 lines. Another option would be to store the tags as delimited text in the second column, so there would always be only one line per file. But my gut tells me that this would complicate querying and modifying too much. These two options also affect the performance quite strongly. For now I don’t care about that!