3 ms·
Becuase of lack of tooling there is tons of duplicate logic in SQL based systems, I see the same logic repeated across queries which already exists in some view
by aszen 6y ago
Becuase of lack of tooling there is tons of duplicate logic in SQL based systems, I see the same logic repeated across queries which already exists in some view but no knows about it so it ends up being repeated.
Lack of abstractions like modules and namespaces for logically grouping stored procedures makes it hard to understand where is what
- fiddlerwoaroof 6y agoEvery database I’ve used has namespaces: most application code ignores SQL schemas, but that’s what they’re for.
- aszen 6y agoThanks that is very interesting, I would imagine having all the data in one schema, and then few other schemas containing views and functions grouped together logically.
- cerved 6y agobut they're just one level, no?
- fiddlerwoaroof 6y agoYeah, but conventional naming is almost as good: foo_bar_baz.users and foo_bar_other.users
- deleted 6y ago[deleted]