SQLite (with WAL) doesn't do `fsync` on each commit under default settings (avi.im) | HN Screenshots

YHacker Newsscreenshots

Screenshot of avi.im: SQLite (with WAL) doesn't do `fsync` on each commit under default settings

First screen, captured 1 year ago.

Looks similar

Screenshot of avi.im: PSA: SQLite WAL checksums fail silently and may lose data

PSA: SQLite WAL checksums fail silently and may lose data (avi.im)

266 points by avinassh 1 year ago | 121 comments

Screenshot of shayon.dev: Selective async commits in PostgreSQL – balancing durability and performance

Selective async commits in PostgreSQL – balancing durability and performance (shayon.dev)

89 points by shayonj 1 year ago | 29 comments

Screenshot of shayon.dev: Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL

Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL (shayon.dev)

60 points by shayonj 2 years ago | 43 comments

Screenshot of avi.im: SQLite does not do checksums

SQLite does not do checksums (avi.im)

96 points by todsacerdoti 1 year ago | 68 comments

Screenshot of emschwartz.me: Subtleties of SQLite Indexes

Subtleties of SQLite Indexes (emschwartz.me)

117 points by emschwartz 1 year ago | 51 comments

Screenshot of fzakaria.com: Three ways to smuggle SQLite into Nix

Three ways to smuggle SQLite into Nix (fzakaria.com)

15 points by domenkozar 2 months ago | 4 comments