klipper: enable SQLite Write-Ahead Logging
Reason for the change
Write-Ahead Logging is a logging methodology that adjusts the way updates are committed to the database, ensuring that changes are recorded sequentially in a separate append-only log file, and subsequently altering the database file.
Advantages of WAL
- Concurrency: One of the most significant advantages is the increase in concurrency. In WAL mode, readers do not block writers and vice versa, enhancing the throughput for multi-user environments.
- Performance: Since WAL uses an append-only log for transaction commits, the write operations can be faster under certain workloads as it avoids random access file writes that can occur in traditional rollback journals.
- Reliability: Immediate logging of transactions ensures that upon a crash, committed transactions can be recovered quickly from the WAL file.
Test plan
Pass clipboardtest