summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-01-04 16:31:37 -0500
committerJune McEnroe <june@causal.agency>2020-01-04 16:31:37 -0500
commitb38db63193ffa8ca4b686ff7dd82257e436b23d8 (patch)
treea4eb91c0ef47212360f0506906bec6ccc3b67503
parentAdd -N option to litterbox (diff)
downloadlitterbox-b38db63193ffa8ca4b686ff7dd82257e436b23d8.tar.gz
litterbox-b38db63193ffa8ca4b686ff7dd82257e436b23d8.zip
Enable SQLite WAL
-rw-r--r--database.h1
1 files changed, 1 insertions, 0 deletions
diff --git a/database.h b/database.h
index 26ae57e..a1370b5 100644
--- a/database.h
+++ b/database.h
@@ -87,6 +87,7 @@ static inline void dbOpen(char *path, int flags) {
 	if (error) errx(EX_NOINPUT, "%s: %s", path, sqlite3_errmsg(db));
 
 	sqlite3_busy_timeout(db, 1000);
+	dbExec(SQL(PRAGMA journal_mode = WAL;));
 	dbExec(SQL(PRAGMA foreign_keys = true;));
 }
 
ighlight'> 2024-09-24Allow not having descriptionsJune McEnroe I'm sorry, I can't keep writing descriptions. It makes posting photos take too long, I often don't know the words for what I'm looking at, and a good description is an entirely different work of art than the photo I took, and I'm just a photographer. It's visual art. 2024-09-23Automatically select the last used lens for a bodyJune McEnroe 2024-09-19Add photos from September 5June McEnroe Had to prefix the folder number onto these file names manually because they must have come out of a different scanner or something. 2024-09-15Add some more film stocks to the listJune McEnroe 2024-09-13Add photos from September 2June McEnroe 2024-09-13Add Fomapan 200 to films listJune McEnroe 2024-09-10Add August 29 picnic photosJune McEnroe 2024-09-08Apply some bold to trips renderingJune McEnroe This seems easier to visually scan. The only other thing I'd like is a nicer date rendering but JavaScript is useless for that. 2024-09-08Render trips hopefully more efficientlyJune McEnroe 2024-09-08Allow removing bodies and lensesJune McEnroe 2024-09-08Limit body width so it looks less silly on desktopJune McEnroe 2024-09-07Handle no film being loadedJune McEnroe 2024-09-07Fancy up the text a littleJune McEnroe