• unalivejoy@lemmy.zip
      link
      fedilink
      arrow-up
      34
      ·
      6 months ago

      Me: Puts a boolean into sqlite

      Me: Asks for that boolean

      SQLite: “Here’s that int you asked for”

      • AllNewTypeFace@leminal.space
        link
        fedilink
        arrow-up
        10
        ·
        6 months ago

        Also, Tcl (a cute little scripting language from the 90s, best known for giving the world the Tk UI toolkit; it was somewhat Lispy, only under the hood, worked like sh, where everything was a string).

        • brian@programming.dev
          link
          fedilink
          arrow-up
          7
          ·
          6 months ago

          more directly, sqlite was originally for tcl which is why they share the semantics.

          also I’d argue that sqlite is a bigger contribution than tk, but I suppose in a more roundabout way

        • ChrysanthemumIndica@discuss.tchncs.de
          link
          fedilink
          arrow-up
          1
          ·
          6 months ago

          Does GNU make count? It’s crazy what you can do with the macro expressions, basically a Functional language using only string types. There’s even a math “library” that will do arithmetic with numbers in strings.

    • saltesc@lemmy.world
      link
      fedilink
      arrow-up
      9
      arrow-down
      3
      ·
      6 months ago

      God, I’m so over SQL.

      It’s great, but it is so old and shows it. Feels like 99% of my SQL queries are just cheese.

      Works though, and quick.

      • mesa@piefed.social
        link
        fedilink
        English
        arrow-up
        22
        ·
        6 months ago

        SQL is the only bedrock in my entire career. Its the one thing that has stayed relevant.

        SQL is great but when you start having issues processing what is actually going on, its fine to pull out what you need and throw another language on top (python, C#, etc…etc…). Getting it to work slow is one step in making it fast again.

        • saltesc@lemmy.world
          link
          fedilink
          arrow-up
          1
          ·
          6 months ago

          Yeah, this is what I end up doing. SQL does all the heavy lifting, and python or M usually doing the rest. Though M can be soooo slow.

        • JackbyDev@programming.dev
          link
          fedilink
          English
          arrow-up
          3
          ·
          6 months ago

          I don’t really mind them either, it’s just exciting that there is finally a way to make it actually act type safe.