Tobias Petry

Tobias Petry

@tpetry.me

The Database Guy. I am helping you get better with MySQL and PostgreSQL. https://goodindexes.com https://mysqlexplain.com https://sqlfordevs.com

204 followers90 following63 posts

Interesting findings: ๐Ÿ‘‰ Female ratio dropped after increasing two years ๐Ÿ˜ข ๐Ÿ‘‰ Many new devs from South America ๐Ÿ‘‰ New Laravel devs decreasing year after year (why?) ๐Ÿ‘‰ Devs are switching from PHPStorm to VSCode and other editors (ai? the new VSCode plugin? ๐Ÿ‘‰ TypeScript is booming ๐ŸŒŸ 2/3

๐Ÿ‘‰ many using Postgres (why now? Aaron's course?) ๐Ÿ‘‰ Intertia+React is not the most popular stack but increasing a lot year-over-year ๐Ÿ‘‰ Application Performance Monitoring increased by 11% (seems Nightwatch is a big success?) ๐Ÿ‘‰ Big jump in devs disagreeing with Laravel's direction (why?) 3/3

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 ๐Ÿ˜ƒ

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

Sometimes you're just too stupid... I've been fiddling with a new server for 3 hours to get VPN and firewall working. But somehow my service I wanted to test was never reachable over VPN - no matter what I tried... The VPN has its own firewall and I didn't allow the service ๐Ÿ™ƒ

Chrome disabled ad blockers, Edge now starts doing the same, Firefox changed its policies to allow selling data about youโ€ฆ Is there really any good browser left? Safari?

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.

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 โค๏ธ

"The thing isโ€ฆโ€‹just donโ€™t run SQLite server-side in production. Unless you have a really good reason." That's exactly what I always recommend! SQLite is a great database - until it is not anymore... Many things get really hard once your project grows. pid1.dev/posts/siren-...

pid1.devSiren Call of SQLite on the ServerAt Terrateam, we are big fans of Fly.io. The service is hosted there and itโ€™s served us well. Just deploy your TOML file, get your infrastructure, do something else with the rest of your day. One of t...

I've helped many companies help with their SQLite issues - and migrating off. Profitable for me. A lot of time wasted for them. There are good use-cases for SQLite. I've used it in the past and will again. But only when you really NEED what SQLite provides - not as a default.

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! โค๏ธ

View full thread

So when will it be released? I won't work in silence for a long time and then release it. Instead, a new module will be released every month, and the course should be finished by the end of the year.

You can follow me to see announcements of newly released modules and get a lot of behind-the-scenes stuff about the course creation. I am so enthusiastic about building this :)

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! โค๏ธ

And the best of it? I pitched my plan for the course to Timescale and asked them for a deal: They pay me for it so you can get it for free. They said YES. Isn't that awesome? IT WILL BE ENTIRELY FREE!

This will be a written course again - as I believe its the best medium for learning. But it won't be boring! I am trying something new this time: Each module will be enriched with interactive elements to play with - inspired by the work of @samwho.dev. Learning should be fun!

On the other hand, the hiring process is definetely broken because of AI: 1. Devs using AI to spam applications to every existing open position 2. Companies using AI to filter applications because of too much spam 3. Repeat at 1 ๐Ÿ™ƒ

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

Have fun everyone at Laracon EU tomorrow. I had to skip this year for family reasons but will be there next year again. Can we get some warmed location like Lissabon again? ๐Ÿ˜…

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.

๐Ÿš€ 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

View full thread

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 ๐Ÿ”ฅ

I definitely recommend checking out Timescale when you are analytics with PostgreSQL/MySQL are getting slow! Checkout the other cool features you could be using with my PG driver. In case you are missing some advanced PostgreSQL features, feel free to open an issue. github.com/tpetry/larav...

github.comGitHub - tpetry/laravel-postgresql-enhanced: Support for many missing PostgreSQL specific featuresSupport for many missing PostgreSQL specific features - tpetry/laravel-postgresql-enhanced

๐Ÿš€ 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

View full thread

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 ๐Ÿคฏ

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!

๐Ÿš€ 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

View full thread

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.

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!

๐Ÿš€ 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

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.

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.

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...

You are up to date.