Tobias_Petry.sql
@tobias_petry
Followers
24K
Following
8K
Media
697
Statuses
9K
The Database Guy. I am helping you get better with MySQL and PostgreSQL. ⚡️ https://t.co/WwHTfJFoA5 📝 https://t.co/zJpXKSTKve 🛠️ @stackbricksapp
Darmstadt, Germany
Joined June 2013
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
Indexes can be easy. I promise.
35
113
450
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.
So today I have to say this again:. Do not use UUID for primary keys!.
4
1
20
Does anyone know who is in charge of the Laravel Reddit channel nowadays? Two years ago I got the announcement pinned for 1-2 weeks. But the person is no longer a moderator. /cc @LiamHammett.
2
0
1
I am expecting some changes this year. 👉 With Laravel Clouds focus on PostgreSQL, I expect its useage to increase a lot. 👉 And the same with the Laravel Nightwatch release, i expect more devs are using Application Performance Profiling.
0
0
1
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
This survey is an attempt to gain insight into the representation of the diverse technologies and behaviors of this outstanding community.
18
80
195
RT @ApiPlatform: 🚨 #APIPlatformCon 2025 speaker reveal! Meet @tobias_petry, database specialist, and international speaker. His talk “Scali….
0
2
0
Found the issue, its a nodejs bug 🤪.
github.com
Node.js JavaScript runtime ✨🐢🚀✨. Contribute to nodejs/node development by creating an account on GitHub.
0
0
1
Has somebody already worked with Explicit Resource Management in nodejs?. The TypeScript code works perfectly by releasing the connection when transformed with TypeScript (as you can see). But with ESNext and native "using" (without transform) its never cleaned up. So weird.
1
0
2
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?.
10
4
29
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 🤯.
0
1
18
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!.
🚨 We’re hiring Laravel lovers!. 🛠️ Building tools to simplify B2B purchases (SOA, TALL welcome). 👨💻 Full-time (Cologne, hybrid).🤝 Or ~20h/wk as freelancer (DE only). 💬 Join our dev team & ship clean code.
1
1
4
I completely missed that my Laravel PostgreSQL driver crossed 1 million downloads two weeks ago! . Never imagined so many using it 🤯
3
1
135
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 😅
8
1
34
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.
5
0
9
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.
cloudflare's first innovation week of 2025 just wrapped up, and i wasn't joking when i said every product in the future will be powered by Workers AI. we don't think of AI solely as a vertical - but as a horizontal platform that supports all products. truthfully, i didn't know.
2
2
17
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
Analyze real sports data using SQL! Compete with others and improve your query skills.
4
23
115
This note is not specific about this approach. Sure its easy to loose all data in this case and hopefully company really does that. But we always think about being offline in every case and make or use very expensive solutions because of that. Step back: Is it really needed?.
0
0
3