SQL Antipatterns, Volume 1 (Pragmatic Bookshelf)
Active Threads This:
Latest Threads About This Book
@billkarwin
ON page 213, the generate-update.sql code uses a single SELECT query to generate multiple UPDATE statements, which have to b...
New
@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
@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
Is there any plan for volume 2? :slight_smile:
New
Found in first printing (P 1.0). The text reads “certain verions” instead of “certain versions”.
New
“feature in in version 8.0”
New
“illustation” should be “illustration”
New
REPLACE INTO PasswordResetRequest (account_id, token, account_id, expiration)
VALUES (123, @token, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
New
@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
@billkarwin
You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).
New
Most Active This Week
Most Active This Month
Is there any plan for volume 2? :slight_smile:
New
Most Active This Year
Most Active Last Three Years
SQL Antipatterns is a short-cut to wisdom, showing you how to avoid "easy" solutions that don't work, and be a better datab...
New
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
@billkarwin
You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).
New
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
PlanetScale Vitess 14 is a great technology to supporting sharded architecture with MySQL, but it has does not support stored procedures ...
New
REPLACE INTO PasswordResetRequest (account_id, token, account_id, expiration)
VALUES (123, @token, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
New
“illustation” should be “illustration”
New
“feature in in version 8.0”
New
Found in first printing (P 1.0). The text reads “certain verions” instead of “certain versions”.
New
@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
@billkarwin
ON page 213, the generate-update.sql code uses a single SELECT query to generate multiple UPDATE statements, which have to b...
New
@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
@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
Book Info
Publisher:
Pragmatic Bookshelf
Are you this book's author? To be notified of all posts made about it, sign up an account then click here, then select 'watching' from the bell icon in the top right corner.
Get money off!
The Pragmatic Bookshelf
35% off any eBook
Simply use coupon code "devtalk.com" at checkout. See full details here.
Latest
Filter by Type:
Related Portals
-
None added yet
Devtalk Sponsors
Practical resources that improve the lives of professional developers.
We build trusted fault-tolerant systems that scale to billions of users.
Catch errors, track performance, monitor hosts and more.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"