WTF Bites
-
@ixvedeusi said in WTF Bites:
a few MB
A few what? Men in Black? What does it have to do with server database solutions!?
-
@ixvedeusi said in WTF Bites:
a few MB
A few what? Men in Black? What does it have to do with server database solutions!?
They won't let you remember.
-
a few MB
A few what? Men in Black?
Oh yes, sorry I'd typoed MiB there, which, obviously, has only ever stood for the most awesome defenders of humanity in intergalactic society.
-
-
@kazitor Our corporate updater (Standard microsoft tools? What are you talking about?) likes always-on-top dialogs covering a quarter of the screen at the strike of noon.
When you think of it, having to wait for updates to install at work makes no sense. Modern PCs can be turned on and off via network commands or on a schedule. Updates could be done at nights without the user even noticing.
-
@Zerosquare While the corporate laptop is safely sitting in my laptop bag at a secure location at home? With the wifi harware disabled? I doubt it.
-
@Zerosquare according to one random forum post I found in Google:
All the so called solution to this are some form of hack. A machine does not have a IP address when there is no OS running it only have a MAC. Attempts to port forward to the machines IP do not work because the ARP entry in the router will time out. Besides a machine it not technically suppose to wake up to packets sent to its mac address it is suppose to wake up to packets send to the broadcast mac address.
This is one of those if the machine follow the standard for WoL to the letter you pretty much can't do it. If it deviates from the standard then there is no way to know what non standard things work and which do not. This is the same for a router. The support for this is called directed broadcast and is a feature I have only seen on commercial routers. It is disabled by default because you can cause broadcast storms with specially crafted packets.
You can keep working on it but even you get it to work it may not work consistently because of things like arp timeouts.
You will be very lucky to get it to work on a wired lan port I suspect you will never get it work on a wireless port because of the encryption.
-
@PleegWat: I was thinking of desktops at work, not laptops.
@Gąska: I admit I've never actually tried it. But what you quoted seems strange. I've read that modern Intel processors include remote management features that work even if the machine has no OS installed or is turned off. So I assume we're past the point where getting a machine to power up remotely can't be done reliably.
-
MSDN pages before the javascript finishes loading:
-
@Carnage Ah, Fjollträsk. Men de första 4 bokstäverna stämmer överens iaf.
Smørrebrød, smørrebrød, røm pøm pøm pøm?
Stop talking Danish.
-
Do I get the Linux or the Windows version?
I guess it depends on what flavor of error I want today!
-
This post is deleted!
-
If you don't care about column order
Is there ever a case where you do care?
mysqldump --skip-extended-insert | mysql
?
-
-
@ixvedeusi said in WTF Bites:
Anyone told you yet that it stores all data as strings?
That would be wrong.
-
Do I get the Linux or the Windows version?
I guess it depends on what flavor of error I want today!
-
Anyone told you yet that it stores all data as strings?
That would be wrong.
I suppose it would, but it's easy to mistake the result as being implemented like this.
-
@ixvedeusi said in WTF Bites:
I suppose it would, but the result looks quite similar from the outside.
It's got five actual types of which four are fairly conventional, but they're not exactly the same as types in other databases (as the real types are value-associated, not column-associated; columns just have type affinities).
Only
TEXT
andBLOB
are string-like.INTEGER
andREAL
are not. (NULL
is something else.) But the DB will convert the numeric types to strings for you if you apply a string operation to it; doing that is fairly well-defined.
-
It's got five actual types
Yes, and you can store any and all of them in a BOOLEAN column, making it feel like it's all strings.
Anyway, I was just going for the typical snarky comment you might hear from a typical SQLite basher, and now you've come and spoiled it all with actual facts
Truth be told, I don't actually have a problem with the way it handles types. I like SQLite a lot and find the range of features it provides quite impressive considering its minimalist approach. It's awesome to have such a thing freely available and has been very useful to me. Really the only thing that's been a problem for me is the limited schema modification support.
-
@Zerosquare said in WTF Bites:
I've read that modern Intel processors include remote management features
I seem to have gathered not all of them do. For desktops K SKUs used not to have it (but 9xxx now do). And motherboard must have Intel NIC, and its chipset must also support it. For desktops, consumer chipsets (Z, H and B) don't. Not all Q (business) and W (server) do either.
When the big bad bug was discovered last year, I tried to check it on quite a few devices I could get my hands on, and none of them would do anything.
Also, from the link above:
Consumer PCs with consumer firmware [...] are not affected
Now, why there even is Management Engine firmware in devices that don't support it, and why there are drivers provided that seem to do fuck all... probably so that GCHQ and chums can tune in anyway :tinfoil:
-
@ixvedeusi said in WTF Bites:
Really the only thing that's been a problem for me is the limited schema modification support.
Changing the type affinity of a column ought to be easier than it is. Removing a column that isn't in an index, constraint or trigger ought to be easier. Neither have been a big problem in practice. Of course, that's usually because I just make a new DB whenever I alter the schema; I simply don't really need things to be very persistent for this application (and a DB like Postgres would be utter overkill for it, to the point of being actively wrong).
-
@ixvedeusi said in WTF Bites:
a few MB
A few what? Men in Black? What does it have to do with server database solutions!?
No, that would be MiB. What he meant as written was "a few Marlon Brandos"
-
Changing the type affinity of a column ought to be easier than it is.
This, specifically, I have encountered (with less-than-perfectly thought out initial schemas in hobby projects). I suppose I could have just ignored the column's type affinity and stored my wrongly-typed values in there anyway, but that really feels kinda dirty.
-
Because that's not the correct syntax for renaming a column, in any database.
-
@Lorne-Kates said in WTF Bites:
Because that's not the correct syntax for renaming a column, in any database.
,
-
@ixvedeusi said in WTF Bites:
a few MB
A few what? Men in Black? What does it have to do with server database solutions!?
No, that would be MiB. What he meant as written was "a few Marlon Brandos"
$ snmpget -v2c -c public 172.52.19.32 sysName.0 iso.3.6.1.2.1.1.5.0 = STRING: "men_in_black"
-
OK, I solved it now, but don't tell me this is not incredibly confusing.
Library:
public static object SomeFuction(Type structureType);
Me: Alright, I need to pass a type.
SomeFunction(MyStruct)
Compiler: "ERROR! MyStruct is a type which is not valid in the given context!"
Me:(ノ°Д°)ノ︵ ┻━┻
-
@anonymous234 said in WTF Bites:
OK, I solved it now, but don't tell me this is not incredibly confusing.
Library:
public static object SomeFuction(Type structureType);
Me: Alright, I need to pass a type.
SomeFunction(MyStruct)
Compiler: "ERROR! MyStruct is a type which is not valid in the given context!"
Me:(ノ°Д°)ノ︵ ┻━┻
I literally ran into that oddity on Wednesday! So much bullshit, you'd think they'd provide a hint like "did you mean to use typeof()?"
-
One reason for requiring the typeof operator is surprisingly sensible: you can have a variable, property or field with the same name as a type.
-
@Tsaukpaetra said in WTF Bites:
@anonymous234 said in WTF Bites:
OK, I solved it now, but don't tell me this is not incredibly confusing.
Library:
public static object SomeFuction(Type structureType);
Me: Alright, I need to pass a type.
SomeFunction(MyStruct)
Compiler: "ERROR! MyStruct is a type which is not valid in the given context!"
Me:(ノ°Д°)ノ︵ ┻━┻
I literally ran into that oddity on Wednesday! So much bullshit, you'd think they'd provide a hint like "did you mean to use typeof()?"
Wow, that's dumb. At least Rust is descriptive about it.
-
@pie_flavor it still doesn't say what exactly you have to do, so the people who don't understand there's a difference between a type and an object that represents a type would still rant about it.
-
@Tsaukpaetra said in WTF Bites:
Does your version sleep at all? My copy seems to poll, and spins the core it's running on at 100 percent.
No, but I have noticed the following mild annoyance on Windows: the server fails to open log file if the log file already exists. You need to delete it before running.
-
@Gąska It being TypeId instead of Type helps, along with a namespace so you can go look it up.
-
@pie_flavor are you really unable to come up with Google search phrase that will tell you why types don't work as
Type
function arguments?
-
Jesus christ what the fuck is up with visual studio wanting to load a billion million trillion gazillion dll "symbols" every time you run a c++ project?
You're like "I'll let it load them this time" but somehow each one takes like 30 seconds and they never seem to end so you hit cancel but now it takes 2 minutes to cancel jesus fuck.
Edit: my bad. It doesn't take 2 minutes, it literally crashes forever.
-
@pie_flavor BTW considering what functionality the
Type
object provides, I'd sayTypeId
would be a very bad name for it.
-
Am I the only one who thinks the "Visual C++ redistributable" is a major WTF in itself? I mean, you write some simple C++ code that only depends on Windows dlls. You compile it on Visual Studio. Now you need an extra DLL to go along with it, that's specific to that VS version? What the hell are you attaching to my code?
-
@anonymous234 said in WTF Bites:
I mean, you write some simple C++ code that only depends on Windows dlls.
Do you have
main
function? Then you depend on much more than just Windows DLLs. Specifically, you depend on the starting point function that sets up the process and then calls yourmain
, which - guess what! - lives inside the Visual C++ redistributable.Not to mention the entire standard library.
-
the starting point function that sets up the process and then calls your main, which - guess what! - lives inside the Visual C++ redistributable.
OK, I guess there's some stuff to do before main(). But that should be small enough to just be embedded in the exe.
Not to mention the entire standard library.
Surely that's already in Windows?
-
@anonymous234 said in WTF Bites:
the starting point function that sets up the process and then calls your main, which - guess what! - lives inside the Visual C++ redistributable.
OK, I guess there's some stuff to do before main(). But that should be small enough to just be embedded in the exe.
You have the option to embed it in the exe. It just defaults to using DLL instead - which is preferable in most cases.
Not to mention the entire standard library.
Surely that's already in Windows?
It is. But it's been updated several times since Windows was released, and using old (read: ABI-incompatible) version of standard library would be very, very bad.
-
More Mosquitto bullshittery:
The MQTT protocol is fully stateful: the server keeps a list of currently connected clients, ensures they ping every N seconds, with each client having a username to identify it and (optionally) a password or even a client certificate to authenticate it.
Despite that, there is no way to get any information about that list, or even check the status of an individual client. Apparently, the developers insist this is a stupid idea no one should ever need.
-
@Tsaukpaetra said in WTF Bites:
They won't let you remember.
Sounds more like NoSQL to me
What do you mean? It's easy to remember in NoSQL, all you need to know is exactly how you planned to remember each given thing. If you don't even know how you planned to remember it in the first place how did you plan to remember it?
-
If you don't even know how you planned to remember it in the first place how did you plan to remember it?
I forgot.
-
@anonymous234 said in WTF Bites:
More Mosquitto bullshittery:
The MQTT protocol is fully stateful: the server keeps a list of currently connected clients, ensures they ping every N seconds, with each client having a username to identify it and (optionally) a password or even a client certificate to authenticate it.
Despite that, there is no way to get any information about that list, or even check the status of an individual client. Apparently, the developers insist this is a stupid idea no one should ever need.
Yeah, I wondered at that too. Like, why not make a system topic with subtropics to get at the internal goodies?
Oh well...
-
@Tsaukpaetra said in WTF Bites:
system topic with subtropics
These would, recirculate the best posts upward? Toward the middle latitudes? This sounds really interesting if the implementation difficulty can be worked out. With fluid-dynamic moderation the biggest chunks could rise in a perfectly natural fashion
-
Small wtf of my day: So, I got myself a USB-C to HDMI adapter and plugged that into my MacMini (you may remember: The one which did not properly resume from suspend when using the full resolution of a 1440p 21:9 screen).
When the native HDMI port is connected to the 21:9 screen and the Thunderbolt port is connected to a 1080p 16:9 screen then resume from suspend will work. It will not work if the 16:9 screen is switched off, exhibiting the previous behaviour.
Additionally, mouse pointer and window movement will lag about half a second behind the actual movement of the mouse. But only for one of the two screens - and it seems to be random which one it will be.
-
Small wtf of my day: So, I got myself a USB-C to HDMI adapter and plugged that into my MacMini (you may remember: The one which did not properly resume from suspend when using the full resolution of a 1440p 21:9 screen).
When the native HDMI port is connected to the 21:9 screen and the Thunderbold port is connected to a 1080p 16:9 screen then resume from suspend will work. It will not work if the 16:9 screen is switched off, exhibiting the previous behaviour.
Additionally, mouse pointer and window movement will lag about half a second behind the actual movement of the mouse. But only for one of the two screens - and it seems to be random which one it will be.
:Excellent.jpg:
-
-
-