4 ms·
> perhaps they are like the relational model in that you need to spend a certain amount of hands-on time with them before their value becomes readily apparent.
by a1369209993 5y ago
> perhaps they are like the relational model in that you need to spend a certain amount of hands-on time with them before their value becomes readily apparent.
... except they cannot possibly be like the relational model in that way, because the relational model isn't like that. The value of relational databases becomes readily apparent when you spend five minutes fiddling with a appropropiate small-but-nontrivial relational database; you do not need to spend a [nontrivial] amount of hands-on time with them before their value becomes readily apparent.
- jackpirate 5y agoAs someone who teaches python+sqlite in an intro to cs course, I can't disagree with this statement more.
- sjg007 5y agoSQL is amazing but the mental model beyond inner joins is not at all obvious. Things like outer joins (and when you need them), aggregation, partitioning etc... I am sure I've missed a few things. But SQL is absolutely amazing. You have to understand the data and the relations, what's not in the data that you'd expect to be etc...