Jonathan Penn links to this great article about how SQLite works:An important feature of transactional databases like SQLite is “atomic commit”. Atomic commit means that either all database changes within a single transaction occur or none of them occur. With atomic commit, it is as if many different writes to different sections of the database … Continue reading Atomic Commit in SQLite