appreg.db

The appreg.db file at /var/local/appreg.db is a sqlite3 database which stores numerous file-application relations and configuration values.

It contains the following tables:

  • associations
  • extenstions
  • handlerIds
  • interfaces
  • mimetypes
  • properties

(yes, extenstions is how it is spelt in the database)

associations

The associations table is the most important table in the appreg.db file, linking specific handlers to specific types of content or interfaces.
It is most notably used by scanner to determine what extractor to use when indexing a file.
It is also used to determine what application to launch when opening a booklet.

handlerIdinterfacecontentIddefaultAssoc
com.lab126.adRotationManagerkaf-servicenonefalse
com.lab126.purchaseManagerkaf-servicenonefalse
com.lab126.todo.handler.PurchaseConfirmationtodoTP:legacy.SET.PRCHfalse
com.amazon.kindle.booklet.adapplicationnonefalse
com.lab126.adManagerkaf-servicenonefalse
com.lab126.todo.handler.AdResettodoTP:legacy.SET.ADRSfalse
com.lab126.todo.handler.AdPackagetodoTP:legacy.DOWNLOAD.ADPKfalse
com.lab126.todo.handler.AdPackagetodoTP:legacy.REMOVE.ADPKfalse
com.lab126.sdk.addressbookkaf-servicenonefalse
com.lab126.booklet.oobe.tutorialapplicationnonefalse
com.lab126.audible.WSMarketplaceServicekaf-servicenonefalse
handlerIdinterfacecontentIddefaultAssoc
com.lab126.audible.extractorextractorGL:*.aaxtrue
com.lab126.generic.extractorextractorGL:*.txttrue
com.lab126.mobi.extractorextractorGL:*.mobitrue
com.lab126.mobi.extractorextractorGL:*.pobitrue
com.lab126.mobi.extractorextractorGL:*.prctrue
com.lab126.mobi.extractorextractorGL:*.azwtrue
com.lab126.mobi8.extractorextractorGL:*.azw3true
com.lab126.pdf.extractorextractorGL:*.pdftrue
com.lab126.topaz.extractorextractorGL:*.tpztrue
com.lab126.topaz.extractorextractorGL:*.azw1true
com.lab126.yj.extractorextractorGL:*.yjtrue
com.lab126.yj.extractorextractorGL:*.azw8true
com.lab126.yj.extractorextractorGL:*.kfxtrue
org.kindlemodding.hd_extractorextractorGL:*.DO_NOT_DELETEtrue
com.lab126.generic.extractorextractorGL:*.run_persistencetrue
com.notmarek.shell_integration.extractorextractorGL:*.shtrue
com.lab126.generic.extractorextractorGL:*.run_hotfixtrue
handlerIdinterfacecontentIddefaultAssoc
com.lab126.booklet.readerapplicationMT:application/pdftrue
com.lab126.booklet.testapplicationMT:application/x-amazon-testrunnertrue
com.lab126.booklet.readerapplicationMT:application/x-kfx-ebooktrue
com.lab126.booklet.readerapplicationMT:application/x-mobi8-ebooktrue
com.lab126.booklet.readerapplicationMT:application/x-mobipocket-ebooktrue
com.lab126.booklet.periodicalsapplicationMT:application/x-mobipocket-subscriptiontrue
com.lab126.booklet.periodicalsapplicationMT:application/x-mobipocket-subscription-feedtrue
com.lab126.booklet.periodicalsapplicationMT:application/x-mobipocket-subscription-magazinetrue
com.lab126.booklet.readerapplicationMT:application/x-topaz-ebooktrue

handlerIds

handlerIds is a table with a single column, handlerId:

handlerId
com.lab126.adRotationManager
com.notmarek.shell_integration.launcher
com.notmarek.shell_integration.extractor
com.lab126.kft
com.lab126.oobe

(the above table is not exhaustive)

interfaces

interfaces is another single-column table containing a column called interface.
This table, at the time of writing, contains 8 rows:

interface
kaf-service
todo
application
download
detail
extractor
indexer
amazon-messaging

extenstions

extenstions is a database that associates a particular file extension with a mimetype.
It consists of an ext column and a mimetype column, ie:

extmimetype
aaxMT:audio/vnd.audible.aax
pobiMT:application/x-mobipocket-subscription
pobiMT:application/x-mobipocket-subscription-magazine
pobiMT:application/x-mobipocket-subscription-feed
azwMT:application/x-mobipocket-ebook
mbpMT:application/x-mobipocket-sidecar
azw3MT:application/x-mobi8-ebook
azw6MT:application/x-mobi8-images
kfxMT:application/x-kfx-ebook
hanMT:application/json
azw1MT:application/x-topaz-ebook
tanMT:application/x-topaz-sidecar
pdfMT:application/pdf
txtMT:text/plain
jpgMT:image/jpeg
apnxMT:application/x-apnx-sidecar
phlMT:application/xml+phl
saMT:application/xml+sa
eaMT:application/xml+ea
noneMT:application/x-kindle-oobe
noneMT:application/x-kindle-vocab-builder
noneMT:application/x-kindle-collection
noneMT:application/x-kindle-pvc
noneMT:application/x-kindle-series
runtestMT:application/x-amazon-testrunner
DO_NOT_DELETEMT:text/hd_extractor
htmlMT:text/html
run_persistenceMT:kindlemodding/run_persistence
shMT:text/x-shellscript
run_hotfixMT:kindlemodding/run_hotfix

mimetypes

The purpose of this table is unknown, it holds values similar to extenstions

