Attila Toth - Timescale Blog

How to Choose the Best Time-Series Database for Your Project

14 Sep 2022 12 min read

In a world with more data, where measuring what matters is critical, your time-series database needs to be scalable, reliable, and user-friendly. Here’s how you can choose the best time-series database for your project.

What Is Time-Series Data? (With Examples)

9 Aug 2022 16 min read

This article is a primer on time-series data and why you may not want to use a “normal” database to store it. ✅ Get the basics, key database considerations, and more.

Analyzing the Bitcoin Blockchain: Looking Behind the Hype With PostgreSQL

16 Jun 2022 15 min read

Our Bitcoin blockchain data analysis revealed that transaction fees might be on the rise as solutions such as off-chain transactions and scaling transaction batches gain ground. This blog post shows you how we reached these findings— and how to do your own research—using PostgreSQL.

How to Store and Analyze NFT Data in a Relational Database

13 Jan 2022 14 min read

Find out how we sourced NFT data and created a schema to store NFT transactions in the open-source relational time-series database, TimescaleDB.

Securing Your Time-Series Data With VPC Peering for Timescale Cloud

13 Dec 2021 4 min read

VPC peering allows you to securely connect your existing AWS infrastructure to Timescale Cloud without ever exposing your services to the public Internet, ensuring maximum safety and privacy.

Analyze millions of NFT sales on OpenSea using PostgreSQL and TimescaleDB

29 Oct 2021 11 min read

Introducing the Timescale NFT Starter Kit, a step-by-step guide to get up and running with collecting, storing, analyzing and visualizing NFT data from OpenSea. And the Time Travel Tigers NFT Collection!

AWS Lambda for Beginners: Overcoming the Most Common Challenges

23 Sep 2021 11 min read

Learn how to overcome three common challenges while building data pipelines with AWS Lambda. Add external dependencies to your Lambda function with Layers, overcome the 250MB package limit with Docker, and set up continuous deployment with GitHub Actions.

Hacking NFL data with PostgreSQL, TimescaleDB, and SQL

27 Jul 2021 15 min read

Learn how to use time-series data provided by the NFL to uncover valuable insights into many player performance metrics – and ways to apply the same methods to improve your fantasy league team, or your knowledge of the game - all with PostgreSQL, SQL, and freely available extensions.

How to store time-series data in MongoDB, and why that’s a bad idea

17 Dec 2020 19 min read

260% higher insert performance, up to 54x faster queries, and simpler implementation when using TimescaleDB vs. MongoDB for time-series data.