Skip to content

Instantly share code, notes, and snippets.

@michaelnisi
Created February 23, 2015 18:03
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save michaelnisi/b00e5ad25d39f08d2888 to your computer and use it in GitHub Desktop.
Save michaelnisi/b00e5ad25d39f08d2888 to your computer and use it in GitHub Desktop.
iOS 8.1 SQLite Pragmas
[auto_vacuum: 0]
[automatic_index: 1]
[cache_size: 250]
[checkpoint_fullfsync: 1]
[name: NOCASE, seq: 0]
[name: RTRIM, seq: 1]
[name: BINARY, seq: 2]
[compile_option: CURDIR]
[compile_option: ENABLE_FTS3]
[compile_option: ENABLE_FTS3_PARENTHESIS]
[compile_option: ENABLE_LOCKING_STYLE=1]
[compile_option: ENABLE_RTREE]
[compile_option: OMIT_AUTORESET]
[compile_option: OMIT_BUILTIN_TEST]
[compile_option: OMIT_LOAD_EXTENSION]
[compile_option: TEMP_STORE=1]
[compile_option: THREADSAFE=2]
[name: main, file: , seq: 0]
[encoding: UTF-8]
[foreign_keys: 0]
[freelist_count: 0]
[fullfsync: 0]
[ignore_check_constraints: 0]
[integrity_check: ok]
[journal_mode: memory]
[journal_size_limit: 32768]
[legacy_file_format: 0]
[locking_mode: normal]
[max_page_count: 1073741823]
[page_count: 1]
[page_size: 4096]
[integrity_check: ok]
[read_uncommitted: 0]
[recursive_triggers: 0]
[reverse_unordered_selects: 0]
[schema_version: 0]
[secure_delete: 0]
[synchronous: 2]
[temp_store: 0]
[user_version: 0]
[wal_autocheckpoint: 1000]
[log: -1, checkpointed: -1, busy: 0]
[writable_schema: 0]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment