• marcos@lemmy.world
    link
    fedilink
    arrow-up
    17
    ·
    13 hours ago

    SQLite doesn’t do highly concurrent tasks. Your life will be much, much better if you don’t even try.

    It also doesn’t do Windows shared files, because any access into Windows shared files is highly concurrent on the speeds Windows is able to manage its shares.

    • okwhateverdude@lemmy.world
      link
      fedilink
      English
      arrow-up
      1
      ·
      23 minutes ago

      SQLite doesn’t do highly concurrent tasks. Your life will be much, much better if you don’t even try.

      One small counter point, with WAL, it is much more feasible to manage more concurrency.

      It also doesn’t do Windows shared files, because any access into Windows shared files is highly concurrent on the speeds Windows is able to manage its shares.

      I didn’t know this! But then again, I don’t think I’ve ever used sqlite on windows before.