Jônatas Davi Paganini

2 months ago | timescale.com | Jônatas Davi Paganini |Ana Tavares

The intermittent energy project is a global energy grid analytics platform that processes and analyzes power grid data (a.k.a. time-series data) from over 40 countries. Created by Morgan Christiansson to test the assertion that “the wind is always blowing somewhere,” the project leverages publicly available energy data to shed light on energy transition discussions.

Dec 4, 2024 | timescale.com | Jônatas Davi Paganini

If you've been working with PostgreSQL, you've probably seen memes advocating for denormalized counters instead of counting related records on demand. The debate usually looks like this:-- The "don't do this" approach: counting related records on demandSELECT COUNT(*) FROM post_likes WHERE post_id = $1;-- The "do this instead" approach: maintaining a denormalized counterSELECT likes_count FROM posts WHERE post_id = $1;Let's break down these approaches.

Nov 27, 2024 | timescale.com | Jônatas Davi Paganini

Rails developers know the joy of working with ActiveRecord. DHH didn’t just give us a framework; he gave us a philosophy, an intuitive way to manage data that feels delightful. But when it comes to time-series data, think metrics, logs, or events, ActiveRecord can start to feel a little stretched. Handling huge volumes of time-stamped data efficiently for analytics? That’s a challenge it wasn’t designed to solve (and neither was PostgreSQL). This is where TimescaleDB comes in.

Oct 15, 2024 | timescale.com | Jônatas Davi Paganini

Data isn't always available in clean, structured formats, which is why you need to parse it. Data parsing is the process of converting your data from one format to another to make it more structured. As a developer, I'll never forget the incredible amount of data parsers I built throughout my career. Pulling data from diverse sources like PDFs, scraping web pages, and adapting the latest HTML version—in sum, parsing data—is always a recurring task in development.

Apr 3, 2024 | timescale.com | Jônatas Davi Paganini

The choice between using a cloud database or opting for a self-managed setup is critical for every developer as it affects the entire framework through which an organization processes its data. Funny enough, nothing has taught me more invaluable lessons about infrastructure than living in the countryside for the past four years. These experiences have shaped my mindset about what I prefer to manage myself and what I’d rather have as a service.