Sqlite Database Pragma Usage
The data below has been added as a tool for future pragma analysis work and is expected to be useful so long as our pragma usage remains stable or this doc is kept up-to-date. This should help us understand our current pragma usage and where we may be able to make improvements.
|foreign_keys||ON||autofill, places, tabs, webext-storage|
|journal_mode||WAL||autofill, places, tabs, webext-storage|
|temp_store||2||autofill, logins, places, tabs, webext_storage||Setting |
|wal_checkpoint||PASSIVE||places||Used in the |
- The user_version pragma is excluded because the value varies and sqlite does not do anything with the value.
- The push component does not implement any of the commonly used pragmas noted above.
- The sqlcipher pragmas that we set have been excluded from this list as we are trying to remove sqlcipher and do not want to encourage future use.