SQL Antipatterns, Volume 1 (Pragmatic Bookshelf)
Hot This:
Most Active This Week
Most Active This Month
Most Active This Year
Most Active Last Three Years
@billkarwin
You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).
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
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
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!"