Tobias_Petry.sql

I am thrilled to announce the official launch of the @IndexingBook. Do you lack indexing knowledge? It has never been easier to learn! This broad topic is explained in a novel, easy-to-understand way supported by graphics that visualize all concepts. 🔥 sqlfordevs.com/ebooks/indexing

An easy way to spot when americans are developing software (without any non-americans in the team) is their understanding of characters. Now @PaddleHQ blocked all special german characters (äöüß etc.) because they don't know of them. The world does use more than ASCI 😅

So today I have to say this again: UUIDv7 primary keys are a valid choice. They eliminated the performance problems of random UUIDv4 values. And if you need to shard one day, you can easily move rows to other shards because you won‘t have clashing numerical ids.

🚨 #APIPlatformCon 2025 speaker reveal! Meet @tobias_petry, database specialist, and international speaker. His talk “Scaling Databases” is a must-see at our fifth edition if you’re focused on performance or planning to scale your databases: api-platform.com/con/2025/

I want to start this years State of Laravel survey in 2 weeks. Last years didnt initially worked so well because it didn't reach enought people. I relied on the help of everyone to distribute it again to get a good participation count. What should I do so everyone know of it?

Realized that I've been using PHP before superglobals had been added and later the deactivation of register_globals had resulted in many broken scripts. So I've been using it before 4.1 (2001). So about 25 YEARS 🤯

Are you a german Laravel developer looking for work (employment/freelancing)? I've got something for you: About 20h/week for a freelancer is a fantastic offer. The project and pay is interesting, really great opportunity!

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

Am i insane? I tried a TypeScript mode that forces you to type everything. Its more verbose - a lot more verbose... But I now had some parts where errors havn't been found with inferred types. I wouldn't do this for every project. But here I need a rock-solid implementation.

Is it too early to say companies lost their focus when they go fullscale on AI? There's so much low-hanging fruit CF should be working on - and they choose AI. For example, you still can't limit an R2 API key to add but not delete data which is important if you want to store…

10x (monkeyuser.com/2025/10x/?ref=…)

I like SQL riddles. So I was happy when @Iyush004 shared with me what he's been working on: SQL puzzles that range from easy to hard. And unlike the other existing projects these run on a real PostgreSQL database :) sqlpremierleague.com