I'm building a web app that requires me to store metadata about files, approximately 15-20 "characteristics" for each file, including some shared ones (i.e. user1 & user2 should have access).
Would you recommend using a relational database for this? or is one of the newer more scalable noSQL databases a better option?
It should be something that scales quickly - and allows us to read and write fast.
Not sure how that would work with a relational DB in terms of performance (say im trying to find all the files that are owned by user1 and shared to user2 that have a certain property - I would essentially have to join 3-4 tables together... which is probably bad for performance?!)
Thanks for your feedback!