Groups > comp.lang.python > #197773

“How to back up SQLite databases the right way (not by copying them!)”

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!nntp.eternal-september.org!.POSTED!not-for-mail
From	Lawrence D’Oliveiro <ldo@nz.invalid>
Newsgroups	comp.lang.python
Subject	“How to back up SQLite databases the right way (not by copying them!)”
Date	Sun, 10 May 2026 22:36:59 -0000 (UTC)
Organization	A noiseless patient Spider
Lines	17
Message-ID	<10tr1ab$n8tt$1@dont-email.me> (permalink)
MIME-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Date	Sun, 10 May 2026 22:37:00 +0000 (UTC)
Injection-Info	dont-email.me; logging-data="762813"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18UaPghd4U+tOhRrgXJIYMg"; posting-host="d0440d15af103125b89cd250f7ef66f0"
User-Agent	Pan/0.165 (Kostiantynivka)
Cancel-Lock	sha1:fZoE8qtgFj6BtwiMJnbx03DVg6w= sha256:esQ9kY4oSBPjmjcPi8IGP5XlRijDPDOtLzEgI0TAyKQ= sha1:7pYO92wWWDDmJzzxQ6LyPohp7Xs=
Xref	csiph.com comp.lang.python:197773

Show key headers only | View raw

Mr Serdar Yegulalp occasionlly comes up with useful titbits of
information, but I’m not sure I’d count this among them
<https://www.infoworld.com/video/4164431/how-to-back-up-sqlite-databases-the-right-way-not-by-copying-them.html>.

Does anybody else use SQLite’s backup API? I’ve never bothered,
because SQLite is a single-user DBMS. To backup a database, I just
shut down the program accessing it, and do a regular file copy on the
database file. Simple.

I think the backup API might be useful from within the app accessing
the database itself, to provide its own backup function while it is
still running. Again, not something I’ve felt much need for; in my
experience, long-running service-style apps tend to use multiuser
DBMSes, which can handle multiple simultaneous connections without
things getting confused. And backing them up is easily done by making
yet another connection from a database dump utility, usually provided
as part of the DBMS package.

Back to comp.lang.python | Previous | Next — Next in thread | Find similar

Thread

“How to back up SQLite databases the right way (not by copying them!)” Lawrence D’Oliveiro <ldo@nz.invalid> - 2026-05-10 22:36 +0000
  Re: “How to back up SQLite databases the right way (not by copying them!)” Jon Ribbens <jon+usenet@unequivocal.eu> - 2026-05-10 23:09 +0000

csiph-web