![Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure Choices](/blog/content/images/size/w300/2024/04/Self-hosted-vs-cloud-database_cover--1-.webp)
![Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure Choices](/blog/content/images/size/w300/2024/04/Self-hosted-vs-cloud-database_cover--1-.webp)
![Adapting JSON Structures for Real-Time Aggregates: A Community Solution](/blog/content/images/size/w300/2024/03/Aggregating-JSON-Structures-With-Custom-Aggregate-Functions.png)
![Unveiling the New Timescale Community Templates](/blog/content/images/size/w300/2024/03/Unveiling-the-New-Timescale-Community-Templates-1.png)
![Solving the Challenges of Counter Metrics and Resets in PostgreSQL/TimescaleDB](/blog/content/images/size/w300/2024/03/Solving-the-challenges-of-counter-metrics-and-resets-in-Postgres-and-TimescaleDB.png)
![Quickly Building SQL Dashboards for Time Series With Continuous Aggregates](/blog/content/images/size/w300/2023/12/Quickly-Building-SQL-Dashboards-for-Time-Series-With-Continuous-Aggregates.webp)
![Supercharge Your AI Agents With Postgres: An Experiment With OpenAI's GPT-4](/blog/content/images/size/w300/2023/07/AI-agents.png)
![Downsampling in the Database: Processing Data With Ruby or SQL?](/blog/content/images/size/w300/2023/03/Downsampling-in-the-database-data-locality.png)
Downsampling in the Database: Processing Data With Ruby or SQL?
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](/blog/content/images/size/w300/2023/02/Downsampling-in-the-database_hero_computer-topology-blog--1-.png)
Downsampling in the Database: How Data Locality Can Improve Data Analysis
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 ().