Sign in

Tobias Petry

@tpetry.me
202 followers 90 following 63 posts

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

PostsRepliesMedia
Tobias Petry @tpetry.me · 30/11/2025
Die Registrierung ist leider kaputt und bricht immer im letzten Schritt mit einem unbekannten Fehler ab. Die gewählte Adresse ist dann auch blockiert.
000
Tobias Petry @tpetry.me · 18/09/2025
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.
000
Tobias Petry @tpetry.me · 14/09/2025
I did. They pay for all my work doing the course so I can offer it for free.
110
Tobias Petry @tpetry.me · 09/09/2025
👉 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
130
Tobias Petry @tpetry.me · 09/09/2025
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
140
Tobias Petry @tpetry.me · 09/09/2025
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
173
Tobias Petry @tpetry.me · 08/08/2025
I am using Tailscale. But if you restrict your ports in the ACL settings that you can have access to...
000
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 · 22/07/2025
The State Of Laravel 2025 survey has started! You can now participate to identify how the ecosystem changed over the past 12 months! Please RT for reach ❤️ stateoflaravel.com/participate?...
stateoflaravel.com
The State of Laravel Survey
This survey is an attempt to gain insight into the representation of the diverse technologies and behaviors of this outstanding community.
42226
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 · 18/04/2025
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!
130
Tobias Petry @tpetry.me · 06/04/2025
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.
020
Tobias Petry @tpetry.me · 30/03/2025
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 😃
140
Tobias Petry @tpetry.me · 14/03/2025
All these interactive articles are now written because you've inspired us. You should pat yourself on the shoulder 😉
010
Tobias Petry @tpetry.me · 04/03/2025
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 🙃
110
Tobias Petry @tpetry.me · 04/03/2025
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.
000
Tobias Petry @tpetry.me · 03/03/2025
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.
020
Tobias Petry @tpetry.me · 02/03/2025
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!
020
Tobias Petry @tpetry.me · 02/03/2025
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.
000
Tobias Petry @tpetry.me · 02/03/2025
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
020
Tobias Petry @tpetry.me · 02/03/2025
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.
100
Tobias Petry @tpetry.me · 01/03/2025
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.
100
Tobias Petry @tpetry.me · 01/03/2025
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?
710
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 · 21/02/2025
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.
000
Tobias Petry @tpetry.me · 21/02/2025
"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.dev
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...
140
Tobias Petry @tpetry.me · 19/02/2025
Oh, he doesn't have to stop sanctions with russia. He can just set sanctions on Ukraine to make helping them harder. And then blackmail everyone that giving anything to them is not something the US wants. And you don't want the US to make some policies against you...
100
Tobias Petry @tpetry.me · 19/02/2025
Same shit he is always doing. In a few weeks he will then openly take Russia's position with some real action: No more aid, sanctions, whatever Its a corrupt country now without any morals from their leader.
130
Tobias Petry @tpetry.me · 19/02/2025
The US is now more like a comedy show - albeit not a a funny one.
220
Tobias Petry @tpetry.me · 12/02/2025
Awesome 😃
000
Tobias Petry @tpetry.me · 12/02/2025
Feel free to send me a DM what you're missing. That would be an interesting insight. Maybe it even leads to explaining this in the course.
110
Tobias Petry @tpetry.me · 12/02/2025
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 :)
000
Tobias Petry @tpetry.me · 12/02/2025
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.
110
Tobias Petry @tpetry.me · 12/02/2025
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!
120
Tobias Petry @tpetry.me · 12/02/2025
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!
100
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 · 11/02/2025
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 🙃
000
Tobias Petry @tpetry.me · 11/02/2025
In my opinion AI is not the reason that getting a job as a developer is so hard currently for many. Big companies just realized that they overhired so hard and have many employees doing barely anything. A ton of tire kickers. Fire and not rehire is a sane solution. www.youtube.com/watch?v=biUF...
youtube.com
Developers are getting screwed.
YouTube video by typecraft
100
Tobias Petry @tpetry.me · 10/02/2025
Escaping the standard problem... I can totally relate to that.
000
Tobias Petry @tpetry.me · 10/02/2025
Isn't that every of your game projects? 😅 I am interested in these posts not because I want to play the game. Heck, if not played a game in months. But because of the tech stuff or background knowledge. All the behind the scenes!
110
Tobias Petry @tpetry.me · 08/02/2025
CTO Fahrenheit... Is that to get an early warning when the boss is about to explode?
000
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 · 06/02/2025
For photoshop, yes. But if you replace Photoshop with a real name, then the active language may sound better. In isolation its not a big difference. But understanding your message gets harder if you have passive sentence after passive sentence after passive sentence...
010
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 · 02/02/2025
Can you share the slides?
100
Tobias Petry @tpetry.me · 02/02/2025
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? 😅
030
Tobias Petry @tpetry.me · 02/02/2025
Is that even possible? Everytime I board a plane (in Europe) my ticket is scanned to open the gate for me. Impossible to get on board of the plane without it.
110
Tobias Petry @tpetry.me · 30/01/2025
Yeah, I am not using it for user-submitted stuff. Just my articles which should be free of any issues - except i am trying to hack myself.
010
Tobias Petry @tpetry.me · 29/01/2025
Yeah I am currently experimenting with the same. And that the slot of <x-markdown> is again content that's handled markdown. Seems to work after a few first tests.
100