KNIME and SQLite - simple example (4.0 New DB nodes)

this demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform database operations on.

Also the data is read by R and data is written back into SQLite with R. The benefit is that the types of data will be better preserved than with CSV.

External resources

• META: A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
• more SQLite KNIME workflows
• H2 SQL database workflows
• HUB: KNIME and SQLite - simple example (4.0 New DB nodes)