How to bridge the app/db gap, simple, learn about your enemy & make her your friend.
Cooperate, Communicate, Collaborate Sometimes it works ;-) -- noonie On 18 September 2016 at 14:28, Greg Keogh <gfke...@gmail.com> wrote: > GL > > If your table design matches your object design, at least one of them is a >> poor design (again I'm talking about serious apps). >> > > Then there's no hope. Game over man! It was easier for Jeff Goldblum to > plug his laptop into an alien mothership that it is for coders and DBAs > to exchange data effectively. Perhaps the relational database is a niche > evolutionary branch that just gained too much popularity in the last 30 > years and is now overused or incorrectly used and we all take if for > granted. Robust RDBs come in all sizes and prices, many free, so they're > just everywhere and you use them without thinking. Codd might regret his > legacy! > > You must have experienced many situations where some business data doesn't > feel right in an RDB and you finish up with self-joins and tricks to mimic > hierarchies, inheritance or represent temporal data. If other people have > stumbled into this situation and have opted for an effective non-RDB > solution then I'm keen to hear what happened. > > In light of this whole discussion though, in future I'm going to be more > careful about bridging the code-to-DB gap. Rather than just lazily spiting > out wads of ORM generated code and throwing it at the DB, I'm going to > consider how to use views and procs more effectively to do what they do > best. > > *GK* >