This is why a fucking hate SQL so much. I need to create THREE TABLES just to implement tagging. At least, that's the "proper way". Not to mention all the JOINS and nested queries I have to do.

I should've used MongoDB for this project, but I feel like it's too late to turn things around.

Well, it turns out that the vast majority of NoSQL databases are source-available proprietary, and the few FOSS ones are a bit too confusing.