
Design an InfluxDB schema for greenhouse temperature data. Write and query the last day’s readings using the line protocol, and visualize results with JavaScript.
Master InfluxDB schema design and line protocol for sensor data in a greenhouse, using measurements, tags, fields, and timestamps with Unix time and nanosecond precision.
Explore the InfluxDB query language by writing queries to fetch sensor data, filter by last day and sensor ID, and compute the mean of temperature with quotes and function calls.
Design an influxdb schema using a low cardinality checklist, appropriate precision, and avoid encoding data in tags, modeling sensors with two tags and a temperature field for scalable queries.
Learn how to set up influxdb with docker-compose, using the default configuration file to write and read points to the database with the latest influxdb image.
Create and use an InfluxDB database to write and read points by sending a post request to the instance with a JSON body.
Post datapoints to an influxdb instance using postman, with measurement sensors, tag sensor id, fields temperature in fahrenheit, and a millisecond timestamp; learn to post multiple points at once.
Query datapoints from influxdb using Postman by selecting temperature from sensors, with sensor id as a tag and time as a field, for the last 24 hours.
Create a database in Python using the requests library by sending a POST request with a q=create database payload, then verify the response and start reading and writing points.
Learn to write temperatures for a full day in Python by generating 2,880 data points at 30-second intervals and posting them to InfluxDB using line protocol with millisecond timestamps.
Learn how to query temperatures from sensors in influxdb using python, build a request with sensor id and url parameters, and parse the JSON results with series and values.
Visualize the last 24 hours of temperature readings from a dummy sensor with Highcharts, tracing a time series and a quick JavaScript code walkthrough.
Learn how to fetch InfluxDB data with ajax, parse results, map values to a chart, handle time zones, and update the chart.
Recap the creation of temperature sensor data points and their graphing. Reduce point volume with 20-minute groupings and mean, and note unit mismatches across Celsius, Fahrenheit, Kelvin, hinting at Capacitor.
Learn how to use retention policies and a continuous query for downsampling in InfluxDB, reducing growth from 30-second sampling by aggregating temperatures every 10 minutes.
Learn advanced influxdb queries to filter sensor temperatures with regular expressions, compute max and mean differences from nested queries, and count temperature records within specific time ranges.
Set up and deploy influxdb in the cloud using a browser app and a backend on a virtual machine, with secure communication, security groups, access controls, and backups.
Explore influxdb internals by seeing how series form a map of measurements concatenated with tags like user id, email, and first name, and how time-indexed charts enable fast queries.
Direct learners to deepen their InfluxDB knowledge by exploring glossary, concepts, and schema design pages. Review the line protocol reference and query language explorations for practical hands-on understanding.
UPDATE 8th Oct 2018:
I am sorry for any confusion caused by the title and description. I have now renamed the course to: "Quick introduction to influxdb" to more accurately describe the content.
Have you started checking out influxdb or any of the other components in the TICK stack? Even though the documentation is good, it can be tiring and inefficient to simply read through. Let me take you step by step through learning about the TICK stack by building projects. Each project will have a specific goal and contain lecutures with key takeways. Moreover the code is available and ready for you to temper with.
So if you are ready to speed up your learning of the TICK stack join me in building some projects!
I'll do my best to keep the lectures relevant, fun, and engaging by:
Building projects
Pointing out none obvious concepts and explanations
Showing diagrams to explain concepts
Questioning your understanding
Reference influxdata documentation to help you learn more
*If you have any feedback please let me know.
**This is my first course and I have a lot to learn.
***This course is under development and I would love to get some feedback on what you want to learn next.