Comment by blacklion

This extension piggyback SQLite native transactions. For example, queueing data will be rolled back if transaction is rolled back due to some constrains violations.

It is possible to achieve with external IPC, but require a lot of very careful programming.