Quick introduction to influxdb

Influxdb. Time to awesome = short when following examples and knowing the influxdocs

Created byEspen Albert

Last updated 10/2018

English

What you'll learn

Use influxdb for effectively storing and quering timeseries, e.g. storing temperatures from your IoT device
Understand the influxdb data scheme
Write basic queries
Understand fundamental concepts of influxdb such as measurements, retention policies, tags, fields, series....

Course content

2 sections • 20 lectures • 48m total length

Clone repo and follow instructions

Section 1: Scenario, learning objectives, and steps1:05
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.
Theory: Influxdb schema and LINE protocol4:29
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.
Influxdb schema and LINE protocol
Theory: Influxdb query language1:42
Influxdb query language
Scenario schema design and schema design checklist4:33
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.
Setup influxdb using docker-compose1:11
Create a db with postman0:40
Write a datapoint with postman1:13
Query datapoints with postman1:33
Create a db with python0:51
Write temperatures for a whole day in python3:25
Querying temperatures in python0:57
Graph the temperatures using highcharts0:39
Explanation of visualization code1:58
Learn how to fetch InfluxDB data with ajax, parse results, map values to a chart, handle time zones, and update the chart.
Recap and issues1:51
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.
Retention policy and continuous query for downsampling8:50
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.
Advanced queries6:19
Setup and deploy1:54
Influx internals3:15
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.
Where to go next in the documentation1:40

Requirements

Access and familiarity to bash and docker, needed to install the services.
Preferably some python programming experience, required to understand the example projects.
Familiarity with using a REST api.

Description

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.

Who this course is for:

Software developers who use timeseries in their product
DevOps engineers who wants to manage their resources
Not for frontend developers because the TICK stack resolve backend related issues
Not for developers who has no prior knowledge about REST and databases
Anyone who wants to use influxdb in their application

Quick introduction to influxdb

What you'll learn

Explore related topics

Course content

Preperation: Download code and install requirements1 lecture0

Influxdb project 1: Write and read temperatures using the influxdb REST api19 lectures • 48min

Requirements

Description

Who this course is for: