Learning resources for data modelling and creating schema

[cerulean raft]

After playing with Directus for a while, I’m realising how tricky it can be to create a solid data model for your project.

I think making it so easy to create new collections and fields, increases the risk of having a messy / unclear data model - but I guess that’s what happens when you ‘democratize’ data (which I love as a goal).

Does anyone have any pointers / resources for learning about architecting a data model / schema? Up until now I’ve learned through trial and error, which is fine, but I’d love to learn about potential pitfalls before I make a real project live. Also interested to hear if anyone else has had a similar journey 🙂

[mild rock]

database normalization could be just the thing you are looking for: https://www.youtube.com/watch?v=GFQaEYEc8_8

It gives you a basic intuition for what data belongs where and how you can figure out the right relations between your tables.

[cerulean raft]

Ooh this looks good, thanks @mild rock !

I think this broader learning will put me in a good place to make better Directus apps. And Directus can also be a good tool for learning database stuff at the same time.

One idea - when I get a chance, I might have a better look through the Directus docs, and see if there is a good place to slot in a link to this video, for people who are new to data modelling

[mild rock]

That could make sense when put into the right place! And Directus is also just an UI for easier database management in the end so it makes sense to document on how you should design your directus tables.