Skip to content

Avinash Sajjanshetty personal blog

SQLite (with WAL) doesn't do `fsync` on each commit under default settings

avi.im 4 min read

SQLite doesn’t do fsync unless specified.

Read on avi.im → Discuss on HN (91) Archived copy

Points: 106
HN comments: 91
Submissions: 1
Cited by: 0 commenters

Databases & Data Systems & Performance 2025

On Hacker News

Submitted	Title on HN	Points	Comments
Aug 24, 2025	SQLite (with WAL) doesn't do `fsync` on each commit under default settings by Bogdanp	106	91

More from Avinash Sajjanshetty

All 9 posts →

Inserting a billion rows in SQLite under a minute

2021573 points146 comments Databases & Data details

How bloom filters made SQLite 10x faster

2024504 points121 comments Databases & Data details

Fun facts about SQLite

2024393 points191 comments Databases & Data details

In Search of a Faster SQLite

2024355 points149 comments Databases & Data details

PSA: SQLite WAL checksums fail silently and may lose data

2025279 points128 comments Databases & Data details

Oldest recorded transaction

2025182 points106 comments Databases & Data details

Related posts from the same era

ICE using Palantir tool that feeds on Medicaid data

EFF Deeplinks20261,475 points969 comments details

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

Tracking down the 16-year-old WAL-reset SQLite bug

Tailscale Blog20261,223 points239 commentscited by 3 details

GPT in 500 Lines of SQL

Explain Extended20241,111 points76 commentscited by 3 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

PGSimCity - How PostgreSQL Works

nikolays.github.io2026930 points90 comments details