Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
TasogareNoKagi
Jul 11, 2013

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.

Adbot
ADBOT LOVES YOU

TasogareNoKagi
Jul 11, 2013

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.

If you control the input and can limit things there it's not so bad but I work on a product that works with user provided CSVs, spreadsheets, DB sources, CRMs, etc.. and of course we work with international customers so all that poo poo has to work together seamlessly.

I don't care if the old system was happy with it, "17:04 AM" is not a valid time!

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply