I am aware of the possibility to create my own trigger(ed) solution, but I didn't want to reinvent the wheel :-)
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Berkeley DB's SQL API is completely SQLite compatible and offers HA/replication for high availability. The combination of SQLite's easy-of-use and Berkeley DB's scalability and reliability are a great combination.
Disclaimer: I'm the Product Manager for Berkeley DB, so I'm a little biased. However, one of the main benefits of adding the SQLite API to Berkeley DB is that SQLite applications can now have HA/replication for mission-critical, highly available applications.
There is the litereplica
It's exactly an addition to the SQLite3 code. The interface is unchanged so we don't need to change the application code.
It's released under the AGPLv3 and there is also a commercial license.