Ask HN: Many-to-Many relation by default, is that a good strategy?

https://www.guru99.com/database-normalization.html

You usually can get by with 4th normal form but go wild, take it to 11 and it's all you should ever need.

You could use blob storage until you know the relationships.

You lose a lot of the value of relationships in a schema if you don’t know what they are

That means adding a lot more tables doesn't it?

Yes, it will add more tables. But as the project progresses, this will be reduced once the relationship between the entities are clear. What I am worried about though is the performance.