WTF Bites
-
@Carnage you just described Salesforce normally, how about doing game development with it?
-
@Carnage you just described Salesforce normally, how about doing game development with it?
Well, slightly more painful.
-
@Gern_Blaanston 1337 and 31337 translate to "elite" in the ancient language of the internet. 50337, 91337, and especially 20000 are just nonsense
"Giving leets more sweets". 50337 = soeet
-
@LaoC That's horrible, so I can only assume it's probably exactly what they meant
-
@DogsB said in Programming Memes Thread:
(https://www.reddit.com/r/ProgrammerHumor/comments/wple7e/javascript/)
0:0-6 seconds long Jellyscript!
-
@Applied-Mediocrity here's a nickel, kid. Get yourself a better browser.
-
-
-
-
@Applied-Mediocrity said in WTF Bites:
Jellyscript
I just implemented something like that! Of course, mine was called recursively, so it caused a stack fault.
We have a multiline status which may need ellipsis at the end. If the status wraps to 3 lines, we have to use a smaller font. That triggers a change to re-evaluate the text wrap, which is now back to 2 lines, so back to bigger font. (Rinse and repeat)* (I changed the logic so if we go to a smaller font, we never go back to a larger one until the text is changed)
-
@dcon Tomorrow:
Make it so that the it does the.
..
and...
when waiting on something
Overmorrow:
Override TextChanging to look whether the text changed only by a number of periods at the end. If so, cancel the event.
Friday:
Change...
to\
|
/
—
for maximum jelly
-
@Applied-Mediocrity said in WTF Bites:
Override TextChanging
Won't have to worry about that! This is a Qt control derived from QFrame. Because multiline ellipsis is not a real thing (had to hand roll it). So we just made
Thing
look like a QLabel.
-
- The client's computer has a purple abomination called Netskope client installed on it.
- Said purple abomination forces http(s) connections through a proxy (fortunately it fails to do it for connections originating in WSL2).
- For some sites it MITMs the connection. Not all of them, mind, just some. For example
login.microsoft.com
is not affected,dev.azure.com
is not affected, butmanagement.azure.com
is. - The last breaks some operations of the Azure CLI (
az
). az
helpfully links documentation that tells you where to add the certificate.- Of course it has it's own certificate store. Including on Linux.
… count the s.
-
@Bulb so it's a system-level proxy, not just the browser? Or for extra points does the browser change the system proxy?
-
dev.azure.com
is not affected, butmanagement.azure.com
is.So developers don't get MITM, but managers do? Sounds like it's working properly
-
Netskope client
My client company used that for a while. It's supposed to, to my understanding, independently encrypt communication between the computer and cloud-based services.
-
@Bulb so it's a system-level proxy, not just the browser? Or for extra points does the browser change the system proxy?
Yes, it seems to be a system-level transparent proxy.
It was sort of funny how I tracked the problem down to it too. The thing takes a couple of seconds to restart itself whenever I change the network configuration, e.g. going on or off the VPN. And it does indicate whether it's running via a tray icon. So when I connected to the VPN, the first request went through just fine, but then it stopped working as the netskope client kicked in, making it very obvious it has it's fingers in it. So then I checked the certificate with
openssl s_client
. Which, being just a plain TCP+TLS client does not respect a http proxy setting, demonstrating it's indeed system-level.@e4tmyl33t said in WTF Bites:
Netskope client
My client company used that for a while. It's supposed to, to my understanding, independently encrypt communication between the computer and cloud-based services.
I think that's some other thing. The company makes a bunch of loosely related tools.
This one is really a transparent proxy routing all your http and https traffic through a ‘web firewall’ somewhere. Which blocks some connections completely, inspects some others by decrypting them and re-encrypting with its own certificate, and lets other be because … maybe because they consider it more trustworthy and don't want to use up CPU power on it or something.
As usual for such nosey proxies, it is occasionally blocking things for bogus reasons.
-
Today's post in Raymond Chen's blog is -worthy:
-
@Zerosquare said in WTF Bites:
Janet Jackson had the power to crash laptop computers
-
@Zerosquare said in WTF Bites:
Janet Jackson had the power to crash laptop computers
I thought that was LaToya's deal.
-
@Zerosquare said in WTF Bites:
Janet Jackson had the power to crash laptop computers
I thought that was her “wardrobe malfunction”
-
@Zerosquare said in WTF Bites:
Janet Jackson had the power to crash laptop computers
-
-
@BernieTheBernie said in WTF Bites:
Netskope
Is that the networked version of a
rectoscope
?I’d say so, involves the digital equivalent of gloving up and getting in to examine the shit in detail.
-
Because my vendor is retarded, I need to parse some XML data. Because I don't want to ship a ton data that I don't need across the wire to Oracle, I'm trying to do it right in SQL Server. So, after figuring out how to do it, I end up creating a view so that I can grab what I need. It looks something like this:
create view the_view_name( field, etc ) as select a bunc of stuff... from a_table_with_the_id_I_know cross apply( ...use that id to fetch the TEXT and do XML shit)
My use case is that I need a single instance (which turns into a bunch of rows due to that XML shit), so I'd call this thing something like:
select * from the_view_name where some_id = 1234
Now, when I run the query that defines the view along with that where clause all is good. When I do that with the view, however, the query just keeps running and running and running. I'm assuming that it's going through the whole table before filtering on that ID.
FUCK YOU SQL SERVER
-
@boomzilla said in WTF Bites:
Oracle […] SQL Server
Which one? Or do you have an abomination of a solution that uses both of the worst database engines in the universe for some bonus Whiskey, Tango and Foxtrot?
-
@boomzilla said in WTF Bites:
I'm assuming that it's going through the whole table before filtering on that ID.
It shouldn't, although it does sound like it might be.
Are you running things on SQL Server with SSMS where you can get the execution plan in a sane format or from Oracle?
-
both of the worst database engines in the universe
MySQL and MariaDB would like a word.
Oracle and SQL Server aren't even close to the worst but if you're used to one of them, the other does seem a bit batshit crazy.
-
@loopback0 said in WTF Bites:
MySQL and MariaDB would like a word.
Yes but which engine within those? Are we talking InnoDB or full on MyISAM?
-
@loopback0 said in WTF Bites:
MySQL and MariaDB would like a word.
Yes but which engine within those? Are we talking InnoDB or full on MyISAM?
Yes.
There are several ways they both suck that don't change depending on the storage engine used.
-
@loopback0 I know, just saying that you can have levels of suckitude that you can mitigate.
-
@loopback0 said in WTF Bites:
@boomzilla said in WTF Bites:
I'm assuming that it's going through the whole table before filtering on that ID.
It shouldn't, although it does sound like it might be.
Are you running things on SQL Server with SSMS where you can get the execution plan in a sane format or from Oracle?
Later on it seemed to do the right thing. No idea why it wasn't.
I was doing SQL Server stuff with DB Visualizer, later using SQL Developer to query from Oracle through the dblink to SQL Server.
-
@loopback0 said in WTF Bites:
both of the worst database engines in the universe
MySQL and MariaDB would like a word.
Oracle and SQL Server aren't even close to the worst but if you're used to one of them, the other does seem a bit batshit crazy.
Yeah, I've been working with Oracle for over 15 years and am very comfortable with it. SQL Server is relatively new to me and I hate it. Not helped by having to integrate with some stupid third party shit app (and clean up a bunch of messes that the last guy left behind).
-
Comment on blog post: Why did they ruined the audio instead of making proper isolation for hard drives though? Filtering out frequencies from the audio without user’s consent because of crappy hardware is a very ugly workaround. And laptops can still be crashed by malicious actor using other audio devices.
My thoughts exactly.
-
@boomzilla said in WTF Bites:
Later on it seemed to do the right thing. No idea why it wasn't.
Caching. The query plan gets cached. And some intermediate results may also get cached.
-
Comment on blog post: Why did they ruined the audio instead of making proper isolation for hard drives though? Filtering out frequencies from the audio without user’s consent because of crappy hardware is a very ugly workaround. And laptops can still be crashed by malicious actor using other audio devices.
My thoughts exactly.
The answer is what it always is: because this was cheaper.
-
@Arantor In this case I suppose the difference is mainly in that hardware fix would mean telling all the customers who already bought it to stop by in a local service to get it fixed while a software
fixworkfuckaround could be distributed over the air.
-
@Bulb not only that but if it’s a hardware fix you have to spend money to make the parts and fit them…
-
@BernieTheBernie said in WTF Bites:
@boomzilla said in WTF Bites:
Later on it seemed to do the right thing. No idea why it wasn't.
Caching. The query plan gets cached. And some intermediate results may also get cached.
No, the query is pretty simple (aside from the XML shenanigans). I think there was some goofup with connection pooling. At one point I had to kill a running instance of dbvis and I think it was after that when things got back to normal. Not sure what the problem was exactly but I suspect some kind of deadlock on an open transaction.
-
@boomzilla said in WTF Bites:
I suspect some kind of deadlock on an open transaction.
Oh, those can be
-
@dkf yeah, I think it's biting me that Oracle doesn't put DDL into transactions but SQL Server does.
-
@boomzilla said in WTF Bites:
Oracle doesn't put DDL into transactions
-
@boomzilla said in WTF Bites:
@dkf yeah, I think it's biting me that Oracle doesn't put DDL into transactions but SQL Server does.
Whew! Now DDL transactions (updating a view) appear to hang.
-
@boomzilla use a, real programming language, for parsing, you retard.
-
@Gribnit wish I could.
-
@boomzilla use a, real programming language, for parsing, you retard.
Something like regex?
-
Should we have a thread just for Visual Studio WTFs?
If it hasn't found it by now, I think it's just going to keep spinning indefinitely.
-
-
Should we have a thread just for Visual Studio WTFs?
I think we don't even have one for Xcode WTFs. And Visual Stupido still didn't beat that, though it's certainly trying.
-
@Bulb And threads are certainly too expensive to create one for either of those topics.