SQLite Forum

Inserting the image as BLOB
Login
Here is an old Windows shell session showing such an operation:<code>
\> sqlite3 myPics.sdb
SQLite version 3.35.0 2021-03-12 15:10:09
Enter ".help" for usage hints.
sqlite> create table images(id integer primary key, image blob);
sqlite> insert into images (image) values (readfile('VCAinvite.PNG'));
sqlite> select id from images;
1
sqlite> select (writefile('VCAinvite_copy.png', image)) from images where id=1;
193428
sqlite> .q
\> fc VCAinvite.PNG VCAinvite_copy.png
Comparing files VCAinvite.PNG and VCAINVITE_COPY.PNG
FC: no differences encountered

\>
</code>