secureDelete

Queries or sets the secure_delete flag, which controls how content is deleted from the database.

When set to true, SQLite overwrites deleted content with zeros to ensure it cannot be recovered from the raw disk file. This is more secure but can be slower.

When set to false (the default), deleted content is simply marked as free, and the space is eventually reused. This is faster but leaves remnants of old data in the database file until it is overwritten.

This pragma can be changed at any time and affects all subsequent delete operations for the connection.

See also