Yes, sqlite is NOT a good database. Bareos writes millions of file records to the file. Sqlite will run out of pointers and performance will greatly suffer very quickly.
Sqlite is a FLAT file database, not an indexed one. It simulates a database so a developer does not have to figure out SQL/db setup stuff while developing. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stanislav German-Evtushenko Sent: Friday, November 07, 2014 9:09 AM To: [email protected] Subject: [bareos-users] sqlite3 in production Hello, I prefer using sqlite3 in replacement of any normal database when I have choice because it: - removes another point of failure (database server) - saves us from configuring/maintaining/monitoring database - allows us to backup/copy/investigate/fix database easily However Bareos documentation states "sqlite3 is not for production". Are there any special reasons for this? Any issues? Any tests that show bad results? Best regards, Stanislav -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout. This message (including any attachments) may contain confidential, proprietary, privileged and/or private information. The information is intended to be for the use of the individual or entity designated above. If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments. Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
