*.db Files

From Vita Developer wiki
Revision as of 12:25, 28 September 2015 by PHOTONQ2 (talk | contribs) (Creation of the page.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

.db files are database files.

They're usually opened with SqliteBrowser

Usefull .db

app.db

Contains paths of files used by applications.
  • Path: ur0:shell/db/app.db
  • Size: 260KB

Tables

tbl_appinfo
tittleId key val
<Value associated to key>
  • key purpose:
key Purpose
566916785 Type of application (gd,gda,gdb)
1299181514 Complete tittleId (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234)
2414097773 Application's URI (i.e.:mailto:)
3168212510 Application's version


Files.db

  • Path: pd0:app/NPXS10007/sce_pfs/files.db
  • Size: 30KB
  • Use ListDirVita to read it.

pspmtp.db

  • Path: ux0:mtp/pspmtp.db
  • Size: 12KB

Tables

tbl_mtpObject
UID
ParentUID xxxxxxxxxx<Numeric>
ObjectFormat xxxxx<Numeric>
ProtectionStatus xxxxx<Numeric>
ObjectSize
DateCreated
DateModified
FullPathName
Name ROOT
NonConsumable
PUOID <Non-Readable ASCII>
Artist
Genre
Album
AlbumArtist
UseCount
SampleRate
AudioWaveCodec
AudioBitRate
OriginalReleaseDate
Duration
NumberOfChannels
Rating
BitrateType
DrmStatus
Track
SampleFormat
Buyflag
AudioBitDepth
Width
Height