All geek questions in one place

Decode BLOB in SQLite Database

I am studying a database from a third-party application, and I was wondering if it is possible to conclude how to decode a BLOB in a SQLite database if you do not know what is stored inside the BLOB?

Is there a way or tools to solve this problem?

+3
source share
3 answers

Is there a way or tools to solve this problem?

BLOB is binary data. There are ways to restore the data format (these reverse engineering methods apply to the ones you use to decrypt unknown file formats), but without additional information about what is stored in binary BLOB, it is quite difficult, so I can give only some vague tips:

  • : , BLOB - ?
  • - , / ( " " ); , ( zlib, zlib )
  • ( ), , IDA Pro, , , , , BLOB-
+3

BLOB , Unix file, , .

+3

 sqlite3 db.sqlite 'select writefile('data.bin', value) from Record limit 1;'

( , volumn BLOB, IndexedDB)

then you can print the contents of this file with cat data.bin

0
source

Source: https://habr.com/ru/post/1789218/

More articles:


All Articles