WTF Bites
-
@Carnage Not just unwieldy, but also technically incorrect. Not all Wi-Fi networks have internet access. So would such a network be a "l'access sans fil à internet sans accès internet"?
Germans are secretly infiltrating the French made-up-word department.
-
@Benjamin-Hall said in WTF Bites:
Go home xCode, you're drunk. Now it's down to under 4 minutes...and finished while I was typing this (about 1 minute after screen-shotting things).
Given xCode, that's not an unreasonable guesstimate...
-
"le déni sans fil à internet sans accès internet".
Dang, that's twice as existential as
Lę Ęntrąngęr
, at least. Yeah, best leave it to the French.
-
-
@Rhywden Night Shift
-
@Rhywden Yes, TRWTF is people wanting to work for Musk.
-
@Rhywden Have them sit in the hallway outside Musk's private office and share the desk with his secretary. Sometimes you need to rub people's noses in the problem they're making.
-
@Rhywden Have them sit in the hallway outside Musk's private office and share the desk with his secretary.
Because obviously Musk is there. After all, he's not resigning, is he?
-
@Zecc the rules are made by him, they don’t apply to him. Besides he might be off pretending to work in some other venue for a different company for a bit.
-
@Rhywden Have them sit in the hallway outside Musk's private office and share the desk with his secretary.
Because obviously Musk is there. After all, he's not resigning, is he?
That's why you make sure to annoy his secretary as well.
-
@Rhywden Have them sit in the hallway outside Musk's private office and share the desk with his secretary.
Because obviously Musk is there. After all, he's not resigning, is he?
That's why you make sure to annoy his secretary as well.
The floor-cleaners are the ones you want to annoy, and can annoy most effectively. Insufficient office resources indicate also, insufficient restrooms.
-
@Rhywden Have them sit in the hallway outside Musk's private office and share the desk with his secretary.
Because obviously Musk is there. After all, he's not resigning, is he?
That's why you make sure to annoy his secretary as well.
Yes, the path to a long and fruitful career.
-
Why, why would you make a credits music loop whose length wasn't an even divisor of the credits roll length?
-
Minor fuckup over at Epic's Github. Apparently somebody managed to tag around 400k people in a pull request. Hilarity ensues.
-
@cvi How many of them are required to approve it?
-
Relative time, especially when it's misleading
It's if you're trying to get in for free at the swimming pool, but for practical purposes that's a four year old post
-
Minor fuckup over at Epic's Github. Apparently somebody managed to tag around 400k people in a pull request. Hilarity ensues.
Not just once, but three times, it looks like.
-
Relative time, especially when it's misleading
It's if you're trying to get in for free at the swimming pool, but for practical purposes that's a four year old post
But it was a honest message regarding that estimate: because the text reads "not great".
-
While I was having lunch at a restaurant, two guys on the table next to mine talked about their business. They worked in IT too, but more in an administrative or managerial than hands-on position.
Guy 1: "... would disrupt well-coordinated teams. Hence you'd lose productivity."
Guy 2: "I doubt that."
Guy 1: ".... disrupts the well-coordinated teams. And hence, there's the loss of productivity."
Guy 2: "No. I do not think that it will necessarily lead to a loss of productivity."
Guy 1: "But disrupting well-coordinated teams causes loss of productivity."
Guy 2: "That's exactly what I doubt. Some teams are non-productive exactly because they are well-coordinated."I had to laugh when I heard that.
Because ,,, it is true.
-
Health Care is a place of shitty IT. News at 11.
Here in germany, we have health care cards issued by the health insurances. Looks like a credit card, comes with a chip on it, and recently also with some kind of NFC.
Now take such a newer card and put it into the terminal at your local doc...
Crash!
Yeah!
Because of electro-static discharge (ESD). Those terminals have a very low ESD tolerance, and then the doc has to start all the computers, "connectors", terminals again...And article on that topic (in German):
-
@Tsaukpaetra Kinda suspect the second and third time might have been a tad more intentional.
-
So apparently our brave front-end developers finally made the CRUD work. But entering 100s of records is slow*, so I have to (apparently it's not something anyone less senior can do) write a script to import them from a CSV. Which is badly designed and requires magical hard-coded prior knowledge to be useful at all.
I wouldn't mind, but that's already second importer, because now the format changed and there's additional data. I wonder how many different importers will there be eventually.*I think what actually happens is the data model is too complex for their salesman brains (2 tables instead of one), and I'll be writing importers until we fire the client.
-
@sebastian-galczynski said in WTF Bites:
front-end developers finally made the CRUD work
business have front-end developers touching the storage side of the system?
@sebastian-galczynski said in WTF Bites:
I think what actually happens is the data model is too complex for their salesman brains (2 tables instead of one), and I'll be writing importers until we fire the client.
My first suspicion would always be on transaction overhead. Some databases work best with as many inserts in one transaction as possible while others have some optimal size of batch, but inserting under individual transactions (or autocommit) is pretty bad everywhere.
-
business have front-end developers touching the storage side of the system?
Well, merely touching. They don't manage the schema. They write the app responsible for graphQL api and the front-end, I don't remember who exactly does what. Maybe one of them is "backend", but he can't write sql etc.
My first suspicion would always be on transaction overhead. Some databases work best with as many inserts in one transaction as possible while others have some optimal size of batch, but inserting under individual transactions (or autocommit) is pretty bad everywhere.
The database is fine, even the UI probably works for the given task, the problem is that the place we're importing it from has different, simpler data model, so they can't unambiguosly export their data to our system without some magical assumptions, like "if foo is in Parczew, it should have two bars, otherwise one", cause they have no notion of bar. Also the client probably doesn't really understand our model (among other things, but that's another story), so he doesn't know what to click.
Edit: We now have Inner JSON inside CSV. Turns out it can't be edited with Excel, because wrong quotes.
-
You have achieved senior developer: writing jury-rig CSV transformer to convert one CSV to another CSV format to fudge requirements neither the source nor destination systems know how to cope with.
-
@sebastian-galczynski said in WTF Bites:
the client probably doesn't really understand our model (among other things, but that's another story)
This is normal.
-
@sebastian-galczynski said in WTF Bites:
Edit: We now have Inner JSON inside CSV. Turns out it can't be edited with Excel, because wrong quotes.
-
This is normal.
I'm not sure about that, given that our system was ordered as a replacement of the client's old system.
-
@sebastian-galczynski said in WTF Bites:
This is normal.
I'm not sure about that, given that our system was ordered as a replacement of the client's old system.
Even More Normal
-
@BernieTheBernie said in WTF Bites:
Health Care is a place of shitty IT. News at 11.
Here in germany, we have health care cards issued by the health insurances. Looks like a credit card, comes with a chip on it, and recently also with some kind of NFC.
Now take such a newer card and put it into the terminal at your local doc...
Crash!
Yeah!
Because of electro-static discharge (ESD). Those terminals have a very low ESD tolerance, and then the doc has to start all the computers, "connectors", terminals again...And article on that topic (in German):
Don't leave out the best part: On top of the ESD problem, the problematic cards also pull too much current through the circuit at the other end - so not only do you kill the reader by ESD, in the case it survives that it gets over-current on top.
-
problematic cards also pull too much current through the circuit at the other end
? I thought those chips were nearly passive. Like...a milliamp at most. Did a Terminator (or @Polygeekery ) design those to maximize the carnage (no, not you )?
-
problematic cards also pull too much current through the circuit at the other end
That's cause these are special medical grade cards. They probably forgot to solder the batteries.
-
@Benjamin-Hall Well, according to the article, the older cards are equipped with inductively coupled antennas whereas the new ones have galvanically coupled antennas. Looks like this:
(left: without an antenna, middle: inductive, right: galvanic coupling)
The latter collects charge very easily already from the background alone which then leads to the ESD problem. But don't ask me why they were unable to spot this problem. I suspect loads of
-
@sebastian-galczynski said in WTF Bites:
Turns out it can't be edited with Excel, because wrong quotes.
Can it be edited with LibreOffice Calc? It allows selecting which of the various kinds of brain-damage your SSV file was made with.
-
Can it be edited with LibreOffice Calc? It allows selecting which of the various kinds of brain-damage your SSV file was made with.
OK, so the original file of course isn't CSV, it's an XLSX. And while it can be open with LibreOffice, it doesn't respect the default filters set on columns, so I get like 10x more rows than should be imported (and most of the extra rows have some kind of bad data - they must have edited it by hand). Excel on the other hand can't handle the formulas creating the inner json.
I offloaded the conversion to CSV to the Mr Client Wrangler, since he has Excel installed (but on Mac, so it has its own set of problems)Now I have almost parsed it, but there are hanging spaces in some fields holding floats. That's probably why everything parses as NaN.
-
The hanging spaces can't be fixed. Must trim.
Prophet Terry A. Davis coined a word perfectly characterizing what I'm doing here. It can't be quoted outside the garage, but what it means is basically the opposite of divine intellect.
-
@sebastian-galczynski said in WTF Bites:
there are hanging spaces in some fields holding floats. That's probably why everything parses as NaN.
The way Excel sometimes behaves as strongly¹ typed and other times as stringly² typed is infuriating.
¹ Dynamically but strongly—a string and number are different kinds of things that don't mix. E.g. the search function (poor man's join) definitely considers them different.
² That is, weakly—anything gets converted to a string and then to anything it feels like being at the moment. E.g. when you edit it. So you have some joins set up and then you edit a value and it stops joining because it got auto-converted to a number.
-
The way Excel sometimes behaves as strongly¹ typed and other times as stringly² typed is infuriating.
I suspect the hanging spaces came from a too clever attempt to prevent the Polish version of Excel from converting it to actual floats with comma as decimal separator. Thanks, now it's another flavor of wrong.
-
While reading this thread, I noticed this in today's batch of recruiter spam:
-
@HardwareGeek said in WTF Bites:
While reading this thread, I noticed this in today's batch of recruiter spam:
Is that the same, or is one of them misspelled? Is the company name spelled correctly?
-
But don't ask me why they were unable to spot this problem. I suspect loads of
Looks like cost-engineering, when I add up trace area. Then again I might just be seeing things due to Favored Enemy bonuses.
-
@sebastian-galczynski No, different job. This is for a "Computer System Validation" consultant, and the recruiter works for a company called Panzer Solutions. Interestingly, though, both Panzer's client and Azzur Group are in the biotech field.
-
Ok, I loaded the floats. They're geographical coordinates. Something is wrong, looks like they moved from Poland to Saudi Arabia.
Edit: Or am I special for assuming that " Coord. X " is longitude.
-
@sebastian-galczynski said in WTF Bites:
The way Excel sometimes behaves as strongly¹ typed and other times as stringly² typed is infuriating.
I suspect the hanging spaces came from a too clever attempt to prevent the Polish version of Excel from converting it to actual floats with comma as decimal separator. Thanks, now it's another flavor of wrong.
Because why would anyone ever want to open the files saved by your software in a version using a different language than they were stored with.
-
@PleegWat and corrupt all the formulas while you're at it.
-
@sebastian-galczynski said in WTF Bites:
The way Excel sometimes behaves as strongly¹ typed and other times as stringly² typed is infuriating.
I suspect the hanging spaces came from a too clever attempt to prevent the Polish version of Excel from converting it to actual floats with comma as decimal separator. Thanks, now it's another flavor of wrong.
… except if they were actual floats, they would be saved as float, and therefore the decimal separator would depend on the language settings of the machine reading them—over which you at least should have some control.
-
-
@HardwareGeek said in WTF Bites:
a company called Panzer Solutions.
https://wikiimg.tojsiabtv.com/wikipedia/commons/thumb/f/fd/SdKfz161-1-1.jpg/1280px-SdKfz161-1-1.jpg
What's their motto? "We'll roll all over your problems"?
-
@sebastian-galczynski said in WTF Bites:
The way Excel sometimes behaves as strongly¹ typed and other times as stringly² typed is infuriating.
I suspect the hanging spaces came from a too clever attempt to prevent the Polish version of Excel from converting it to actual floats with comma as decimal separator. Thanks, now it's another flavor of wrong.
Because why would anyone ever want to open the files saved by your software in a version using a different language than they were stored with.
I hate this shit so fucking much.
My software writes out numbers in C locale, like any sane computer-parsable file should. Why the fuck does excel insist that the content should be different when I open it with a different default language, and why do they make me jump through 20 steps to un-fuck it?
-
@topspin Because accountants are used to working in their locale and rarely interacted back when Excel was conceived (it's not really true any more) with accountants in different countries…
It wouldn't be a problem if Excel treated things consistently. A lot of other software can work internally in locale-agnostic way and display things according to the selected display locale mostly fine. I don't know why it's so effing difficult for Excel.