iiinova — where your digital self keeps evolving

Tobias Petry @tpetry.me · 08/08/2025

My free course about fast analytics with TimescaleDB is near - after a long time. The design is almost finished and I am beautifying the first two modules now for a release at start of September. So happy the first things will finally be released 😃

130

Tobias Petry @tpetry.me · 23/04/2025

I completely missed that my Laravel PostgreSQL driver crossed 1 million downloads two weeks ago! Never imagined so many using it 🤯

030

Tobias Petry @tpetry.me · 25/02/2025

I am working on an interactive graph for the Timescale course to show that analytical queries get much slower the more data you have. Its fake numbers for now... Do you prefer the first or second one? I like that the 2nd one doesn't need an extra axis to describe the points.

000

Tobias Petry @tpetry.me · 24/02/2025

I am finishing right now the docs on how to use Timescale with Laravel by implementing a simplistic requests performance logging system. I am always amazed how easy you can build nice looking console output with Laravel ❤️

020

Tobias Petry @tpetry.me · 12/02/2025

I am creating a new course this year. 🔥 I will share with you how to make analytics queries (e.g. dashboards) on large data incredibly fast using Timescale. Just a few PostgreSQL queries executed and you're done - it's magically easy. I love it and always recommend it! ❤️

2121

Tobias Petry @tpetry.me · 06/02/2025

🥳 Some great news next week. I am so full of energy for this year...

020

Tobias Petry @tpetry.me · 03/02/2025

OpenSource is a lot of hard work. Sometimes fun, sometimes daunting - depending on how nice your users are. And sometimes you would like to know WHO is using your stuff and WHY: I don't know why my install count is skyrocketing and I will never know - but really would love to

020

Tobias Petry @tpetry.me · 29/01/2025

Does anyone know of a package to integrate markdown with blade? So, for example embedding blade components into markdown. I know that @aaronfrancis.com worked on it for his blog but never released it. Could need something currently too.

120

Tobias Petry @tpetry.me · 28/01/2025

But my most favourite feature is continuous aggregates: Why execute the same queries all the time when a user views the dashboard? Let Timescale create a new table for a specific query and let it auto-update the values - IN REALTIME! That's a gamechanger for performance 🔥

110

Tobias Petry @tpetry.me · 28/01/2025

Those policies are awesome to have everything happen automatically. But sometimes you are changing rows after those policies have been executed by e.g. importing old data from a 3rd party system. You can then also run all these actions manually again!

100

Tobias Petry @tpetry.me · 28/01/2025

But if we decide we still need the data after a long time? Its been deleted... When using Timescale Cloud, you can use data tiering: Instead of deleting the data, its moved from your DB to Amazon S3. Its never gone! And you can still query it like before 🤯

100

Tobias Petry @tpetry.me · 28/01/2025

Even after compression, disk usage will grow and grow indefinitely when inserting billions of rows a day. But we're not interested in data older than a year 🤔 So we're creating a policy that everything older than 1 year will automatically be deleted - within milliseconds!

100

Tobias Petry @tpetry.me · 28/01/2025

Next we're activating compression to have less data to scan when querying the table -> faster performance. The data can sometimes be compressed by 90% 🤯 All of this will happen in the background too with our compression policy that will compress all data older than 3 days.

100

Tobias Petry @tpetry.me · 28/01/2025

All data is always sorted by the insertion time. So data for one website is spread through the table -> not great for performance We can ask Timescale to automatically reorder the rows in those daily tables so that data for the same website is nearby.

100

Tobias Petry @tpetry.me · 28/01/2025

First, we're telling Timescale to transform our table into a hypertabe and (invisibly) create new sub tables for every day. This is our entrypoint for all the magic that is now being applied.

100

Tobias Petry @tpetry.me · 28/01/2025

🚀 New feature for my enhanced Laravel PostgreSQL driver: Migration support for Timescale to do very fast analytics 👇 A quick overview of the easy steps you can do to get fast analytics on big data

121

Tobias Petry @tpetry.me · 26/01/2025

Has somebody experience with GitHub Codespaces? I was able (with a lot of trial & error) to get it running for Laravel projects. But on every page load at least 1-2 assets fail loading - different on each load. Its impossible to work with that weird behaviour...

net:::ERR_HTTP2_PROTOCOL_ERROR 200 (OK) when loading assets

010