News for hackers. Stuff that matters.

A comment on SQL style guide. Parent comment

Re:SQL style guide by jawns on Sunday October 09, 2016 @01:37PM (#12672255)
I disagree with this style point, and I think the author implicitly acknowledges that `id` should be the standard identifier, because further down he points out that the `_id` suffix should be used for columns that make reference to that identifier.
[ Parent | on HN ]
Re:SQL style guide by jbverschoor on Sunday October 09, 2016 @02:34PM (#12672594)
No he doesn't. In an example he actually uses the following:

ON s2.mentor_id = s1.staff_num

staff_num is the primary key

To me this isan anti pattern because: - a primary should (can) never change; - composite primary keys are only useful (save space) in very large datasets

It also conflicts with his pattern: uniform suffix _id

[ Parent | on HN ]