How to 'design' a database

Hi everyone.
I just got started on ICP/Motoko the recent days, following the bootcamp and currently am at the last graduation stage.
Being a fullstack/c# developer, I got the basics like functions, types, modules etc etc.
Now the question is about, how do you ‘design’ a database (entities, querying, so baiscally stable memory).
Like, can someone give me some directions, roadmap? I’m pretty sure there is but really need some directions?
Would be really time-saving

I’m using DynamoDB before, I think this is a very good approach with Stable Btree.

Now I even using this with my ICP projects. Most of the storage, I defined a access pattern and what kind of data I need to store
Then define key with easy way to construct for faster querying. But remember this approach is not for searching, it will be a nightmare

1 Like