How to make a "hot" backup of SQLite3?

Question

SQL

Hello,

I have never worked with small single-file databases like SQLite before, however, in a small home project I decided to use it because of its simplicity, almost zero administration and the out-of-the-box python driver.

What is: requests come to the web application every couple of seconds. The data from the request is parsed and, in a transaction, stored in the database by several writing requests.

I would like to: run a "hot" backup once a day. "Hot" means that it is unacceptable to lose requests to the web application. You can save them in a queue, but sooner or later, the data that came in requests must be added to the database in an orderly manner.

The current idea seems terribly clumsy to me: to add data to the database exclusively through a separate thread with a queue. At the same time, the thread has the ability to switch to the standby mode, for example, while the “backup is in progress” file flag is present, and copy the file from the database to the backup server.

How would you solve this problem?

Answer 1

I think the second example from this link will help you: http://www.sqlite.org/backup.html

Answer 2

Firebird is quite a single-file database. Python driver sudo apt-get install python-kinterbasdb. No problem with hot backup.