Quote:
Originally Posted by shalym
I also "do this stuff for a living", and in the real world, most databases are NOT shut down every night so that a backup can be done. Most *modern* backup programs can and do handle database backups without completely shutting down the program and without corruption. I maintain several MS SQL and MySQL databases that are backed up every night, with test restores done at least monthly, and I can tell you that I've never had a backup corrupted because a database was open while it was being backed up.
|
Calibre uses SQLite. That is a relational database stored in a simple file. It doesn't use a server. Therefore, when backing up, normal file backup procedures (and pitfalls) apply. Maybe one day Kovid could port the database over to MySQL or something else (Maria, Postgre), and so integrate a portable, auto-starting server. Calibre would then be running a "proper" database, but the distribution would become about twice as big and the total program would become even heavier. While I love Calibre for what it does, I can't say it's a light program to run.