{"application_id":{"options":[{"name":"app_id","description":"A 32-bit integer."}],"abstract":"An integer value identifying the SQLite database as being the file format for a particular application","note":"A value of 0 indicates a generic SQLite database file"},"auto_vacuum":{"options":[{"name":"none","description":"Auto-vacuum is disabled. Unused database pages are added to a freelist and reused later."},{"name":"full","description":"Freelist pages are moved to the end of the database file and truncated. This can result in increased fragmentation."},{"name":"incremental","description":"Auto-vacuum information is stored, but not used until the incremental_vacuum pragma is invoked."}],"abstract":"Set the auto-vacuum status of the database.","note":null},"automatic_index":{"options":[{"name":"off","description":"Automatic indexing is disabled."},{"name":"on","description":"Automatic indexing is enabled."}],"abstract":"Enable or disable automatic indices. When enabled, an index can be created for the duration a single SQL statement in an attempt to increase performance.","note":null},"cache_size":{"options":[{"name":"pages","description":"Number of disk pages"}],"abstract":"The suggested maximum number of database disk pages for SQLite to hold in memory.","note":"This value is reset when the database is closed."},"checkpoint_fullfsync":{"options":[{"name":"off","description":"Use standard fsync behaviour."},{"name":"on","description":"Use F_FULLFSYNC during checkpoint operations."}],"abstract":"Enable or disable F_FULLFSYNC during checkpoint operations. This only takes effect on macOS.","note":null},"encoding":{"options":[{"name":"UTF-8","description":"UTF-8 encoding."},{"name":"UTF-16","description":"UTF-16 using native byte ordering."},{"name":"UTF-16le","description":"UTF-16 little-endian."},{"name":"UTF-8be","description":"UTF-16 big-endian."}],"abstract":"Set the text encoding used by the database.","note":"This option can not be changed on an existing database."},"foreign_keys":{"options":[{"name":"off","description":"Do not enforce foreign key constraints."},{"name":"on","description":"Enforce foreign key constraints."}],"abstract":"Whether to enforce foreign key constraints.","note":null},"freelist_count":{"options":[],"abstract":"The number of unused pages in the database file.","note":null},"fullfsync":{"options":[{"name":"off","description":"Use standard fsync behaviour."},{"name":"on","description":"Use F_FULLFSYNC on supported systems."}],"abstract":"Enable or disable use of F_FULLFSYNC on supported systems.","note":"Only macOS supports F_FULLFSYNC."},"journal_mode":{"options":[{"name":"delete","description":"The rollback journal is deleted after each transaction."},{"name":"truncate","description":"The rollback journal is truncated to zero bytes after each transaction."},{"name":"persist","description":"The header of the rollback journal is overwritten with zeros, but not deleted."},{"name":"memory","description":"The rollback journal is stored in volatile memory. This setting can compromise database integrity in the case of a crash or power loss."},{"name":"wal","description":"Write-ahead logging is used instead of a journal file. This setting persists between database sessions and is only supported by SQLite 3.7.0 or higher."},{"name":"off","description":"The rollback journal is disabled. Database commits are not atomic. This setting can compromise database integrity in the case of a crash or power loss."}],"abstract":"Set the journal mode for the database.","note":"The 'memory' and 'off' settings are not safe in the event of power loss or application crash. If this occurs, the database will likely be corrupted."},"journal_size_limit":{"options":[{"name":"bytes","description":"Size in bytes."}],"abstract":"The size limit for persistent journal files left on the filesystem.","note":"Set this value to -1 for no size limit."},"locking_mode":{"options":[{"name":"normal","description":"Database file is unlocked after each read/write operation."},{"name":"exclusive","description":"Once obtained, database locks are held until explicitly unlocked or the file is closed."}],"abstract":"Set the locking mode for the database.","note":null},"max_page_count":{"options":[{"name":"pages","description":"Maximum number of pages."}],"abstract":"The maximum number of pages that can be used in the database file.","note":"This option can not be set below the current number of pages. See the page_count pragma for this value."},"page_count":{"options":[],"abstract":"The number of database pages in the database file.","note":null},"page_size":{"options":[{"name":"bytes","description":"Page size in bytes."}],"abstract":"The size of a database page in bytes.","note":"Page size must be a power of two between 512 and 65536. Unless the database is empty, this value will not take effect until a VACUUM command is run."},"recursive_triggers":{"options":[{"name":"off","description":"Disable recursive triggers."},{"name":"on","description":"Enable recursive triggers."}],"abstract":"Enable or disable recursive triggers.","note":null},"reverse_unordered_selects":{"options":[{"name":"off","description":"Do not reverse unordered select results."},{"name":"on","description":"Reverse the order of select statements."}],"abstract":"Whether to reverse the order of results from queries without an explicit ORDER BY clause","note":null},"secure_delete":{"options":[{"name":"off","description":"Do not overwrite deleted content."},{"name":"on","description":"Overwrite deleted content with zeros."},{"name":"fast","description":"Overwrite deleted content with zeros if doing so does not require more IO."}],"abstract":"Enable or disable overwriting of deleted content.","note":null},"synchronous":{"options":[{"name":"off","description":"Do not sync data to disk."},{"name":"normal","description":"Sync data to disk after important operations."},{"name":"full","description":"Sync all data to disk."},{"name":"extra","description":"Like 'full', but providing extra durability if commits are followed closely by a power loss. This is the same as 'full' in WAL mode."}],"abstract":"Set the when to sync data to disk.","note":"The 'full' and 'extra' settings are safer, but can be slower."},"temp_store":{"options":[{"name":"default","description":"Use the compile-time option to decide the location of temporary stores."},{"name":"file","description":"Store temporary tables and indices on disk."},{"name":"memory","description":"Store temporary tables and indices in memory."}],"abstract":"Set the location for storing temporary tables and indices.","note":null},"user_version":{"options":[{"name":"integer","description":"A 32-bit integer."}],"abstract":"A 32-bit integer field for any use.","note":null},"wal_autocheckpoint":{"options":[{"name":"pages","description":"Number of disk pages between auto-checkpoints."}],"abstract":"The maximum number of database disk pages written before a write-ahead log auto-checkpoint.","note":"To disable auto-checkpoints, set this value to zero."}}
