4 ms·
I don't think so. I'm pretty sure sqlite relies on fsync barriers, something block devices don't have.
by 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 agoBlock devices have barriers and sync; fsync is built on those primitives.
- Vecr 2y agoI'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 agoObviously 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.