SQL Antipatterns, Volume 1 (Pragmatic Bookshelf)

Latest Threads About This Book Top

blabla_bingo
@billkarwin ON page 213, the generate-update.sql code uses a single SELECT query to generate multiple UPDATE statements, which have to b...
New
blabla_bingo
@billkarwin On page 186,both the rand-limit-offset.py and rand-row-number.py code uses round function, which will possibly get the total...
New
blabla_bingo
@billkarwin On page 176 , the derived-table-no-duplicates.sql code would not get the correct result if multiple product_id with the same...
New
New
doblebis
Found in first printing (P 1.0). The text reads “certain verions” instead of “certain versions”.
New
New
New
crash
REPLACE INTO PasswordResetRequest (account_id, token, account_id, expiration) VALUES (123, @token, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
New
crash
@billkarwin You say that the DB is in the 5th normal form if it does not have compound PK. But in the solution tables you still have co...
New
crash
@billkarwin You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).
New
billkarwin
PlanetScale Vitess 14 is a great technology to supporting sharded architecture with MySQL, but it has does not support stored procedures ...
New
Ted
Hi Bill. I’m glad to see you cover a lot of important topics about dealing with passwords in Chapter 20, “Readable Passwords”. However,...
New
Ted
I’m enjoying the book and I’m happy to see that the discussion of GROUP BY in chapter 15 also includes a callout box titled “GROUP BY and...
New
PragmaticBookshelf
SQL Antipatterns is a short-cut to wisdom, showing you how to avoid "easy" solutions that don't work, and be a better database developer ...
New

Most Active This Week Top

Most Active This Month Top

Most Active This Year Top

New

Most Active Last Three Years Top

PragmaticBookshelf
SQL Antipatterns is a short-cut to wisdom, showing you how to avoid "easy" solutions that don't work, and be a better database developer ...
New
Ted
I’m enjoying the book and I’m happy to see that the discussion of GROUP BY in chapter 15 also includes a callout box titled “GROUP BY and...
New
crash
@billkarwin You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).
New
Ted
Hi Bill. I’m glad to see you cover a lot of important topics about dealing with passwords in Chapter 20, “Readable Passwords”. However,...
New
billkarwin
PlanetScale Vitess 14 is a great technology to supporting sharded architecture with MySQL, but it has does not support stored procedures ...
New
crash
REPLACE INTO PasswordResetRequest (account_id, token, account_id, expiration) VALUES (123, @token, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
New
New
New
doblebis
Found in first printing (P 1.0). The text reads “certain verions” instead of “certain versions”.
New
crash
@billkarwin You say that the DB is in the 5th normal form if it does not have compound PK. But in the solution tables you still have co...
New
blabla_bingo
@billkarwin ON page 213, the generate-update.sql code uses a single SELECT query to generate multiple UPDATE statements, which have to b...
New
blabla_bingo
@billkarwin On page 176 , the derived-table-no-duplicates.sql code would not get the correct result if multiple product_id with the same...
New
blabla_bingo
@billkarwin On page 186,both the rand-limit-offset.py and rand-row-number.py code uses round function, which will possibly get the total...
New

Most Active Over Three Years Top

Get money off!

The Pragmatic Bookshelf

35% off any eBook

Use the coupon code "devtalk.com" to get 35% off any eBook published by PragProg!

Related Portals

    None added yet