[SOLVED] Scalable database design

[green juniper]

ultimately, there are tradeoffs and it's up to you.

you can research database normalization, but in practice, databases aren't always normalized because it depends on the use case

[brave star]

[SOLVED] Scalable database design

[green juniper]

@brave star no need to delete your posts. it can be helpful for others to see

[brave star]

Sry I’ve miss clicked… idk how to undo

[green juniper]

i don't think you can undo a delete. no worries

[glacial elbow]

I'm interested in your final decision

[brave star]

Well I dont have the final decision because I dont have enought experience in dev

But my actual setup is one collection per functionnality

But its so hard to maintain consistency between each document

There is an exemple about my database design but isnt really good

[brave star]

Maybe I can create another table movie_actions which is a collection connected to movie_liked, movie_review, movie_rated, movie_watched, movie_watchlisted, movie_guidelisted. Like this I can only call the movie_actions to get all action from user about a movie