• tofubl
    link
    fedilink
    English
    arrow-up
    29
    arrow-down
    1
    ·
    4 months ago

    Slow and unreliable with sqlite, but rock solid and amazing with postgres.

    Today, every document I receive goes into my duplex ADF scanner to scan to a network share which is monitored by Paperless. Documents there are ingested and pre-tagged, waiting for me to review them in the inbox. Unlike other posters here, I find the tagging process extremely fast and easy. Granted, I didn’t have to bring in thousands of documents to begin with but started from a clean slate.

    What’s more, development is incredibly fast-moving and really useful features are added all the time.

    • Atemu@lemmy.ml
      link
      fedilink
      English
      arrow-up
      5
      ·
      4 months ago

      Slow and unreliable with sqlite, but rock solid and amazing with postgres.

      I haven’t noticed any major performance issues with sqlite. What tasks improved for you when you moved to postgres?

      • tofubl
        link
        fedilink
        English
        arrow-up
        3
        arrow-down
        1
        ·
        4 months ago

        Page loading times, general stability. Everything, really.

        I set it up with sqlite initially to test if it was for me, and was surprised how flaky it felt given how highly people spoke about it. I’m really glad I tried with postgres instead of just tearing it down. But my experience is highly anecdotal, of course.