extmimetype
AAXMT:audio/vnd.audible.aax
pobiMT:application/x-mobipocket-subscription-feed
azwMT:application/x-mobipocket-ebook
mobiMT:application/x-mobipocket-ebook
prcMT:application/x-mobipocket-ebook
mbpMT:application/x-mobipocket-sidecar
azw3MT:application/x-mobi8-ebook
azw6MT:application/x-mobi8-images
kfxMT:application/x-kfx-ebook
azw8MT:application/x-kfx-ebook
yjMT:application/x-kfx-ebook
hanMT:application/json
azw1MT:application/x-topaz-ebook
tpzMT:application/x-topaz-ebook
tanMT:application/x-topaz-sidecar
pdfMT:application/pdf
txtMT:text/plain
jpgMT:image/jpeg
jpegMT:image/jpeg
apnxMT:application/x-apnx-sidecar
phlMT:application/xml+phl
saMT:application/xml+sa
eaMT:application/xml+ea
noneMT:application/x-kindle-series
runtestMT:application/x-amazon-testrunner
DO_NOT_DELETEMT:text/hd_extractor
htmlMT:text/html
htmMT:text/html
run_persistenceMT:kindlemodding/run_persistence
shMT:text/x-shellscript
run_hotfixMT:kindlemodding/run_hotfix

properties

As the name suggests, this table is responsible for associating specific kinds of properties with handlers.

This table also stores dconf values (see below)

Properties for sh_integration

handlerIdnamevalue
com.notmarek.shell_integration.launcherextend-startY
com.notmarek.shell_integration.launcherunloadPolicyunloadOnPause
com.notmarek.shell_integration.launchermaxGoTime60
com.notmarek.shell_integration.launchermaxPauseTime60
com.notmarek.shell_integration.launchermaxUnloadTime60
com.notmarek.shell_integration.launchermaxLoadTime60
com.notmarek.shell_integration.launchercommand/var/local/kmc/bin/sh_integration_launcher
com.notmarek.shell_integration.extractorlib/var/local/kmc/lib/sh_integration_extractor.so
com.notmarek.shell_integration.extractorentryload_extractor

Properties for the mobi8 extractor

handlerIdnamevalue
com.lab126.mobi8.extractorlib/usr/lib/ccat/libmobi8extractorE.so
com.lab126.mobi8.extractorentryload_mobi8_extractor

Properties for the home booklet

handlerIdnamevalue
com.lab126.booklet.homelipcIdcom.lab126.booklet.home
com.lab126.booklet.homejar/opt/amazon/ebook/booklet/home.jar
com.lab126.booklet.homesupportedOrientationU
com.lab126.booklet.homedefault-chrome-styleTSB
com.lab126.booklet.homemaxExecTime22
com.lab126.booklet.homemaxLoadTime40
com.lab126.booklet.homemaxGoTime30
com.lab126.booklet.homedefaultContextcontext=0
com.lab126.booklet.homeextend-startY
com.lab126.booklet.homedetailFactoryPath/opt/amazon/ebook/booklet/home.jar
com.lab126.booklet.homedetailFactoryClasscom.amazon.kindle.home.detail.HomeDetailViewFactory
com.lab126.booklet.homewhisper-touchsupported
com.lab126.booklet.homeasrsupported

Properties for com.lab126.tardis

handlerIdnamevalue
com.lab126.tardislipcIdcom.lab126.tardis
com.lab126.tardisjar/opt/amazon/ebook/booklet/tardis.jar
com.lab126.tardissupportedOrientationU

Properties for the reader booklet

handlerIdnamevalue
com.lab126.booklet.readerasrsupported
com.lab126.booklet.readerdefault-chrome-styleNH
com.lab126.booklet.readerdetailFactoryClasscom.amazon.ebook.booklet.reader.impl.detail.ReaderDetailViewFactory
com.lab126.booklet.readerdetailFactoryPath/opt/amazon/ebook/lib/detail_view.jar
com.lab126.booklet.readerdownloadHandlerClasscom.amazon.ebook.booklet.reader.impl.todo.handler.ContentToDoHandler
com.lab126.booklet.readerdownloadHandlerPath/opt/amazon/ebook/lib/ReaderSDK-impl.jar
com.lab126.booklet.readerextend-startY
com.lab126.booklet.readergrip-suppressionsupported
com.lab126.booklet.readerjar/opt/amazon/ebook/booklet/Reader.jar
com.lab126.booklet.readerlipcIdcom.lab126.booklet.reader
com.lab126.booklet.readermaxGoTime30
com.lab126.booklet.readermaxPauseTime60
com.lab126.booklet.readersearchbar-modetransient
com.lab126.booklet.readersupportedOrientationURL
com.lab126.booklet.readerwhisper-touchsupported

dconf

Configuration values from what is known as dconf is stored in teh appreg.db file under properties with the dcc or dcd handlerId:

handlerIdnamevalue
dccwan.proxy.non_proxy_hosts.http*.amazon.com.au
dccwan.proxy.non_proxy_hosts.https*.amazon.com.au
dcdurl.kindlestore.kcw.metrics/mn/kcw/workflow/log-metrics
dcdurl.storehttps://www.amazon.com/gp/digital/juno/index.html
dcdurl.unifiedsearch.kindlestore.voltron$WEBSITE/kindle-dbs/ekws/?action=search&query=$SEARCH_TERM&locale=$LOCALE&page=$OFFSET&size=$SIZE&styleCode=$STYLE_CODE