|
nielsm posted:One book I have gotten a lot of use out of is SQL Antipatterns, which is unfortunately out of print and was never updated to reflect newer DBMS functionality either. But I really like its approach of showing common problems, describing bad solutions, and then going into better solutions and why they are better. Appears to be available as an ebook at https://pragprog.com/titles/bksap1/sql-antipatterns-volume-1/. Not sure if it's been updated or if it's the same text.
|
# ¿ Mar 3, 2024 23:00 |
|
|
# ¿ May 6, 2024 00:36 |
|
RandomBlue posted:I loving hate working with dates and times because there's always some new way poo poo gets hosed up. There are a shitload of formats even if timezones aren't an issues but they always are. Storing it in UTC is the easiest part. I don't care if the old system was happy with it, "17:04 AM" is not a valid time!
|
# ¿ Mar 12, 2024 00:12 |