✳flâneur — a map of the web's best reading

How To Corrupt An SQLite Database File

sqlite.org · 5,590 words · saved by 1 readers

An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. The recovery process is fully automatic and does not require any action on the part of the user or the application.

How To Corrupt An SQLite Database File Small. Fast. Reliable. Choose any three. Home Menu About Documentation Download License Support Purchase Search About Documentation Download Support Purchase Search Documentation Search Changelog How To Corrupt An SQLite Database File Table Of Contents 1. File overwrite by a rogue thread or process 1.1. Continuing to use a file descriptor after it has been closed 1.2. Backup or restore while a transaction is active 1.3. Deleting a hot journal 1.4. Mispairing database files and hot journals 2. File locking problems 2.1. Filesystems with broken or missing l

Explore this link on the map →

saved by

related reading