• 1 Post
  • 375 Comments
Joined 1 year ago
cake
Cake day: July 7th, 2023

help-circle




  • It’s an SQL injection joke.

    Basically, when dealing with databases, you can use SQL to search or modify the data in that database. By default, you can do this by polling the database with an SQL query. But this introduces a vulnerability called SQL injection. Basically, imagine if instead of filling in a name in the “Name” field, you filled in an SQL query. If the database admins haven’t protected themselves against it, then the database will happily run that query; You have just injected an SQL query into their database. Maybe you’re a malicious attacker, looking to get a virus onto the system, or looking to extract the data.

    Protecting the database from injection is done with something called sanitizing. Basically, you set up filters to disallow SQL, so it can’t touch your database. In this comic, the database admins didn’t do that, so they were unprotected.

    The actual SQL uses the student’s middle name to search for any tables named “Students” and permanently delete it. The joke is that when the school admin staff enters his name into their database, it will delete any tables named “Students” and wreck their database.


  • This is something that has always interested me. Let’s say a group of specialists (in different areas of study) go for a walk through the park together. They’ll each have entirely different thoughts about the walk, simply because they have been trained to notice different things.

    Maybe one is an avian biologist, and notices a rare bird; The other specialists don’t even notice that it is extraordinary.

    Maybe one is an architect, and notices how the trails are snaked through the park with careful consideration to a specific design style.

    Maybe one is a child development specialist, and notices how the playgrounds have been designed to encourage kids to play together with group activities, rather than isolating them with individual activities.

    Maybe one is a civil engineer, and notices how the entire park is a former landfill that has been buried, and they can identify many of the strategies that builders used to safely manage things like off-gassing, water runoff, or low spots as garbage breaks down below the park.

    Maybe one is an artist, who notices several idyllic spots they could return to with an easel and their pastels.

    But the point is that even though they all went on the walk together, they all had vastly different experiences simply because they were trained to notice different details.


  • I gave up TV for a while, but built an automated Plex server about a year ago and have fallen in love with it. I find myself watching more shows than in probably the past decade. My wife was less than thrilled about the initial cost (and the fact that she lost some closet space to the server) but now she uses it every day and refuses to ever let me get rid of it.

    For the unaware, Plex is a program that allows you to self-host a streaming service like Netflix or Hulu. You add media to the server, and it will automatically match it to the relevant show, download metadata, and make it available to your client devices to stream. The free version is fine for most small setups, but there is a paid license you can get to unlock all of the functionality; Most users opt to just get a lifetime license, so it’s not an ongoing cost.

    If you prefer open source, Jellyfin is a good alternative. There’s a little bit more of a learning curve, because the client apps aren’t widely available and it often requires using something like Kodi to stream instead. But the idea is the same; Host a server, throw media at it, and be able to stream.

    Automating the media collection is possible, and is what takes it from “this is a cool side hobby that I’ll abandon in a few months because the upkeep is a pain in the ass” to “this is now my go-to for shows I want to watch, and the upkeep is minimal.” Programs exist that allow your server to automatically search for media Linux ISOs, download it, and add it to your server. So adding new media Linux ISOs is simply a matter of requesting it to be added, and then the server handles all the rest automatically and you’ll have it available as soon as the download finishes.

    My one big complaint about Plex is actually the lack of live IPTV support. You can integrate a digital TV tuner into your server to be able to automatically DVR live content. But Plex used to support an IPTV extension, which allowed you to add your own IPTV channels and stream them on any device. Plex did away with that extension support, because they have been pushing their own IPTV channels and they didn’t want to compete with the extension.






  • Worth noting that the masks in the cabin aren’t designed to keep you awake. They’re just designed to keep you alive. They’re basically just hydrogen peroxide and a catalyst, which mixes when you pull the mask down. The resulting chemical reaction produces a small amount of oxygen for a short time. This is also why the instructions say to put your own mask on before helping any children; You only have 15-30 seconds of usable consciousness before you pass out, so you need the mask to stay awake long enough to help anyone else. The pilots are the only ones who actually have masks good enough to stay awake, and that’s why they immediately dive to a breathable altitude.

    Also, the entire cabin would immediately fog from the sudden pressure and temperature change. We’re talking “can’t even see your fingertips when your arm is outstretched” levels of fog.

    And while we’re talking about it, the cabin would suddenly be cold. Like absolutely fucking freezing.

    Lastly, your ears will painfully pop, and will likely ring for a while afterwards. The sudden pressure change will feel like you got slapped on the ears.








  • Something something Dunning-Kruger Effect. Dumb people who know very little about a topic will tend to overestimate their knowledge about said topic. As you gain more knowledge about the topic, the more you realize you don’t know, and the less confident you are about it.

    In extreme cases, it ends with the person having Imposter Syndrome. When a person is very knowledgeable and experienced in a certain topic, but believes they aren’t qualified enough to be considered an expert. They feel like an imposter who will inevitably get outed by someone more knowledgeable than they are. So they have a lot of anxiety about speaking on the topic, because they’re afraid it will result in them being outed as an imposter.