On Wed, May 1, 2019, at 4:59 AM, Kern Sibbald wrote: > Hello, > > Just so everyone knows how I feel about SQLite -- it is a great program, > written by a very good programmer. It is probably closer to Postgres > than to MySQL in its syntax.
An aside... There is a reason for that similarity. When SQLite was being written, PostgreSQL was the reference for what to do. D. Richard Hipp gave the keynote talk at PGCon 2014. I was present. The slides are at: https://www.pgcon.org/2014/schedule/events/736.en.html > However, it is really not an appropriate > database for many reasons for Bacula, and maintaining the update tables > scripts is very time consuming. I will continue to keep the source code > as long as Sven and others contribute what is necessary to keep it > working. In that talk, you will find these quotes: “SQLite is not a replacement for PostgreSQL. SQLite is a replacement for fopen().” "Use PostgreSQL as an enterprise data depot, and use SQLite for application files." The Catalog is definitely not an application file. Please move from SQLite to PostgreSQL. You will be better off. _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
