Tobias Petry
@tpetry.me
180 followers 90 following 62 posts
The Database Guy. I am helping you get better with MySQL and PostgreSQL. https://goodindexes.com https://mysqlexplain.com https://sqlfordevs.com
Posts Media Videos Starter Packs
tpetry.me
Happy you like it. And it also has basic TimescaleDB integration. Currently, only for the migrations but I may add querying functionality probably one day.
tpetry.me
I did. They pay for all my work doing the course so I can offer it for free.
tpetry.me
👉 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
tpetry.me
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
tpetry.me
The State Of Laravel 2025 results are live!

Sadly, this year we didn't reach the same number of participants as last years. So please subscribe to the newsletter to be notified next years.

stateoflaravel.com

1/3
stateoflaravel.com
tpetry.me
I am using Tailscale. But if you restrict your ports in the ACL settings that you can have access to...
tpetry.me
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 😃
tpetry.me
I completely missed that my Laravel PostgreSQL driver crossed 1 million downloads two weeks ago!

Never imagined so many using it 🤯
tpetry.me
Person A: Hey, can't we use AI to do X in the Y module? That would be a really great feature and experience for the user.

Me: Good Lord. You're describing an if-statement. Just do a simple if, you don't need AI for that.

That definetely happened!
tpetry.me
Everything correct. But the rabbit hole is much deeper: SQLite even doesn't have "usefull" EXPLAIN output. Its showing you the plan it used without any more information. So there isn't even an indication about row estimates. This makes optimizing a painfull guessing game.
tpetry.me
I've learned to ignore any hype. For everything new, wait 1-2 years. Most things fizzle out, many things will be critized after a short time when initial hype fades and just a few things will stay and be used for a long time.

And I then use it when all initial quirks are solved 😃
tpetry.me
All these interactive articles are now written because you've inspired us. You should pat yourself on the shoulder 😉
tpetry.me
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 🙃
tpetry.me
I am on the same boat. Safari is a fantastic browser for using the web but somehow the dev tools feel clunky and I don't find what I am searching for. Either it does not exist or I can' find it.
tpetry.me
I think JSON schema is easier to write? And with xml schemas (in the past) I had the problem that I couldn't express some constraints - JSON schema improved massively in that.
tpetry.me
It was tip of the ice berg. Inviting a Russian state news agency (said to be the KGB) into this event is just - I don't have words for this...

They ssad they removed it when they've known about it. But someone had to invite them first - inofficially!
tpetry.me
Its even a law in Germany. The "right to own your image" - so I am violating a law sharing a picture of you without your consent. Its only lifted if you're a kind-of famous person.
tpetry.me
Thats a very nice analogy. I'll remember that for the future!

In the past I always explained that the 1% unhappy/angry people are more vocal than the happy ones. Its a more realistic estimate but also feels like not important because its such a small number
tpetry.me
Its the same as uBlock Origin Lite: an ad-blocker built on the less capable tech of the new plugin system - but there should be ads for you. E.g. youtube is unblockable I thought with the new model.
tpetry.me
Sure you can use any other adblocker - like uBlock Origin Lite. But its effectiveness has been crippled massively with the new plugin api chrome enforced.
tpetry.me
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?
tpetry.me
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.
tpetry.me
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 ❤️
tpetry.me
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.