diff options
| author | Joe Ardent <nebkor@users.noreply.github.com> | 2024-02-04 10:42:48 -0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-02-04 18:42:48 +0000 |
| commit | b7bb583d8d6d2a299886449c12929d2dece5e67b (patch) | |
| tree | 4d98022b7792a18f1f3a217092b3f2533c9d6284 /atuin-client/src | |
| parent | fix(bash/preexec): support termcap names for tput (#1670) (diff) | |
| download | atuin-b7bb583d8d6d2a299886449c12929d2dece5e67b.zip | |
fix: set durability for sqlite to recommended settings (#1667)
Also do an optimize on connection close. Fixes lag on history insertion.
Diffstat (limited to '')
| -rw-r--r-- | atuin-client/src/database.rs | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/atuin-client/src/database.rs b/atuin-client/src/database.rs index 19fccb0c..e67fe06d 100644 --- a/atuin-client/src/database.rs +++ b/atuin-client/src/database.rs @@ -14,7 +14,10 @@ use rand::{distributions::Alphanumeric, Rng}; use regex::Regex; use sql_builder::{esc, quote, SqlBuilder, SqlName}; use sqlx::{ - sqlite::{SqliteConnectOptions, SqliteJournalMode, SqlitePool, SqlitePoolOptions, SqliteRow}, + sqlite::{ + SqliteConnectOptions, SqliteJournalMode, SqlitePool, SqlitePoolOptions, SqliteRow, + SqliteSynchronous, + }, Result, Row, }; use time::OffsetDateTime; @@ -137,6 +140,8 @@ impl Sqlite { let opts = SqliteConnectOptions::from_str(path.as_os_str().to_str().unwrap())? .journal_mode(SqliteJournalMode::Wal) + .optimize_on_close(true, None) + .synchronous(SqliteSynchronous::Normal) .create_if_missing(true); let pool = SqlitePoolOptions::new() |