Jônatas Davi Paganini - Timescale Blog

Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure Choices

3 Apr 2024 8 min read

Read what country living can teach you about infrastructure choices and choosing a self-hosted vs. cloud database.

Adapting JSON Structures for Real-Time Aggregates: A Community Solution

29 Mar 2024 4 min read

Read how you can work with JSON structures and real-time data aggregations using custom aggregate functions, courtesy of the Timescale community.

Unveiling the New Timescale Community Templates

28 Mar 2024 3 min read

Join us in the new Timescale Community Templates, live sessions dedicated to specific industries and designed to foster expertise exchange.

Solving the Challenges of Counter Metrics and Resets in PostgreSQL/TimescaleDB

26 Mar 2024 5 min read

Learn how to solve the challenges of counter metrics, such as counter resets and gaps, in your time-series data using PostgreSQL/TimescaleDB.

Quickly Building SQL Dashboards for Time Series With Continuous Aggregates

19 Dec 2023 5 min read

A tutorial on building dashboards for time-series data with continuous aggregates.

Supercharge Your AI Agents With Postgres: An Experiment With OpenAI's GPT-4

26 Jul 2023 3 min read

Read how you can work with AI agents as intermediaries between AI and databases.

Downsampling in the Database: Processing Data With Ruby or SQL?

2 Mar 2023 1 min read

One way to optimize your data processing is by improving data locality when downsampling your data. Watch this talk at RubyConfTH, where we benchmark downsampling data in Ruby against a SQL version powered by Timescale’s hyperfunctions.

Downsampling in the Database: How Data Locality Can Improve Data Analysis

16 Feb 2023 8 min read

Learn why data locality can be crucial to downsampling data faster and more efficiently, accelerating the work of both devs and businesses. To test this new approach, we benchmarked the LTTB downsampling algorithm in Ruby and compared it with the Timescale Toolkit lttb ().