I don’t think I can do manyToOne for tags, because a tag can have many articles and an article can have many tags. I’m trying to avoid a Many-to-Many if I can help it for things like tags and other metadata. It just seems like it’s frowned upon for performance and organizational reasons.
I guess I am struggling a bit with database design for analytics and statistical information (trying to capture and report things like most active user, most used tags, etc).
Is there a way to get more info on the benefits the new database system will bring? I’d hate to put in a bunch of workarounds if new options are on the horizon.