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.
Follow
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.
@Rocket I'm sticking to MySQL for this project. I got the tagging thing down. Though, I'd probably go with Apache's CouchDB if I do anything else that requires a NoSQL database.
Ferretdb is built on top of postgres.