Skip to content

feat(jdbc): expose wal_autocheckpoint and wal_checkpoint pragmas in SQLiteConfig#1398

Merged
gotson merged 4 commits into
xerial:masterfrom
kju2:master
Apr 9, 2026
Merged

feat(jdbc): expose wal_autocheckpoint and wal_checkpoint pragmas in SQLiteConfig#1398
gotson merged 4 commits into
xerial:masterfrom
kju2:master

Conversation

@kju2

@kju2 kju2 commented Apr 4, 2026

Copy link
Copy Markdown
Contributor

Closes #1397 .

Adds support for two missing WAL-related pragmas in SQLiteConfig:

  • wal_autocheckpoint — configures the automatic checkpoint threshold (number of WAL pages)
  • wal_checkpoint — triggers a manual checkpoint with a configurable mode (PASSIVE, FULL, RESTART, TRUNCATE, NOOP)

@gotson

gotson commented Apr 8, 2026

Copy link
Copy Markdown
Collaborator

Hi,

i am fine with the wal_autocheckpoint config, however i don't quite get the wal_checkpoint one. The pragma is not a config, but triggers an action. In that case, what is the point of adding it in SQLiteConfig ?

@kju2

kju2 commented Apr 8, 2026

Copy link
Copy Markdown
Contributor Author

You're right - wal_checkpoint doesn't belong in SQLiteConfig.

I removed it and updated the PR.

@gotson

gotson commented Apr 9, 2026

Copy link
Copy Markdown
Collaborator

Thanks, could you mvn spotless:apply to fix the code formatting ?

@kju2

kju2 commented Apr 9, 2026

Copy link
Copy Markdown
Contributor Author

Done, applied mvn spotless:apply and pushed the formatting fix.

@gotson gotson merged commit dd2adcc into xerial:master Apr 9, 2026
31 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Add missing WAL pragma support (wal_autocheckpoint, wal_checkpoint)

2 participants