Export Photos from SQL Table to local Disk

@Iwo I have created an example how to load and retrieve JPG/JPEG files into a SQLite database.

If you have jpeg files as binary columns in a SQLite database you could retrieve them like this. Define the image as BLOG (or try Binary) in the DB Table Selector.

Then you can convert the binary cells to jpg files with the Binary Objects to Files node

DB SQL - SQLite - store and read JPEG Files in databases - also using Python.knwf (480.8 KB)