in reply to help figuring out what a section of script does

You say that, "I'm extracting sqlite blob data".

That is a fine idea, but I figure that your approach is wrong.

If you are extracting a piece of data from an SQLite DB, you should use the Perl DBI (which automatically will load support for SQLite) to do that instead of parsing the binary file yourself.

An important thing is to have a good SQLite DB viewer. I use a Firefox plug-in, Firefox SQLite Manager. There are other possibilities.

I think what you want to do are SQL statement(s) that will read the BLOB's (Binary Large Object) as a single Perl variable, like $blob. Once you have this .png image or whatever this BLOB represents, then display it.

I highly recommend against parsing the SQLite binary yourself.

  • Comment on Re: help figuring out what a section of script does

Replies are listed 'Best First'.
Re^2: help figuring out what a section of script does
by michaelsingleton (Novice) on Mar 20, 2017 at 11:24 UTC

    Let me give that a whirl! Thanks