:: Training

:: Mailing List
News and updates:

Subscribe here


:: Contact

Contact Us


Email: info@filesig.co.uk

Post: Filesig Software,
PO Box 678,
York,
YO26 0FU

SQLite Database Catalog

A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z - 0 - 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - Symbol

The SQLite database catalog is a repository of information used to identify specific SQLite databases and properties for research purposes.

This catalog is original research and copyright protected, users may not copy or duplicate the information that has been collated in the SQLite Database Catalog without permission from the authors. If you have an interest in this resource for use in your own projects please contact us.

The catalog comprises of a number of fields:

Reference - this is a reference number, starting from 1 given to each newly identified database.

SQLite Database ID - this is a hash unique to an identified database

Known Filenames - this is a list of file names found to be associated with a particular database file

Known Filepaths - this is a list of file paths found to be associated with a particular database file

Known Tables - this is a list of tables known to reside within a particular database

Min Size - this is the smallest logical size of database identified to date

Max Size - this is the largest logical size of database identified to date

Auto Vacuum Count - this is the number of times a particular database has been found to have the Auto Vacuum feature enabled or disabled

Created - the date the current catalog record was created

Modified - the time the current catalog record was last modified

In addition to the fields the data may contain tags used to indicate user identifiable information which may change from device to device:

  • -=number=- a number identifying an item or person (ex: user account reference number)
  • -=User Profile=- text identifying an item or person (ex: name of user profile folder on operating system)
  • -=app id number=- a number generated by an application (ex: device serial number or user account number)

The catalog has many uses and will benefit users in multiple fields of work:

Advantages:

  • Assists in identifying specific SQLite Database file without the need for user to manually inspect
  • Provides a knowledge base of alternative names of database files that have the same purpose
  • Provides extensive list of common locations of where SQLite Databases reside on computer and mobile devices
  • Provides comprehesive overview of the tables present within specific SQLite Database files
  • Gives an indication of logical size range of a particular SQLite Database, useful for processing or data recovery purposes (file carving)
  • Provides an indication of recovering deleted records from a SQLite Database based on Auto Vacuum settings
  • Useful for rapid identification, recovery and processing of SQLite Databases in numerous applications

Disadvantages:

  • Two databases containing the same tables may produce the same Database ID hash, this has a greater chance of occurring with generic databases that may contain a single table called 'table' for example. In this situation the data will be merged into a single record even though the purpose of the databases may differ greatly. As the catalog expands and if a particular group of databases merge in this manner they will be treated as a "Generic" category.

A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z - 0 - 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - Symbol

Disclaimer:The data in the SQLite Database Catalog was collated and is maintained by Filesig Software Solutions and is copyright protected 2013 Filesig Software Solutions. Information is provided as is without any warranties we accept no responsibility for errors or omissions.