3 ms·

If this requires turning off pragma synchronous, doesn't that disqualify it for anything but read only tasks? Power loss etc would corrupt the database...

• Hello71 8y ago
  Install a UPS.
  • rollcat 8y ago
    Doesn't protect against a kernel panic, or other kind of crash.
• amiga-workbench 8y ago
  Its not a requirement, but it will run quicker with it off.
• bl4ckm0r3 8y ago
  You could have a master slave architecture where you disable it for the slaves only. It really depends on the use cases.
  • est 8y ago
    wait, sqlite can do master-slave in some way?
    • siscia 8y ago
      No, vanilla SQLite cannot. But think about it as a library, you can build master-slave on top of it. Which is basically what I did with https://redisql.com/ https://redisql.com/ in the pro version exploiting Redis AOF