Okay, so hardly the first person to mention sharing the SQLite db relpicated across multiple PMS instances. Lots of reason to want this fail-over,m geographic distribution, home and holiday-home. etc…
However the nature of SQLite (as a memory resdent, single app access db) has always been the limiting factor. Has the team looked at litesync as an abstraction layer? http://litesync.io/sqlite-synchronization.html zero code change and the existing ‘remote access’ could easily tunnel the transaction replication between nodes, allowing for a minimal setup.
