This script is designed to extract BLOB-data from SQLite database files.

The script will work with both records and entries albeit the option to process selected items in the current view will not work with records: tags must be used instead.

A condition can be used to extract only those BLOBs that match the criteria specified by the user. These include GZIP-compressed BLOBs, which can be decompressed automatically.

Regardless of the size set in the condition, empty BLOBs will never be extracted.

The script provides the option to specify the offset and maximum length of data to be extracted from each BLOB.

A BLOB won't be extracted if its length is smaller than the offset specified.

Processing SQLite write-ahead-log (*.WAL) files will cause the main database file and the WAL file to be extracted to the current case's temporary folder. A GUID will be used to identify the files for each database.

The WAL file will be deleted automatically when the database is closed. The main database file will be left behind so the examiner can wipe-delete it should they so wish.

Taking the option to use a flattened output path will cause the script to include only the source file's GUID and name in the output LEF. This may make it easier to perform additional analysis, e.g., property-list parsing.

The script can automatically decode/bookmark property-list and JSON data written to the LEF, in which case each bookmark will link to the BLOB data in the LEF, not the original database.

Settings will be saved for re-use. Progress can be monitored via the console.

This script was developed for use in EnCase training. For more details, please click the following link:

- OpenText EnCase Training


SQLite BLOB Extractor 3.0
Jan 18, 2024
More info Less info
Product compatibility
Version 22.3 · 22.4
Version 23.2 · 23.3 · 23.4
Release notes

This release supports GZIP-compressed data.


Unsubscribe from notifications

You are receiving release updates for this item because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the updated Marketplace Terms of Service
Since you are downloading an app from the OpenText Marketplace, you need to accept the updated Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service" box below and click accept to continue your download.

Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2024-onetrust-for-Marketplace-6014 | Wed Feb 28 09:09:26 PST 2024