SQL Antipatterns, Volume 1 (Pragmatic Bookshelf)
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
Publisher:
Pragmatic Bookshelf
Latest in SQL Antipatterns, Volume 1
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!
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.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
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!"