Question

What is SQLite Transactions?

Answer 1

Transaction specifies a unit of work that is performed against a database. The transaction?s properties are determined by ACID:

• Atomicity: Atomicity is a property which specifies that all work units are successfully completed.
• Consistency: It is used to ensure that the database changes states upon a successfully committed transaction.
• Isolation: It facilitates you to operate transaction independently of and transparent to each other.
• Durability: It ensures that the result or effect of a committed transaction persists in case of a system failure.