### Ako zvládnuť webinár * pomenuj svojho avatara * napr. dvojkliknutím na svoje meno vpravo hore * nevysielaj obraz, keď nemusíš a vypni mikrofón, keď nehovoríš * ušetríš linku ostatným ;) * minimalizuješ vzruchy * pýtaj sa, ak máš nejasnosti * stlač medzerník a drž ho, kým rozprávaš (ako na vysielačke) alebo použi chat
## Node-RED a databázy pre IoT mirek@cnl.sk / [**Namakaný deň - Webináre**](http://www.namakanyden.sk/webinare/)
## Oznamy * https://fred.sensetecnic.com * témy nabudúce: * 3D tlač (Michal Sedláček) * Testovanie (Milan Varga) * Low-Power
![IoT Architecture Overview](images/iot.architecture-overview.png)
## SQL vs NoSQL
![Scale Out vs Scale Up](images/scale.out.vs.scale.up.png)
![Cost difference in vertical vs horizontal scalability](images/price.of.scalability.png)
## Time Series Databases
![DB-Engines Score by DB Category](images/db-engines.score.png)
![Regular vs Irregular Time Series](images/regular.vs.irregular.time.series.png)
[![InfluxDB](images/logo-influxdb.png)](https://www.influxdata.com)
## [InfluxQL](https://docs.influxdata.com/influxdb/v1.8/query_language/) * SQL-like query language for interacting with InfluxDB * similar to SQL
## [InfluxDB API](https://docs.influxdata.com/influxdb/v1.8/tools/api/)
## [![SQLite](images/logo-sqlite.png)](https://www.sqlite.org/index.html)
## SQLite Features I. * Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures. * Zero-configuration. * Full-featured SQL implementation with advanced capabilities. * A DB is stored in a single cross-platform disk file. * Supports terabyte-sized databases and gigabyte-sized strings and blobs.
## SQLite Features II. * Simple, easy to use API. * Fast * Written in ANSI-C * Well-commented source code with 100% branch test coverage. * Self-contained: no external dependencies. * Cross-platform * Comes with a standalone CLI client.
## Suggested Uses * Database For The Internet Of Things * Application File Format * Website Database * Stand-in For An Enterprise RDBMS (for demonstration purposes or for testing)
## Otázky?
![qr code](https://api.qrserver.com/v1/create-qr-code/?data=https://bit.ly/3fb8bok&size=300x300) (**https://bit.ly/3fb8bok**)