From 699a8c625cdf1f9a57bf4be326dc0c797c2d4d63 Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Tue, 14 Jan 2020 18:25:52 -0500 Subject: Add -b flag for live backup --- database.h | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'database.h') diff --git a/database.h b/database.h index 83be73c..d9b2718 100644 --- a/database.h +++ b/database.h @@ -335,3 +335,13 @@ static inline void dbMigrate(void) { dbExec(MigrationSQL[version]); } } + +static inline void dbBackup(const char *path) { + if (sqlite3_libversion_number() < 3027000) { + errx(EX_CONFIG, "SQLite version 3.27.0 or newer required"); + } + sqlite3_stmt *stmt = dbPrepare(SQL(VACUUM INTO :path;)); + dbBindText(stmt, ":path", path); + dbRun(stmt); + sqlite3_finalize(stmt); +} -- cgit 1.4.1 value='master' selected='selected'>master dontfiles
summary refs log tree commit diff
path: root/www/text.causal.agency (unfollow)
Commit message (Collapse)Author
2022-03-31Publish "Compassion"June McEnroe
2022-03-24Skip matches with ident chars on either sideJune McEnroe
This fixes, for example, where the link gets placed on static regex_t regex(const char *pattern, int flags) in title.c.
2022-03-24Add The Invisible Life of Addie LaRueJune McEnroe
So good, but so long. Reminded me of The Ten Thousand Doors of January at the beginning, and more of that N. K. Jemisin series about gods later. I like this interacting with gods and becoming something like one sort of thing. God, it took me a whole month (more?) to read and this is only my third book of the year :( I need some more novellas to read, but the other books I have from the library currently are also thick.
2022-03-22Source ~/.profile.local if it existsJune McEnroe
2022-03-18Publish "Addendum 2021"June McEnroe
2022-03-16Remove wcwidth portJune McEnroe
DYLD_FORCE_FLAT_NAMESPACE no longer exists in macOS 12 so this approach doesn't work anymore. Moved to <https://git.causal.agency/jorts/tree/wcwidth> and compiled into <https://git.causal.agency/jorts/tree/ncurses>.
2022-03-16Remove -j4 from ./PlanJune McEnroe
Plan learned to set this automatically!
2022-03-15Rewrite Linux install.sh for DebianJune McEnroe
2022-03-15Remove dashJune McEnroe