3 ms·

Sounds like we should all just be doing sqlite3 /dev/sda2 Filesystems and databases solve similar problems, so putting one on top of the other is a bit redunda

• Vecr 2y ago
  I don't think so. I'm pretty sure sqlite relies on fsync barriers, something block devices don't have.
  • wmf 2y ago
    Block devices have barriers and sync; fsync is built on those primitives.
    • Vecr 2y ago
      I'm pretty sure it wouldn't work. Sqlite commits by deleting a file in normal operation, and with WAL you need an ordering that I'm not sure Linux on standard hardware can provide without running both the database and the WAL on 1 filesystem.
      • wmf 2y ago
        Obviously you would need some changes to SQLite to make it work, but I think it would work. Putting the DB and WAL on the same block device doesn't sound like rocket science.
• sgbeal 2y ago
  > Sounds like we should all just be doing sqlite3 /dev/sda2 A recent forum post on that topic: <https://sqlite.org/forum/forumpost/66b4d47514b442af https://sqlite.org/forum/forumpost/66b4d47514b442af>