Catch up on stories from the past week (and beyond) at the Slashdot story archive

 



Forgot your password?
typodupeerror
Get HideMyAss! VPN, PC Mag's Top 10 VPNs of 2016 for 55% off for a Limited Time ×

Comment Re:They should fix their user schema first (Score 1) 53

You're adding a useless column that has no actual meaning.

It's simpler to use the actual user name and make it unique. Your PK index then also serves as an index on the user name for sorting/searching purposes against the user name.

The downsides are that the tables referencing the user name have to store the user name (but that's probably capped at 30 characters or so) and that equality comparisons for a string are worse than for an int (but only by a few cycles since you'll return a false 99.999% of the time and do it after a couple of characters).
These would be more than offset by the fact that you can completely avoid a join in many cases since you already have the user name directly in the table you're querying.

As long as you've got a sane length limit, properly set up your relationships, and make sure your collation makes sense (unicode/accents, capitalization), there's no real reason to introduce another column that's simply a proxy for the value you want. Even if you're encrypting the user name it doesn't matter.

Comment Re:They should fix their user schema first (Score 1) 53

Sony used the psn account name as a primary key; it's obviously a major fsck-up. Apparently their retarded developers do not know how to create proper databases, nor can they handle history changes [admitted by their CEO].

If you guarantee it's unique, what's the issue? You can even allow it to be changed. Your relationships will cascade the change to any other table referencing it.

What would you propose?
An unnecessarily long UUID that penalizes performance on every direct lookup, join, or LIKE query?
An integer with the IDENTITY flag set that auto increments and has no actual meaning?

Change tracking / historical retention can be achieved in many ways. Depending on what you want to preserve and how you expect to need to recover it, you can simply backup the transaction logs, regularly backup the database itself, or create a history table for each table you need historical data on and create a trigger that copies affected rows, along with a timestamp column with a default of SYSDATETIME() or similar, on UPDATE or DELETE.

What would you suggest? Polluting the main table with a timestamp / rowversion column and only selecting the latest one OVER (PARTITION BY {your dumbass UUID PK column})? Do you even care about performance or size? Yes, size matters, because we want to be able to keep the whole table, or at least the whole file for the commonly-accessed columns, in memory. (Let me guess - you've got wide tables and you're NOT splitting out the rarely-used columns off in a separate file.)

Comment Re:Got that, Microsoft shills? (Score 1) 144

There are no "low level tools". Nothing within the OS operates at a lower level than the OS. Windows 10 can and will intercept everything and lie about anything.

If you haven't stocked up on tinfoil hats for the past 15 years, you've got your head in the sand and your ass in the air.

Comment Re:So... (Score 1) 96

All you need to do is press the dead finger to the sensor hard, using your own (ungloved) finger. The sensor will activate based on your finger being alive.
Worse case scenario you cut off the pad of their finger and press that (your finger behind it). Or your elbow if you're squeamish. Or just run current through the dead finger if you don't want to defile a corpse.

All of this is assuming the clown used his fingerprint to unlock his phone. Long random password or nothing.

Comment Re:Got that, Microsoft shills? (Score 3, Informative) 144

You don't have to be an expert to know that you can't control Windows from within Windows. We've already seen Windows 10 lie about its behavior.
You need an external device not running Windows to ensure you're not leaking. That means tracking every outbound connection from a Windows 10 host at the switch/router, investigating every IP, and blocking anything affiliated with Windows 10 "telemetry" or "updates". Then you'll need to manually download every actual security update, possibly from another system, and install them individually. Because yes, you still need security updates.

Windows 10 is a shitshow and a complete non-starter for anyone who cares at all about security or privacy.

Comment Monorail (Score -1, Offtopic) 171

You know, a country with money's a little like a mule with a spinning wheel. No one knows how he got it and danged if it knows how to use it.

Heh-heh, mule.

The name's Musk, Elon Musk. And I come before you good people tonight with an idea. Probably the greatest—Aw, it's not for you. It's more of a China idea.

Now, wait just a minute. We're twice as smart as the people of China. Just tell us your idea and we'll give you subsidies for it.

All right. I'll tell you what I'll do. I'll show you my idea. I give you the Tesla Autopilotl!

I've sold autopilots to Plymouth, Oldsmobile, and Studebaker, and by gum, it put them on the map!

Well, sir, there's nothin' on earth like a genuine bona-fide electrified one-car autopilot! What'd I say?

Autopilot!

What's it called?

Autopilot.

That's right! Autopilot!

Autopilot, autopilot, autopilot, autopilot, autopilot...

I hear those things are awfully new.

It's user tested, but not by you.

Is there a chance the car could crash?

It's not your life, so splash the cash.

First adopters must be brave...

They'll be given early graves.

Will this venture fund new green jobs?

No, good sir, I'm the new Steve Jobs.

We've killed off our whole space program.

Fund my SpaceX, my good man.

I swear, it's the country's only choice! Log in to PayPal and raise your voice!

Autopilot

What's it called?

Autopilot!

AUTOPILOT!

But the economy's still all fucked and broken.

Subsidies, this man has stolen!

Autopilot
Autopilot
Autopilot!
Autopilot!!!

Auto...*CRASH*

Comment Re: So funny (Score -1, Troll) 171

Uh, he's using MY money, not his. This guy gets a mountain of government handouts and builds a bunch hype, then he gets fat off of idiot investors who buy all the hype.

He literally has a project called "Hyperloop". The "hyper" part is how he's drumming up a fucking train as if it cured aging, gave everyone a puppy, and was made of oral sex. The "loop" part is the never-ending cycle of hype, investment round, hype, investment round, ... that he runs without ever producing anything.

Comment What (Score 5, Informative) 130

"Japan Will Make Its Last-Ever VCR This Month"
"Funai Electric, the last remaining Japanese company to make the units, has announced that the company will cease production on its VCR units, due to declining sales and difficulty acquiring parts."
"Their VCRs are made in China and sold in many territories, including North America, under brand names like Sanyo, but last year's figures reported just 750,000 sales worldwide."

So China will make its last VCR under contract for a Japanese rebrander.

Slashdot Top Deals

A committee is a group that keeps the minutes and loses hours. -- Milton Berle

Working...