• GBU_28@lemm.ee
    link
    fedilink
    English
    arrow-up
    8
    ·
    1 year ago

    No closing semicolon, anyone got any extras to throw on this thing?

    • krotti@sh.itjust.works
      link
      fedilink
      arrow-up
      0
      ·
      1 year ago

      Honest question, which ones wouldn’t it work with? Most add a semicolon to the end automatically or have libraries and interfaces saved me a million times?

      • GBU_28@lemm.ee
        link
        fedilink
        English
        arrow-up
        0
        arrow-down
        1
        ·
        1 year ago

        Other reply s accurate but it’s always a good practice to include the semicolon else you can get

        “Bobby tables’ed” look that xkcd comic up

        • Doc Avid Mornington@midwest.social
          link
          fedilink
          English
          arrow-up
          2
          ·
          1 year ago

          I’m not sure how including a final semicolon can protect against an injection attack. In fact, the “Bobby Tables” attack specifically adds in a semicolon, to be able to start a new command. If inputs are sanitized, or much better, passed as parameters rather than string concatenated, you should be fine - nothing can be injected, regardless of the semicolon. If you concatenate untrusted strings straight into your query, an injection can be crafted to take advantage, with or without a semicolon.

  • Truck_kun@beehaw.org
    link
    fedilink
    English
    arrow-up
    2
    ·
    1 year ago

    That SELECT and WHERE are all caps, but from is not is bugging me.

    I don’t care if you choose to uppercase keywords or lowercase, but consistency please.

    Also, great, love it.

  • Akrenion@programming.dev
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    Can anyone recommend a cheap receipt printer that takes pictures from a pc or phone? I want to print mtg tokens on the fly.

    • jasondj@ttrpg.network
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      Gameboy Pocket. Gameboy Camera. Gameboy Printer.

      Both the perfect balance of “nostalgia” and “ridiculous”.