[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.

[PunchyHamster]

honestly I used those types of extensions so little I didn't even consider notifications being transactional and firing only when transaction completes