jarulraj/sqlcheck
View on GitHub ↗ ★ 2,521 C++
Automatically identify anti-patterns in SQL queries
3 mentions on Hacker News by 3 people: 1 story, 2 comments · first 2017-08-15 · latest 2017-08-15
20082026
-
https://github.com/jarulraj/sqlcheck/blob/master/docs/logica... Strongly disagree. Table columns should always be prefixed with table name. So users.user_id is one of the most hated patters for me. user.id looks so much cleaner. No one in…
comment by Achshar · 2017-08-15 · in Show HN: SQLCheck – Automatically identify anti-patterns in SQL queries -
Interesting. Some bones to pick: https://github.com/jarulraj/sqlcheck/blob/master/docs/query/... First, dat implicit, inner join. Second, it could be written more clearly that, in this case, the reason you want to use a join is because you…
comment by snake_plissken · 2017-08-15 · in Show HN: SQLCheck – Automatically identify anti-patterns in SQL queries