• bleistift2@sopuli.xyzOP
      link
      fedilink
      English
      arrow-up
      9
      arrow-down
      1
      ·
      2 days ago

      Persist everything to disk in real time.

      That’s the thing I’m trying to avoid.

      • barsoap@lemm.ee
        link
        fedilink
        arrow-up
        3
        ·
        edit-2
        2 days ago

        Easier to do than to get never-exercised edge-case code to work flawlessly. Are you sure you can’t just throw sqlite at the problem? It’s often overkill but, hey, it’s there on the shelf, might as well use it and I’ve seen it out-perform hand-rolled data structures. Non-persistent ones, written by very confident C coders. And remember crashes are unavoidable, if nothing else then someone can trip over the power cord.

        • bleistift2@sopuli.xyzOP
          link
          fedilink
          English
          arrow-up
          2
          ·
          edit-2
          2 days ago

          You can’t know that from my issue description, but throwing a database at that problem really is ridiculous overkill.

          Still thanks for the suggestion

          • barsoap@lemm.ee
            link
            fedilink
            arrow-up
            1
            ·
            edit-2
            2 days ago

            It’s mostly about throwing ACID at the problem, sqlite just happens to be battle-tested to a ludicrous degree, it’s light enough to not be unconscionable overhead in simple situations (unless you’re on embedded), and performant enough to also deal with nastier situations so I prefer it over some random K/V store with the same guarantees. It’s also a widely-used and stable data format which might come in handy.

            That said, if you want to go lightweight do consider good, ole, POSIX filesystem guarantees, in particular that mv is atomic (as long as you stay on the same filesystem but that’s easy to ensure by mv’ing within a directory). That’s not durable on its own, you’ll need to fsync for that, and consistency and integrity is up to your code.