General - Timescale Blog (Page 2)

Analytics

Speeding up data analysis with TimescaleDB and PostgreSQL

9 Sep 2021 12 min read

Is your data analysis process as fast and efficient as it could be? This four-part blog series will outline common data analysis problems and how TimescaleDB and PostgreSQL fixed them by making data munging tasks within analysis fast, efficient, and easily accessible.

Speeding up data analysis with TimescaleDB and PostgreSQL

How to Create (Lots of) Sample Time-Series Data With PostgreSQL generate_series()

26 Aug 2021 14 min read

Use generate_series to see how TimescaleDB uses PostgreSQL's rock-solid foundation to build a scalable, fully extensible, powerful time-series database.

What Time-Weighted Averages Are and Why You Should Care

22 Jul 2021 17 min read

Learn how time-weighted averages are calculated and why they’re so powerful for data analysis.

How we’re building a remote-first team culture (aka virtual event ideas that you’re welcome to steal)

6 May 2020 9 min read

As an engineering-centric organization that’s been 60%+ remote for most of our history, we’re creative with the ways we stay connected – and, with COVID-19 making us and all teams 100% remote, we’re sharing how we’ve created camaraderie to help you do the same.

Time-Series Compression Algorithms, Explained

22 Apr 2020 13 min read

Delta-delta encoding, Simple-8b, XOR-based compression, and more - these algorithms aren't magic, but combined they can save over 90% of storage costs and speed up queries. Here’s how they work.

Our Product Team's Reading List: What Moral Psychology, the Rust Belt, and Framing Can Teach Us About UX

17 Apr 2020 7 min read

Like many people, we've been catching up on our book backlog –and we're sharing our recent reads, plus what they've taught us about our work as product managers and engineers.

CTO Corner: This Month in Data (April 2020 Edition)

7 Apr 2020 3 min read

Mike Freedman, Timescale CTO, shares some of the most interesting articles and papers about databases and distributed systems he's found in the past month.

How and why to use SQL for time-series data

4 Feb 2020 8 min read

From schema design to SQL tool recommendations, we’ve rounded up quick (yet powerful) ways to use SQL to work with - and get more from - your data.

What is the State of PostgreSQL?

5 Dec 2019 5 min read

We created and distributed a survey to Postgres users around the globe to see how they are using the database in 2019 and the results are in…

Why SQL is beating NoSQL and what this means for the future of data

8 Jul 2019 11 min read

After years of being left for dead, SQL today is making a comeback. How come? And what effect will this have on the data community?

Rethinking the Database Materialized View as an Index

12 Jun 2019 4 min read

By utilizing the properties of time-series data, can we make the maintenance of materialized views efficient enough so they act like indexes?

Why you should use a relational database instead of NoSQL for your IoT application

28 Feb 2019 5 min read

IoT data is complex and needs to be accessed by multiple users, so don’t make the mistake of creating data silos.

If PostgreSQL is the fastest growing database, then why is the community so small?

21 Feb 2019 3 min read

The database king continues its reign. For the second year in a row, PostgreSQL is still the fastest growing DBMS, however, its community is not keeping pace.

5 ways open source software companies make money

27 Nov 2018 9 min read

A guide on how to evaluate the long-term sustainability of the business behind any open-source software you are using (or considering working on yourself).

Time-series data: Why (and how) to use a relational database instead of NoSQL

20 Apr 2017 14 min read

These days, time-series data applications (e.g., data center / server / microservice / container monitoring, sensor / IoT analytics, financial data analysis, etc.) are proliferating.

Products

Solutions

Costumers

Developers

Pricing

Contact Us

Login

Products

Solutions

Developers

Speeding up data analysis with TimescaleDB and PostgreSQL