Consolidated.db

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(Links)
(Category:SQLite based file format)
 
(3 intermediate revisions by 2 users not shown)
Line 7: Line 7:
 
'''consolidated.db''' is the file which some versions of Apple's iOS system (for iPhones and iPads) use to "secretly" keep track of their past locations, thus giving a history of where their users have been. It's secret in the sense that nothing has been openly documented in a highly visible manner to the effect that such a log is being kept (though who knows [http://www.southparkstudios.com/full-episodes/s15e01-humancentipad what they might be hiding] buried in the long agreement you must click through to use their stuff), much less telling anybody how to find it, read it, delete it, etc. However, third-party investigators have discovered it and documented quite a bit of information about where it can be found, what its format is, and even created utilities to help you deal with it.
 
'''consolidated.db''' is the file which some versions of Apple's iOS system (for iPhones and iPads) use to "secretly" keep track of their past locations, thus giving a history of where their users have been. It's secret in the sense that nothing has been openly documented in a highly visible manner to the effect that such a log is being kept (though who knows [http://www.southparkstudios.com/full-episodes/s15e01-humancentipad what they might be hiding] buried in the long agreement you must click through to use their stuff), much less telling anybody how to find it, read it, delete it, etc. However, third-party investigators have discovered it and documented quite a bit of information about where it can be found, what its format is, and even created utilities to help you deal with it.
  
The file is in [[DB (SQLite)|SQLite]] format, and while the original on the iOS device itself is not readily accessible to apps, etc., it does get copied to a Mac or PC as part of system backups upon syncing, and is then accessible to the user there.
+
The file is in [[SQLite]] format, and while the original on the iOS device itself is not readily accessible to apps, etc., it does get copied to a Mac or PC as part of system backups upon syncing, and is then accessible to the user there.
  
 
== Links ==
 
== Links ==
* [http://techland.time.com/2011/04/20/hidden-iphone-file-records-your-location-coordinates/ Hidden iPhone file records your loction coordinates]
+
* [http://techland.time.com/2011/04/20/hidden-iphone-file-records-your-location-coordinates/ Hidden iPhone file records your location coordinates]
 
* [http://petewarden.github.com/iPhoneTracker/ iPhoneTracker] - Mac utility to view this data
 
* [http://petewarden.github.com/iPhoneTracker/ iPhoneTracker] - Mac utility to view this data
 
* [http://andykn.blogspot.com/2011/04/iphone-tracker.html Info on accessing the file from Windows]
 
* [http://andykn.blogspot.com/2011/04/iphone-tracker.html Info on accessing the file from Windows]
Line 16: Line 16:
  
 
[[Category:iOS]]
 
[[Category:iOS]]
 +
[[Category:File formats with a distinctive filename]]
 +
[[Category:SQLite based file formats]]

Latest revision as of 00:02, 22 January 2020

File Format
Name Consolidated.db
Ontology
Extension(s) .db

consolidated.db is the file which some versions of Apple's iOS system (for iPhones and iPads) use to "secretly" keep track of their past locations, thus giving a history of where their users have been. It's secret in the sense that nothing has been openly documented in a highly visible manner to the effect that such a log is being kept (though who knows what they might be hiding buried in the long agreement you must click through to use their stuff), much less telling anybody how to find it, read it, delete it, etc. However, third-party investigators have discovered it and documented quite a bit of information about where it can be found, what its format is, and even created utilities to help you deal with it.

The file is in SQLite format, and while the original on the iOS device itself is not readily accessible to apps, etc., it does get copied to a Mac or PC as part of system backups upon syncing, and is then accessible to the user there.

[edit] Links

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox