Icon

t_​001_​sqlite_​knime_​37_​db_​legacy

KNIME and SQLite - simple example (3.7 Legacy DB nodes)
this demonstrates the use of a local SQLite database where you can store data andkeep the variable type and perform database operations on.hint: you can later use the data from the SQLite data base in Python or R create db.sqlitecreate dummy datainsert data into DBSELECT * FROM testGROUP BYDownload Datafrom DBcreate variable with path <dbfile>result_from_test_from_localresult_from_test_from_db SQLite Connector(legacy) Data Generator Database Writer(legacy) Database TableSelector (legacy) Database GroupBy(legacy) Database ConnectionTable Reader (legacy) Create Directory Java EditVariable (simple) Database Writer(legacy) Database ConnectionTable Writer (legacy) this demonstrates the use of a local SQLite database where you can store data andkeep the variable type and perform database operations on.hint: you can later use the data from the SQLite data base in Python or R create db.sqlitecreate dummy datainsert data into DBSELECT * FROM testGROUP BYDownload Datafrom DBcreate variable with path <dbfile>result_from_test_from_localresult_from_test_from_db SQLite Connector(legacy) Data Generator Database Writer(legacy) Database TableSelector (legacy) Database GroupBy(legacy) Database ConnectionTable Reader (legacy) Create Directory Java EditVariable (simple) Database Writer(legacy) Database ConnectionTable Writer (legacy)

Nodes

Extensions

Links