A vast majority of database design questions I see are either
- I'm building a comment database about --------.
- I'm rebuilding Facebook
- I'm building a favorites database about --------.
I more than a little certain from the topics and how the questions are phrased that these are new programmers who are operating on a very small scale with a very limited understanding of programming in general and possibly for a user base of "just him" or "just his group of friends".
I don't want to discourage this activity, it's fine that it's here. But explaining the nuance of b*tree index clustering factor and the impact that can have on optimizer plan creation is a huge waste of time. I wish there was a single Boolean flag for
[x] I need a big-boy enterprise-scale answer.
Sometimes I would use it to filter which questions I answer but mainly I would then know how to tailor the appropriate response.