via: @memes@wetdry.world

https://wetdry.world/@memes/112717700557038278

the sqlite codebase is a gem.

tldr; mcaffee made a shit ton of sqlite files in the temp folder causing people to call the sqlite devs phone angrily. now they name all files etilqs to prevent this.

Text from the screenshot:

2006-10-31: The default prefix used to be “sqlite_”. But then Mcafee started using SQLite in their anti-virus product and it started putting files with the “sqlite” name in the c:/temp folder. This annoyed many windows users. Those users would then do a Google search for “sqlite”, find the telephone numbers of the developers and call to wake them up at night and complain. For this reason, the default name prefix is changed to be “sqlite” spelled backwards. So the temp files are still identified, but anybody smart enough to figure out the code is also likely smart enough to know that calling the developer will not help get rid of the file.

Code found at: https://github.com/sqlite/sqlite/blob/master/src/os.h#L65 (The line numbers in the screenshot and the code don’t match up)

  • dohpaz42@lemmy.world
    link
    fedilink
    English
    arrow-up
    12
    ·
    4 months ago

    If that information said something like “McAfee users concerned about temp files, call (800) 123-4567”, then yes. Did I suggest anything more than that? No. 🙄

    • cm0002@lemmy.world
      link
      fedilink
      arrow-up
      53
      ·
      4 months ago

      Lol you never worked customer service or hell desk have you?

      The kinds of people who need this message, you would have lost the second you said “temp files”

        • cm0002@lemmy.world
          link
          fedilink
          arrow-up
          25
          ·
          4 months ago

          Irrelevant, these people will find their way into folders they have no business in and no idea what it’s doing and break shit

          It’s a big reason MS started hiding the windows folder after Win 98 (maybe 95)

          • dohpaz42@lemmy.world
            link
            fedilink
            English
            arrow-up
            2
            ·
            4 months ago

            How is that irrelevant? The folder is literally called Temp. Doesn’t matter anything else. You said, and I quote, “The kinds of people who need this message, you would have lost the second you said “temp files”.”

            Obviously not sure, given where the files were located. 🤦‍♂️

            And of course they didn’t know what the files were for; probably why they went searching for it, and eventually found the contact info for Richard Hipp.

            Me thinks you just want to shit on people for no other reason than to make yourself feel superior to them. 👏 Congrats!

        • T156@lemmy.world
          link
          fedilink
          English
          arrow-up
          7
          ·
          edit-2
          4 months ago

          Assuming that they went out to look for it, and didn’t just poke google with (“sqlite hacked my computer”) until they found a phone number.

          If they had gotten the phone number for a company called Super Queasy Lite and Easy/SQLitE instead of the developers, the company might well have received the calls instead.

          • tyler@programming.dev
            link
            fedilink
            arrow-up
            2
            ·
            4 months ago

            Assuming that they went out to look for it, and didn’t just poke google with (“sqlite hacked my computer”) until they found a phone number.

            and how in the world did they know to type the word “sqlite” in. Dude, the files are in the temp folder. The only way they know the name “sqlite” is if they literally visited the folder and looked there.

            • T156@lemmy.world
              link
              fedilink
              English
              arrow-up
              1
              ·
              4 months ago

              Error message? McAfee can’t write to the drive because it’s full of photos of their grandchildren and dogs, so it clicks up “can’t write to c:\temp\sqlite_arcane_computer_magic.log: Disk is full”, and it goes from there?

      • dohpaz42@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        4 months ago

        You do realize that these people were looking up contact info from a company they found because they were … wait for it … looking at files inside the temp folder … otherwise known as … are you sitting down? You really should sit for this … temp files!

        Imaging that. 😳 🤣

        By the way, I worked technical support for my local dialup ISP, Adobe, Best Buy (before they were called Geek Squad), and OnStar.

        But sure, what you said… 😉

        • relevants@feddit.de
          link
          fedilink
          arrow-up
          7
          ·
          4 months ago

          looking at files inside the temp folder … otherwise known as … are you sitting down? You really should sit for this … temp files!

          The point OP is making is that those people would not put 2 and 2 together to understand that the files they were looking at are called temp files, just because that’s the folder they found them in. They may not even remember the name of the folder, only that it contains a bunch of files with a prefix they’re now googling.

          Not sure why I’m bothering explaining this to you, the way you responded makes you look absolutely insufferable, but maybe someone else who comes across this will find it useful.