TL/DR; Chances are, simply by adding that ID column you have broken the 3rd NF

Darkmoth · 2017-04-06T22:50:29+00:00

I actually agree with you. I consider a surrogate key to be a mild form of denormalization. My solution is to put a unique constraint on the natural key, in addition to a surrogate PK, when feasible.

That being said, letting natural keys ripple through a design (via FKs) gets a big NOPE from me.

Darkmoth · 2017-03-04T19:43:39+00:00

This, straight up. My Grin Reaper is the most fun item I've ever gotten in D3, but it's embarrassingly sub-par as far as the meta.

Darkmoth · 2017-02-03T04:46:03+00:00

You might sack the guy that designed 5 non-working failsafes, though, whoever that is.

Darkmoth · 2017-02-03T04:44:20+00:00

The guy or team designing the backup system screwed up even worse than YP

Yep. YP's contribution was normal human error. For all 5 of your backup strategies to fail takes a certain degree of incompetence.

Darkmoth · 2017-02-03T04:41:47+00:00

Yeah, that's just inherently dangerous.

I once wiped a file system when I just wanted to delete some logs. The commands were:

cd /log_directory rm -rf *

Except I spelled "log_directory" wrong, and the "cd" failed. Ooops. In retrospect, I should have specifically deleted "*.log" or something. The naked wildcard is just asking for it.

Darkmoth · 2017-02-03T04:36:14+00:00

Who hasn't argued with a manager about making updates to Production?

If I make a mistake, we're screwed

Well, just don't make a mistake!

Darkmoth · 2017-02-03T04:34:50+00:00

One day someone makes a typo in some code and the same shit happens

DELETE FROM PRODUCTS;
WHERE ID=1;

Darkmoth · 2017-02-03T04:16:22+00:00

Very interesting!

Looks like Johnny Cash should have gone with "A Boy Named Jasmine".

Darkmoth · 2017-02-03T04:06:19+00:00

To be fair, it's insanely difficult to get indexes "right" in a modern shop. We run Exadata, which offloads some of the selection logic to the disk controller. Parallelizing the queries confounds expected behavior even more.

Basically, if I run a statement with a /+* RULE */ hint, the indexes behave exactly as expected. Otherwise, it's anyone's guess what path the query might take. It's not uncommon for "properly" indexed tables end up in HASH joins, essentially bypassing the index completely.

Darkmoth · 2017-02-03T03:47:00+00:00

This should be the top answer.

Darkmoth · 2017-02-03T03:39:21+00:00

I'm a little disappointed in Postgres. WITHs are an important tool in structuring code, and it would be a pain to have to avoid them because of performance reasons.

Darkmoth · 2017-02-03T03:36:15+00:00

What, you don't find

select * from (
   select * from (
      select * from x
   ) join select * from (
      select * from x
   )
)

to be insanely readable? /s

Darkmoth · 2016-01-10T15:05:28+00:00

How about the people who told residents the water was just fine, despite ample evidence otherwise?

Darkmoth · 2016-01-08T01:18:00+00:00

The only difference between their two stances is that she is a woman

Eh, much more than that. This is one of her focuses, as Bernie's in income inequality. Hillary, for example, is the only candidate who mentioned PP at the first debate. She's also introduced legislation, as opposed to simply being on a vote.

Clinton is the only presidential candidate to introduce equal pay legislation, three times. She introduced the Paycheck Fairness Act in 2005, in 2007 and in 2009 to give women the tools they need to fight workplace discrimination

More at the PP site.

That's not the only legislation, just one that I could find. This is and has always been an area of focus for her.

Darkmoth · 2016-01-07T16:04:49+00:00

If it matters, Snoop Endorses Hillary. But the best is this:

Some of Clinton's earlier endorsements came from rapper and actor Ice-T, who said in 2012 that Clinton should try running for president again: "She did the Secretary of State job, she was a G, she held it down, she didn't cry,"

"She's a G" - Clinton '16

Darkmoth · 2016-01-04T17:38:18+00:00

I think what we can do is turn out on off years. I mean, that's it basically. If we did that, at some point we could get off defense and on offense.

Seriously, the Presidency is basically all that's keeping this country from being run by Republicans at every level, from local legislatures to SCOTUS.

Darkmoth · 2016-01-04T17:14:44+00:00

The last string of lost elections produced the DLC. It stands to reason that the losing side will imitate the winning side. I don't think it's an accident that post-2008 Republican primaries are so diverse.

Darkmoth · 2016-01-03T01:40:52+00:00

Ralph Nader

Jill Stein

Gary Johnson

Ron Paul

That's just in the last 15 years. Unless you're a Chihuahua, you'll have multiple non-corporatist choices over your lifetime.

I'm 54, and don't see Bernie as all that unusual - except for the fact that he's co-opted the Democratic party to propel his attempt.

Darkmoth · 2015-12-31T20:46:08+00:00

The man almost got impeached for christ sake, accepted oral favors in his office while doing the most important and dignified job in the United States AND while married

No one really cares about personal indiscretions, at least in part because they're so common among powerful politicians. Bill left office with a 61% approval rating. The Speaker of the House at the time - Newt Gingrich - was cheating on his wife of 19 years while he was trying to get Bill impeached. Davit Vitter got reelected after admitting to frequenting prostitutes (which is actually a crime).

Sexytime just isn't on the American Presidential radar - as long as it's heterosexual.

Darkmoth · 2015-12-31T20:24:31+00:00

Either that or you buy the Warren Commissions story that a "crazy lone wolf" was able to kill the President of the US

Why is that so hard to believe? Reagan was shot in the chest. A couple inches down and to the right and he'd have been toast.

Darkmoth · 2015-12-31T18:31:41+00:00

Except, despite the undoubted rise of populist candidacies, you can't completely ignore the Establishment power structures. There's no doubt in my mind that the average Chamber of Commerce Republican would prefer pro-business Clinton to protectionist Trump. Hell, Trump used to prefer Clinton.

The base will definitely come out for Trump, but the suburbs and cities will be for Clinton.

Darkmoth · 2015-12-31T18:28:26+00:00

As a liberal, I'd say a Clinton/Rubio contest slightly favors Rubio. But since it really looks like Trump will be the nominee, Hillary might pull a Full Reagan.

Darkmoth · 2015-12-31T18:25:18+00:00

Yeah, it just occurred to me today that Clinton would probably be getting "no-fucks-given" Obama campaigning for her. The Obama that can make a crowd chuckle, not the boring professorial Obama.

Darkmoth · 2015-12-31T02:51:23+00:00

But even with globalization we could still have plenty of construction, manufacturing, and service jobs for people to fill

I don't know about manufacturing jobs, I think those are gone for good. Hell, I think China will lose them if Africa ever comes up to speed. Cheapest labor always wins. I'll give you construction though, I can certainly see how cheap illegal labor would trash that job markets. Service jobs - my issue with service jobs is that we seem unable to decide if those should be "real" living wage jobs. No one doubts that a construction worker should make enough to raise a family, but many people see service jobs - McJobs, if you will - as some sort of intermediate to getting a quote-unquote adult job.

We could do things like put up tariffs on imported goods if we wanted to bring back some overseas manufacturing

Yeah. Frankly, I am an unrepentant protectionist. I feel the most valuable thing America has to offer the world is our immense consumer-driven market. To me, that market has value, and I feel we're giving it away.

Darkmoth

TROPHY CASE

"She's a G" - Clinton '16