2 ms·
You had views dependent on views? Object oriented database schemes sound problematic.
by gigatexal 8y ago
You had views dependent on views? Object oriented database schemes sound problematic.
- radiowave 8y agoNothing to do with object orientation. We just use a lot of views, both to abstract away common complex queries, and to allow external systems to interact with the data in a controlled way.
- gigatexal 8y agoThat makes sense actually. But stored procedures could do that too?
- radiowave 8y agoYes. I tend to treat procedural code as a last resort, because pure declarative SQL is so much easier to troubleshoot.
- gigatexal 8y agoI guess I use stored procedures differently. I rely on SQL queries not for loops if I can help it. Sometimes it can’t be avoided if you’re doing updates in chunks for example.