DB SQL - PostgreSQL - Upload binary files to database
<p>Demonstrates uploading some binary files to a database, and then querying back for display as images in a table.</p>
URL: Related forum topic https://forum.knime.com/t/inserting-binary-data-into-sql-database-using-knime/77927/5?u=takbb
URL: KNIME Forum (88079) - Images to PostgreSQL https://forum.knime.com/t/how-to-store-image-into-postgresql/88079/6?u=mlauber71
Nodes
- Rule Engine Variable4 ×
- Boolean Configuration2 ×
- DB SQL Executor (Labs)2 ×
- Java Edit Variable2 ×
- String Configuration2 ×
- Binary Objects to PNGs1 ×
- CASE Switch Variable (End)1 ×
- CASE Switch Variable (Start)1 ×
- Counter Generation1 ×
- Create Collection Column1 ×
- Create File/Folder Variables1 ×
- DB Insert (Labs)1 ×
- DB Query Reader (Labs)1 ×
- Extract Context Properties1 ×
- Files to Binary Objects1 ×
- Image Writer (Table)1 ×
- Java Edit Variable (simple)1 ×
- List Files/Folders1 ×
- Path to URI1 ×
- PostgreSQL Connector (Labs)1 ×
- Python Script1 ×
- Single Selection Configuration1 ×
- String to Path (Variable)1 ×
- Table Manipulator1 ×
- Table Row to Variable1 ×
- URL to File Path1 ×
- Variable to Table Row1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Basic File System Connectors
- FeatureKNIME Data Generation
- FeatureKNIME Database
- FeatureKNIME Javasnippet
- Show all 7 modules
Links
- No links available