Export Database Format

Beginning with Privacy Browser 2.13, there is an option to export and import settings and bookmarks. These settings are stored in an SQLite database. Both flavors of Privacy Browser use the same database format, so files can be exported and imported between them. This page documents the database schema.

Changelog

SchemaVersionChanges
12.13Initial release.
22.14Add download with external app preference.
32.15Rename the default_font_size preference to font_size.

The database contains three tables: bookmarks, domains, and preferences.

Bookmarks

FieldTypeSchemaVersion
_idINTEGER PRIMARY KEY12.13
bookmarknameTEXT12.13
bookmarkurlTEXT12.13
parentfolderTEXT12.13
displayorderINTEGER12.13
isfolderBOOLEAN12.13
favoriteiconBLOB12.13

Domains

FieldTypeSchemaVersion
_idINTEGER PRIMARY KEY12.13
domainnameTEXT12.13
enablejavascriptBOOLEAN12.13
enablefirstpartycookiesBOOLEAN12.13
enablethirdpartycookiesBOOLEAN12.13
enabledomstorageBOOLEAN12.13
enableformdataBOOLEAN12.13
enableeasylistBOOLEAN12.13
enableeasyprivacyBOOLEAN12.13
enablefanboysannoyancelistBOOLEAN12.13
enableffanboyssocialblockinglistBOOLEAN12.13
enableultraprivacyBOOLEAN12.13
blockallthirdpartyrequestsBOOLEAN12.13
useragentTEXT12.13
fontsizeINTEGER12.13
swipetorefreshINTEGER12.13
nightmodeINTEGER12.13
displayimagesINTEGER12.13
pinnedsslcertificateBOOLEAN12.13
sslissuedtocommonnameTEXT12.13
sslissuedtoorganizationTEXT12.13
sslissuedtoorganizationalunitTEXT12.13
sslissuedbycommonnameTEXT12.13
sslissuedbyorganizationTEXT12.13
sslissuedbyorganizationalunitTEXT12.13
sslstartdateINTEGER12.13
sslenddateINTEGER12.13

Preferences

FieldTypeSchemaVersion
_idINTEGER PRIMARY KEY12.13
javascriptBOOLEAN12.13
first_party_cookiesBOOLEAN12.13
third_party_cookiesBOOLEAN12.13
dom_storageBOOLEAN12.13
save_form_dataBOOLEAN12.13
user_agentTEXT12.13
custom_user_agentTEXT12.13
incognito_modeBOOLEAN12.13
do_not_trackBOOLEAN12.13
allow_screenshotsBOOLEAN12.13
easylistBOOLEAN12.13
easyprivacyBOOLEAN12.13
fanboys_annoyance_listBOOLEAN12.13
fanboys_social_blocking_listBOOLEAN12.13
ultraprivacyBOOLEAN12.13
block_all_third_party_requestsBOOLEAN12.13
proxy_through_orbotBOOLEAN12.13
tor_homepageTEXT12.13
tor_searchTEXT12.13
tor_search_custom_urlTEXT12.13
searchTEXT12.13
search_custom_urlTEXT12.13
full_screen_browsing_modeBOOLEAN12.13
hide_system_barsBOOLEAN12.13
translucent_navigation_barBOOLEAN12.13
clear_everythingBOOLEAN12.13
clear_cookiesBOOLEAN12.13
clear_dom_storageBOOLEAN12.13
clear_form_dataBOOLEAN12.13
clear_cacheBOOLEAN12.13
homepageTEXT12.13
font_sizeTEXT32.15
swipe_to_refreshBOOLEAN12.13
download_with_external_appBOOLEAN22.14
display_additional_app_bar_iconsBOOLEAN12.13
dark_themeBOOLEAN12.13
night_modeBOOLEAN12.13
display_webpage_imagesBOOLEAN12.13