The Official Good Ideas Thread™
-
It seems overly obvious to me why you would do that, so I'm confused by the mere question.
-
-
Okay, I got the @r10pez10 one, but what's important to know about Ted?
-
Okay, I got the @r10pez10 one, but what's important to know about Ted?
He's looking for a date.
But actually I just read what @Yamikuronue said and it made me think of that line.
-
Not integer overflow. No, no, definitely not integer overflow.
-
Feeling whimsical...
Those 32-bit integers just cause all kinds of trouble. Google had that problem with their web page database. I heard somewhere about some stupid thing called "I Pee V4" or something like that. When will we ever learn that 2,147,483,647 is just not enough?
(Oh I know, some of you are so clever, you think about using that sign bit, but 4,294,967,296 is not enough either.)
CREATE TABLE AllPeopleOnEarth ( ID integer [blah blah blah] , Name varchar [stuff] );
"What you mean, 'Five billion too few? Sigh.`"
Whenever will we learn that 32-bit integer just won't cut the mustard anymore? Or the cheese, either? Oh, wait, that's another topic.
"The world is not enough," Bond said. "The world is too much!" is better, when talking about integers.
-
the Match ID can really only go up to 2^31 before it looks like a negative number to SQL. That cut the Match ID namespace in half.
...why, what's wrong with negative numbers?
-
Presumably they're using
ORDER BY match_id
or something.
-
They should've changed it to
ORDER BY match_created_date_time
or something. Trying to extract any sort of actual information from anid
field is .
-
What if two matches started at the same millisecond? It's much safer to sort by ID than by a timestamp.
-
Does it matter which order you sort two matches that started at the same millisecond? If so, why would it matter? You're not using it to identify matches, just to sort them into an order that's useful for humans.
-
The match IDs are the identity of the match, though. For example, match 2175986278 is a professional match that's going on right now.
-
Yes, and? Converting any given match ID to/from negative to uint32 can be done outside the database, if it's necessary at all. It's just different nomenclature.
-
People like you are the reason everything will break in 2038.
-
Nah, I don't have a problem with them upgrading. "Because they'd have to upgrade anyway eventually", if that's their reason, then fine. I just found it weird that they're freaking out about the ID overflowing to negative numbers and how half of their 32-bit rug got cut right out from under them, because there's no fundamental reason why negative numbers shouldn't make good IDs.
-
If your IDs overflow, that's your sign to immediately stop everything increase the domain of your IDs.
-
They were about to overflow to negative numbers, which hadn't previously been used. They still had the half of the domain that they were complaining about not having. That's like freaking out about being out of gas because your 10-gallon gas tank is almost empty and you're not using any gas from your 10-gallon reserve gas tank because of raisins.
If you want to immediately increase the domain of your IDs when that happens, that's fine, but acting like you can't use the negative numbers made me go .
-
They were about to overflow to negative numbers, which hadn't previously been used. They still had the half of the domain that they were complaining about not having. That's like freaking out about being out of gas because your 10-gallon gas tank is almost empty and you're not using any gas from your 10-gallon reserve gas tank because of raisins.
If you want to immediately increase the domain of your IDs when that happens, that's fine, but acting like you can't use the negative numbers made me go .
Depending on the database engine, they may not have been able to easily uses negative numbers. In DB2, we typically use a declaration like this for ID columns:
create table mytable ( ID integer generated always as identity ( start with 1 , increment by 1 , no cycle , minvalue 1 , maxvalue 2147483647 , cache 20)
Under that declaration, it won't wrap at all, much less to negatives. Since the numbers have to be in ascending sequence, it would have to be dropped and recreate as:
create table mytable ( ID integer generated always as identity ( start with -2147483648 , increment by 1 , no cycle , minvalue -2147483648 , maxvalue 2147483647 , cache 20)
...and the existing rows would have to be renumbered, which would only be a small headache.
-
What if two matches started at the same millisecond?
Then you put a sequence number in, duh. /
-
Good idea: this ufo lamp
-
-
-
Awe, but then I need to get a fancy adapter for all my cards!
-
Perhaps the best idea ever?
Hiring a lawyer for a parking ticket appeal is not only a headache — it can also cost more than the ticket itself.
Depending on the case and the lawyer, an appeal (a legal process where you argue out of paying the fine) can cost between $400 to $900.
But with the help of a bot made by British programmer Joshua Browder, 19, it costs nothing.
Browder's bot handles questions about parking ticket appeals in the UK. Since launching in late 2015, it has successfully appealed $3 million worth of tickets.
-
Wasn't handling certain legal matters high on the list of "most likely jobs to be automated away by computers"?
-
I felt a great disturbance in the Legal Force, as if millions of voices suddenly cried out in terror and were suddenly silenced. I fear they might have realized that they can now charge more.
Filed under: Butchered quotes
-
-
I always enjoy seeing technological solutions to human-created problems.
It's like "here's some bullshit you have to go through" "fuck you I'm an engineer".
-
http://imgur.com/hR9olSV.gifv
(I edited the URL in your quote so it embeds as a video, as much as I enjoy a 63.4 MB GIF)
Here's an unfortunately rather sparse article on that computer mod.
Edit:
###1995 IBM Aptiva build, 66mhz 486DX2 to i7 6700k!
Guy converts an old PC case into a modern gaming PC. I especially like his floppy-lookalike SD card reader.
Not so sparse.
-
Now implement a B: drive for 5¼" discs.
-
Updated, thanks.
-
-
Hah, Andy Warhol did it already. Several times. And still got banned.
Admittedly, one of those was of a guy's face as he was getting his dick sucked (Blow Job) and another was of his sleeping boyfriend's naked ass (the imaginatively titled Taylor Mead's Ass - a film critic who quipped that all of Warhol's films were nothing more than "a camera pointed at Taylor Mead's ass for two hours", so Warhol did exactly that and reportedly said, "Your wish is my command, Mr. Koestenbaum" at the release party), but seriously, he filmed an eight hour shot of the Empire State Building from the street level (Empire) and then played it slower to pad it out to 12 hours. And got paid to do it. If you or I did it, it would be boring, but when he did it, it was 'genius', right?
-
https://www.kickstarter.com/projects/biemspray/the-biem-butter-sprayer
Unfortunately, $129 puts it well above the price range that I'd be willing to spend.
-
-
-
@anonymous234
How French can you be?
-
@Luhmann Needs onions on her belt, a beret, and a black-and-white striped top
-
-
Thank you for getting me hooked on xkcd:
Serenity is coming out tomorrow
Filed under: I am still, after several years, playing "catch up" on Dilbert and friends
-
@loose Dilbert doesn't need catching up; the longest I've ever seen a story arc there was a couple of weeks, and at the end nothing changes.
At work, we like to say it's not a comic, it's a documentary…
-
@dkf Which is mostly why I don't stress over it. I will select a random point in the past and read for as long as I can. The problem is that I can never remember where I stopped reading. So, on the next session, I will select another random point and hope that there is no overlap. On those occasions where I hit the middle of an arc, I just skip backwards. It is mostly timeless and I am old enough to appreciate obscure and ancient references to technologies and companies that have fallen by the wayside.
-
@loose https://www.comic-rocket.com/ has Dilbert, and tracks the last strip you read
-
Why don't we have this yet?
-
@cartman82 said in The Official Good Ideas Thread™:
Why don't we have this yet?
Ask the French. They were the last to try and implement a new calendar.
Doesn't NYD manage to break the assumption that, e.g. one week from a Saturday is next Saturday? That would cause more problems than not knowing that the 19th is a Thursday
-
@cartman82 Kodak actually used that calendar internally for a long time. It's called the International Fixed Calendar.
-
@Jaloopa said in The Official Good Ideas Thread™:
Doesn't NYD manage to break the assumption that, e.g. one week from a Saturday is next Saturday?
Well... not if it just manages to break the assumption that one week is 7 days.
-
http://www.dispatch.com/content/stories/local/2016/04/07/OSU_protest_at_Bricker_Hall_xNoendsNOW.html
-
@boomzilla well that oneboxing was special...
(but it's working now, for some reason)
-
@anotherusername said in The Official Good Ideas Thread™:
(but it's working now, for some reason)
@ben_lubar has a pull request in to fix that but they haven't merged it. He updated the plugin thinking that it had been. Notified of his mistake, he's reapplied the fix, because otherwise we were going to expel him and have him arrested.