@mustaccio what can I do to improve this? My question is more of a "does that make sense" kind of question. I have experimented a bit and I am currently filling a database with a lot of data to test performance. I will add my approach later.
I try to create a system to auto approve proposed posts by popular vote. I am currently evaluating what portions of this I can do within the DBMS and if it is sensible. I use PostgreSQL and I can go up to the newest version if that helps me.
My database structure would look somwhat like this:
C...
I have asked a question a few days ago and didn't get any answers and now I wonder if it was out of scope or if it fits somewhere else (stackoverflow maybe?)