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

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 😃

Bild

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

Bild

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.

BildBild

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 ❤️

Bild

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

Siren Call of SQLite on the Server

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

pid1.dev

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! ❤️

Bild

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

Bild

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.

Bild

🚀 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

Bild

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