Threads for Treffynnon

  1. 3


    This is not what I want.

    Most of what it says I’d boil down to.


    Have some.

    Mostly be consistent.

    Instead, I strongly recommend SQL and Relational Theory, 2nd Edition How to Write Accurate SQL Code By C.J. Date

    If you want a bullet point style guide, see Date’s “Summary of Recommendations” appendix.

    Date’s views are solidly and soundly based in the mathematical underpinnings of logic. ie. You can ignore Date, but while logic is still working (last I checked, it was) violations will be punished, in the corner cases, by illogical results.

    If I were to add one thing to Date, it would be create a simple data dictionary.

    For every project create a very simple table (column name, column type, description).

    Every single time you add a column to any table, see if anything in your dictionary fits (exactly) the type / description, if so use the same name.

    Else add your new column name as another row to your dictionary.

    Do this religiously, and follow Date’s recommendations, then your SQL statements will simplify by a factor of 10.

    1. 2

      Thank you for the book reference - I was previously unaware of Date’s work. For others there is a third edition too:

      1. 2

        I read the 2nd edition, so I missed this gem from the 3rd edition appendix on “NoSQL and Relational Theory”.

        So what is it that unites these (NoSQL) systems?—what is it that they have in common, to justify referring to them all by the same blanket label? Mostly, it seems they’re united in what they’re not. To be specific, they’re obviously not conventional SQL systems, as that term is generally understood. Unfortunately, however, I would have to say they’re also united in the extensive and demonstrable lack of understanding of the relational model displayed by their promoters.

        I haven’t had time to read the full appendix, but my initial impression is it’s going to be a keeper to refer people who over-hype NoSQL and under-understand Relational.