KNIME, Python and SQL with local SQLite database

KNIME, Python and SQL with local SQLite database
Some examples how to interact with a (local) SQLite database with SQL commands via Python (Jupyter Notebook)
in the /data/ folder is a Jupyter notebook kn_example_db_sqlite_python_sql.ipynb where you can explore the options you have with SQL and Python using a local database

THX J. Thelen for support and doing the KNIME & SQL nodes

External resources

• HUB: examples with SQL/H2 databases
• HUB: examples with SQLIte databases
• META: A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
• Titanic KNIME Beispiel (deutsch) - SQL Datenbanken mit KNIME
• official: KNIME Database Extension Guide
• HUB: Play around with SQLite and Date and Time functions
• GitHub: KNIME, Python and SQL with local SQLite database
• HUB: KNIME, Python and SQL with local SQLite database