title: How to dump a file stored in a sqlite database as a blob?
body: <p>I have a sqlite3 database. One column has the TEXT type, and contains blobs which I would like to save as file. Those are gzipped files.</p>
  
  <p>The output of the command <code>sqlite3 db.sqlite3 ".dump"</code>  is:</p>
  
  <p><code>INSERT INTO "data" VALUES(1,'objects','object0.gz',X'1F8B080000000000000 [.. a few thousands of hexadecimal characters ..] F3F5EF')</code></p>
  
  <p>How may I extract the binary data from the sqlite file to a file using the command line ?</p>