How to Get the Current Date and Time in SQL
This article was written by Pius Aboyi. Scroll down for the author’s bio. SQL databases have several functions that reduce the complexity of working with date and time. Using these functions and a date and time type column, you can depend...
IoT Sensors: What They Are and How to Use Them
This article was written by Rhuan Souza. Scroll down for the author’s bio. For a very long time, businesses in various industries have been using smart sensors. However, with the development of the Internet of Things (IoT), their significance has increased....
Telegraf 1.26.0 Release Includes Static Linux Builds, State Persistence, OpenSearch Query, and Windows Management Instrumentation
A new feature-bearing release for Telegraf is now available: Telegraf 1.26.0 — Release notes You can find the binaries for the latest Telegraf release on our Downloads page. Many thanks to all the open source community members who contributed to this...
Time Series Data, Cardinality, and InfluxDB
What is cardinality? In the world of databases, cardinality refers to the number of unique sets of data stored in a database. If we drill down a little further, we can think of cardinality as the total number of unique values...
Using Deduplication for Eventually Consistent Transactions
This article was originally published in InfoWorld and is reposted here with permission. Deduplication is an effective alternative to transactions for eventually consistent use cases of a distributed database. Here’s why. Building a distributed database is complicated and needs to consider...
Data Modeling: Part 2 — Method for Time Series Databases
This article was originally published in The New Stack and is reposted here with permisison. You can find Part 1 of this series here. Time-varying entities may contain multiple time-varying and static attributes, making mapping them a particular challenge. Time is...
Why InfluxDB Cloud, Powered by IOx is a Big Deal to Me
From time to time throughout my career, I have been involved in projects with dramatic releases when we built and delivered something very new and very special. The release of InfluxDB Cloud, powered by IOx (referred to as “InfluxDB IOx” for...
Data Modeling: Part 1 — Goals and Methodology
This article was originally published in The New Stack and is reposted here with permisison. In different techniques, entities and relationships remain central. However, their nature and roles are reinterpreted according to the business goals. Data modeling is the process of...
Why I Joined InfluxData, and Why I’m Still Here – Four Years Later
Time Series Database. That term resonated somewhere deep in the structures of my mind, as it jumped off the screen while semi-consciously thumbing through the usual stream of drivel in my LinkedIn feed. … Time Series Database? Ah yes, it was...
4 Unique Time Series Workloads for InfluxDB, Powered by IOx
Different time series workloads Data is kind of like Newton’s first law of motion. Data is just that unless acted upon by something else. Time series data, therefore, is something you derive from data. We generally derive time series data to...