SQLite WAL Mode

If you are using SQLite in a write heavy mode you might want to use the newer Write-Ahead Logging (WAL) journaling mode. This mode is database wide and you can run the following command to enable it for a specific database file.

sqlite3 github.db 'PRAGMA journal_mode=WAL;'

References

Enabling Wal Mode
Write-Ahead Logging

Build your next site in pure HTML and CSS

Want to build your next site in pure HTML and CSS? Join the free Five-Day Neat Starter Email Course and build a lean, production-ready page before Friday.

Email Me the Crash Course

Terms - Privacy