Rendering images stored in database

Hi,

Is there a way to render images that are stored in Blob fields in for exampel a database? It is straightforward to pull up the columns with the databse connector and reader nodes, but the Blob field does not render the images stored in the database.

Kind regards

Hi,

you can read/write png images from/to dbs by using the Binary Object nodes available via the File Handling extension in KNIME. Using these nodes you can convert a KNIME Image into a binary object which you can then write into the database and back again. See the attached workflow for an example.

Bye,

Tobias

Just what I needed, works like a charm!

Many thanks for your swift reply!

I'm happy to be of help. I have also uploaded the workflow to the KNIME Example server where you can find it in the 004_Database section.

Bye,

Tobias