Sam Hames

Savepoints (SQLite)

Savepoints can be used in many places transactions can, but have the benefit of nesting. This is particularly handy when you are building an application, where you might want to have (for example) a utility function that is an atomic transaction when used on it's own, but is not a full transaction when used as part of some bigger process - savepoints handle the nesting of transactions.