Howto SQLite? Save and load a file to a blob?

Databases
1

Hi!

Theme: Webapp, SQLite

how can I save a file into a SQLite DB as a blob? (Blobcolumn)
And:
how can I load this file from the DB to my PC?

Thanks!

2

quite literally read the file in, insert it to a db column (using either a prepared statement or db record insert record)
to reverse the process read the column and write the result back to a file

3

Also check out the SQLite Blob example:

Examples/Database/SQLite/SQLiteBlob