Tobias_Petry.sql @tobias_petry
The Database Guy. I am helping you get better with MySQL and PostgreSQL. Building: @stackbricksapp https://t.co/Yfe8XeSBfg https://t.co/ckxS6s2G0r tpetry.me Darmstadt, Germany Joined June 2013-
Tweets8K
-
Followers21K
-
Following271
-
Likes7K
I am speechless… 😵
✨ Designed this dashboard for @tobias_petry's @IndexingBook 📖 👉 Check it out to read the book online, download files, watch videos, and manage team licenses. Let me know if you have any feedback. 😊
Freek Van der Herten .. @freekmurze
59K Followers 522 Following PHP developer at @spatie_be, built @getmailcoach, https://t.co/IRUtuG0FwZ, @ohdearapp and @flareappio, blogging at https://t.co/a3spVy88VN, organising @fullstackeuMarcel Pociot 🧪 @marcelpociot
57K Followers 741 Following Building Laravel Herd, https://t.co/8HwtSFyXJM , https://t.co/vuTdNhyRXo, NativePHP, and other tools for devs. Follow my product dev journey. CTO at @beyondcodeAaron Francis @aarondfrancis
32K Followers 1K Following Co-founder https://t.co/oUwfiB6Kqj. Sincere poster. No cynicism. Dad to two sets of twins! Cohost @MostlyTechPod. Teacher https://t.co/m4dvIEs302.Martin Joo @mmartin_joo
15K Followers 190 Following Upcoming Laravel performance book: https://t.co/X1errH6QKl Blog, DevOps, DDD & microservice books: https://t.co/yJPUsoqTLhCaleb Porzio @calebporzio
45K Followers 672 Following I made @Alpine_JS & @LaravelLivewire I record: @noplanstomerge & https://t.co/T29wEQy5Bv I sell: https://t.co/IvxSUd6ZO6Alex Garrett-Smith @alexjgarrett
13K Followers 458 Following Building things and teaching you how @teamcodecourseDries Vints @driesvints
28K Followers 191 Following 👨🚀 @laravelphp Core Team • 💻 Building @eventyio & @laravelio • ⭐️ @github Star • 💸 @stripe Community ExpertAndrew Schmelyun @aschmelyun
12K Followers 2K Following 👨🏻💻 Developer and tutorial creator — Always starting projects (and sometimes I finish them). Currently growing @suggestggPhilo Hermans @Philo01
10K Followers 206 Following Tweeting about Laravel, Livewire, Shopify Apps, SaaS, and my journey towards adding 50K MRR in 2024. Projects 👉🏻 https://t.co/EvZrBKrpjhJustSteveKing 🥑 @JustSteveKing
9K Followers 820 Following The API Guy, Father, Husband, Vida 🦋🤍 Columnist for @phparch | Tutorials for @laravelnews | DevRel at @treblleapi | Livestreams at https://t.co/CVc6rHiGqcTim MacDonald @timacdonald87
9K Followers 167 Following Big fan of doggos and brunch ☀️ Hypermedia link and form enthusiast 🕸️ Core developer at @laravelphp 🐘Ryan Chandler @ryangjchandler
7K Followers 374 Following Software Developer. Mostly PHP, but also Rust, Go and some others. → Developing https://t.co/D37YU2sn79. → Teaching https://t.co/R2q7KrK6enfinal readonly Mr. Ni.. @ninjaparade
5K Followers 572 Following Building https://t.co/IDX62Hly9o and talking mobile app development and API’s at https://t.co/Yfa1hsiGSyDan Harrin 🦒 @danjharrin
9K Followers 253 Following Lead developer at @kirschbaum_dev. Building @filamentphp to boost your Laravel productivity beyond what you thought was possible 🤘Matt Kingshott @mattkingshott
9K Followers 36 Following Entrepreneur, software developer, open-source enthusiast & content creator.James Brooks @jbrooksuk
15K Followers 491 Following Software Engineer @laravelphp • Speaker • Founder of @cachethq • Organiser of @phpstoke • Podcaster @happydevfmAsh Allen 🚀 @AshAllenDesign
7K Followers 568 Following 🚀 Freelance Laravel Web Developer and Blogger ⚡https://t.co/Pyl3pXj1Wf 🔥 https://t.co/cvwYTPJzbpCode With Dary @codewithdary
6K Followers 161 Following I am a developer who creates content and writes code. My tweets focus on web development, personal growth, and the experiences of being a developerLinus Benkner - linu... @LinusBenkner
3 Followers 60 Following Developer, love to build things with #php and #laravel 👨💻 Sometimes writing about tech-stuff on my blog https://t.co/1weFjln34Z ✍️Mos Def @MosDef2017
94 Followers 1K Followingjizabel @cwithme0
157 Followers 407 Followingquantumweb @quantumwebco
2 Followers 182 FollowingOng @OngDevLab
12K Followers 11K Following Developer, Data Scientist, TikToker with 2,000,000+ followers and now having fun with Twitter (10k) and YouTube (81) and Six Pack Status: Currently in StealthHlucas @Htchedem
32 Followers 119 FollowingRumman Akter @RummanAkter55
9 Followers 256 Following wordpress l wordpress theme customization l web designKevin Versteeg @FlyingThunder
6 Followers 112 FollowingMariosmm @Mariosmmcom
1K Followers 316 Following Get Your Social Account's Followers And Likes At One Place, InstantlySantiago Afonso @SantiagoAfonso
1K Followers 758 FollowingJordan Deroubaix @jordanderoubaix
39 Followers 228 Following Application Developer, SharePoint, Nintex, WebVue Factory @vuefactory_io
71 Followers 463 Following Vue Factory: We connect you with top Vue Developers worldwideSergio GCLP @Sergio_GCLP
589 Followers 2K Following Apasionado de la tecnología, inquieto, espacio y aerotrastorno severos. Piloto Privado sacado en @Canaviapilotos. Spotter aficionado a ratos 🛩️📷🔭粟橘sunjon @sunjon52923788
0 Followers 23 FollowingPage Fault @unnovemberable
1 Followers 102 FollowingMilroy Fraser @milroyfraser
254 Followers 585 Following Developing the new digital dawn @WalkerDunlop, ex-@Temper_works. In my spare time, scripting tech symphony @echonomousrastapopoulix @rastapopoulix
129 Followers 4K FollowingSohaib Ahmed @SohaibA09569133
0 Followers 401 FollowingSandeep Solanki @_sandip_solanki
74 Followers 526 Following Full Stack Web Dev | Passionate about building beautiful & functional web experiences. Always learning, always growing. #WebDev #LifelongLearnerRami @ramijames
110 Followers 489 Following 🛠 Free web tools: https://t.co/2eDDLe5zDt 📖 Writing: https://t.co/Q2vWS83C3KChuangcius @chuangcius
14 Followers 16 FollowingCarlos CN @carllosnc
12 Followers 471 FollowingTúndé James @TundeJames_20
627 Followers 726 FollowingJaap de Vries @jaapdevries
88 Followers 246 FollowingBantu Knight @Bantu_Knight
69 Followers 528 FollowingNerou119 @ethernalz112
36 Followers 191 Followingsnt @zanaissant
3 Followers 163 FollowingDuyen V. Mai @_negordyh_
7 Followers 140 Following 'But only dead fish go with the flow!' - Salmon thought, swam away.Mike Kelly @mikecodemonkey
2K Followers 2K Following CTO of MemberVault. Grumpy old PHP developer with an unhealthy obsession with coding, dad jokes, and Linux. https://t.co/vMGPI6QlYIPraktic @praktic326
420 Followers 764 Following Technical Business Systems Analyst 💻 Film/TV, Anime, and Gaming Enthusiast 🎮 Variety Streamer (sometimes) 🖥 https://t.co/EIBxK5x746Ahmed @ahmedsa63291688
12 Followers 356 FollowingAchraf HEBBOUL🔻 @hebboul_achraf
211 Followers 671 Following + Symfony/Laravel - React/React Native Developer + Open Source Project Enthusiast!Tanel Poder Consultin.. @TanelPoder
10K Followers 1K Following A long time computer performance geek. Fast cars, faster computers! Consulting: https://t.co/baainPylp3 Training: https://t.co/4AQUBjcAX9Baccar Mourad @bcr_mourad
17 Followers 288 FollowingNuno Maduro @enunomaduro
52K Followers 210 Following @laravelphp core member — created @pestphp, @laravelzero, collision, larastan, pint, @openai for php, @phpinsights, termwind, and more. All views are my own.Freek Van der Herten .. @freekmurze
59K Followers 522 Following PHP developer at @spatie_be, built @getmailcoach, https://t.co/IRUtuG0FwZ, @ohdearapp and @flareappio, blogging at https://t.co/a3spVy88VN, organising @fullstackeuAdam Wathan @adamwathan
210K Followers 735 Following Creator of @tailwindcss. Listener of Slayer. Austin 3:16.Marcel Pociot 🧪 @marcelpociot
57K Followers 741 Following Building Laravel Herd, https://t.co/8HwtSFyXJM , https://t.co/vuTdNhyRXo, NativePHP, and other tools for devs. Follow my product dev journey. CTO at @beyondcodeAaron Francis @aarondfrancis
32K Followers 1K Following Co-founder https://t.co/oUwfiB6Kqj. Sincere poster. No cynicism. Dad to two sets of twins! Cohost @MostlyTechPod. Teacher https://t.co/m4dvIEs302.Christoph Rumpel 🤠 @christophrumpel
20K Followers 612 Following Father 👨👩👧 Working at @laravelphp PHP Developer & Educator https://t.co/5JRGkGBni5Jonathan Reinink @reinink
36K Followers 484 Following 👨💻 Hacking at @tailwindlabs. 🎨 Helped Adam build @tailwindcss. ⏩ Created @inertiajs. 😍 Fan of @laravelphp. ❤️ Father and husband. 🙏 Follower of Christ.Dries Vints @driesvints
28K Followers 191 Following 👨🚀 @laravelphp Core Team • 💻 Building @eventyio & @laravelio • ⭐️ @github Star • 💸 @stripe Community ExpertPhilo Hermans @Philo01
10K Followers 206 Following Tweeting about Laravel, Livewire, Shopify Apps, SaaS, and my journey towards adding 50K MRR in 2024. Projects 👉🏻 https://t.co/EvZrBKrpjhLaravel News @laravelnews
102K Followers 60 Following Your news source for the Laravel PHP Framework. Email us at [email protected]Matt Stauffer @stauffermatt
33K Followers 415 Following CEO @tightenco: @laravelphp and more w/some of the best devs alive. Host @LaravelPodcast. "Worst twerker ever, best Dad ever" –My daughter 💍 @ImaniVJonesTim MacDonald @timacdonald87
9K Followers 167 Following Big fan of doggos and brunch ☀️ Hypermedia link and form enthusiast 🕸️ Core developer at @laravelphp 🐘Ryan Chandler @ryangjchandler
7K Followers 374 Following Software Developer. Mostly PHP, but also Rust, Go and some others. → Developing https://t.co/D37YU2sn79. → Teaching https://t.co/R2q7KrK6enJason McCreary @gonedark
15K Followers 72 Following I’m JMac. I build things with my hands like @laravelshift, https://t.co/4NmhaccU6f, https://t.co/KSW6jSIOFD, and my standing desk.final readonly Mr. Ni.. @ninjaparade
5K Followers 572 Following Building https://t.co/IDX62Hly9o and talking mobile app development and API’s at https://t.co/Yfa1hsiGSyDan Harrin 🦒 @danjharrin
9K Followers 253 Following Lead developer at @kirschbaum_dev. Building @filamentphp to boost your Laravel productivity beyond what you thought was possible 🤘Inertia.js @inertiajs
17K Followers 95 Following Quickly build modern single-page React, Vue and Svelte apps using classic server-side routing and controllers. Created by @reinink and @claudiodekker.James Brooks @jbrooksuk
15K Followers 491 Following Software Engineer @laravelphp • Speaker • Founder of @cachethq • Organiser of @phpstoke • Podcaster @happydevfmBernhard Kraemer @bernhardkraemer
409 Followers 1K Following 🌅 Senior Webdeveloper @GetMyInvoices, https://t.co/n4G1LPuZlt (@fino_run) 🌇 Freelance Backend-Developer 💻 #PHP, #Laravel and #CleanCode 😍 🏡 Dietramszell / HolzkirchenHarry's Marketing Exa.. @GoodMarketingHQ
160K Followers 32 Following The home of short, sweet, practical marketing. https://t.co/AFJERNEyitMichael Dyrynda @michaeldyrynda
11K Followers 215 Following Dad. @laravelphp Artisan. @LaraconAU organiser. Co-host of @northsouthaudio, @laravelnews, @ripplesfm. Opinions are mine.Patricio @PatricioOnCode
2K Followers 725 Following Blogging, Streaming Co-building @VoxPopSites Sharing my passions about Web Development Laravel, Livewire, Filament, JavaScript, Docker, Self-Hostingnanda @nandafyi
11K Followers 327 Following i write about computers and stuff @ https://t.co/z75WgBGhPdAntoine Minoux @AntoineMinoux
2K Followers 1K Following Software designer with 2x bootstrapped SaaS exits, building the customer support tool for modern SaaS @getfernand + better email routing @improvmx ($25k MRR).Built for Mars @builtformars
5K Followers 1 Following Making it easy to learn UX superpowers ⚡️. Built by @PeteRamsey.Florin Pop 👨🏻�.. @florinpop1705
183K Followers 2K Following Helping developers learn faster @iCodeThis - 💻 YouTube: https://t.co/YagJ7dzAXE - 2nd Channel: https://t.co/oPvxX6f8DPIlias Ism @illyism
7K Followers 847 Following The SEO agency she told you not to worry about: https://t.co/83TX8QdoYeLukas Hermann @_lhermann
10K Followers 925 Following B2B SaaS Guy ☞ Building @stagetimerio & https://t.co/fUefoxobfT ☞ Bootstrapping to $1M ARR → Then $100M ARR → Then Moonshot Project ☞ I don't like timezonesOllie 🛹 @BuildWithOllie
1K Followers 2 Following The next big thing in WordPress. Launch blazing-fast, pixel-perfect websites with the Ollie block theme. Built by @mikemcalister and @patrickposner_.Guilherme 📈 @goenning
3K Followers 218 Following I quit my 6-figures dev job to bootstrap products that people love 📈 https://t.co/ZgZ5LW7seI ☸️ https://t.co/DCi5jAG8rbBen Johnson @benbjohnson
13K Followers 32 Following Working on LiteFS & Litestream at @flydotio to help developers run SQLite in production and at scale.Bartosz Ciechanowski @BCiechanowski
20K Followers 70 FollowingJointJS @jointjs
357 Followers 107 Following JavaScript diagramming library powering exceptional UIsMark Raasveldt @mraasveldt
800 Followers 66 FollowingSam Rose @samwhoo
5K Followers 946 Following Writing visual guides to programming concepts at https://t.co/IbaGdm3TrO. Mastodon: @[email protected]Julien Bourdeau @julienbourdeau
1K Followers 883 Following 🛠 Sr. Software Engineer @GetLago. Ex-@Algolia 👨🎨 Ruby on Rails by day, Laravel by night. 📧 [email protected]Philippe Noël @philippemnoel
1K Followers 208 Following Postgres for Search & Analytics @ParadeDB • H'20 • 🇫🇷🇨🇦 • prev @WhistHQ @MicrosoftDaniel Coulbourne @DCoulbourne
5K Followers 2K Following Running https://t.co/rzaguKLJG3 ❤️ Building for Clients using the TALL stack ❤️ Podcasting @noplanstomergeRob Walling @robwalling
34K Followers 931 Following Helping SaaS bootstrappers via @startupspod. Connecting founders around the world through @microconf. Wrote the playbook for SaaS, https://t.co/FfaUnyJj5N.Peter Ramsey @PeteRamsey
4K Followers 18 Following Helping people build better products. Founder @BuiltforMars, EIR @Creandum.✌️Ryan Law @thinking_slow
12K Followers 998 Following Director of Content Marketing @Ahrefs • I tweet about writing, SEO & marketing • Solving the hard parts of content marketing: https://t.co/VCUFhtFJaPDelba @delba_oliveira
29K Followers 480 Following DX @nextjs at @vercel ▲ I build apps, write docs, and create videos about Next.js and React.Josh W. Comeau @JoshWComeau
127K Followers 2K Following Indie hacker and educator. Blogging at https://t.co/kbdJDUdLg5. Previously @gatsbyjs, @digitalocean, @concordia_btcmp, @khanacademy. He/Him 🌈sqlfiddle @sqlfiddle
456 Followers 76 Following SQL Fiddle - Online SQL Compiler for learning & practiceAdam @adamdotdev
23K Followers 888 Following AWS Hero and co-founder @statmuse. Teaching AWS to web developers at https://t.co/46iIRDlh0L. Talking to Dax at https://t.co/C0D6RC2qWb. Chief Barista @terminaldotshop.Steve Tenuto @steve_tenuto
2K Followers 675 Following Co-founder @ https://t.co/U8NQ5tMIZq Technical video producerLianna Patch @punchlinecopy
7K Followers 2K Following funny copy that converts for #DTC + #saas at https://t.co/lPmnafu3ey || helping your pets live longer and happier lives at https://t.co/VRQXQ7OgvrViktor Hesselbom 🧑.. @hesselbom
2K Followers 640 Following Building Apple Watch apps as a side hustle and tweeting about it! Currently @watchletic, a running and cycling app 🏃♀️Jack McDade @jackmcdade
12K Followers 327 Following Teaching people how to design, stand out, and fall in love with whimsy at https://t.co/2lHthPYcXJ. Creator of @statamic.Indexing Beyond the B.. @IndexingBook
713 Followers 1 Following I repeatedly see the same misconceptions and need for practical knowledge about indexes. You only find introductory stuff but nothing for real applications.Jack Douglas @JackDouglasMCC
74 Followers 71 Following Trustee of Maidenhead Community Centre and Liberal Democrat Councillor for St Mary's WardSam Carré 🤠 @carre_sam
2K Followers 434 Following I love building tools that help the PHP community. Space Cowboy 🤠🪐 Currently working on Saloon 🍻Ruslan Steiger @ruslansteiger
598 Followers 146 Following 🪷 Positive Role Model 🇨🇭 Laravel Switzerland Meetup OrganizerShruti Balasa @shrutibalasa
35K Followers 1K Following Tech Educator - Creating courses, eBooks, YT videos and living the life of my dreams! Subscribe at https://t.co/cYFniDoaS1 | Building @voxpopsitesJustin Jackson @mijustin
40K Followers 1K Following ⚡ Bootstrapping, podcasting, calm companies, business ethics. Co-founder of @transistorfm (podcast hosting).OtterTune @OtterTuneAI
3K Followers 229 Following Automatically improve your Amazon RDS and Aurora MySQL and PostgreSQL database efficiency & performance.joetannenbaum @joetannenbaum
2K Followers 696 Following Full stack developer focused on Laravel/Inertia.js/PHP/Vue/React. 👨💻 ssh https://t.co/g8wHZbkoKR ✏️ https://t.co/3Fhk4TRSR4 💨 https://t.co/Tgp2exhtdoPinal Dave @pinaldave
28K Followers 472 Following I am SQL Server Performance Tuning Expert at @SQLAuthorityFull Stack Europe @FullStackEU
3K Followers 150 Following "It takes a village to raise an app" A conference for full stack developers and full circle teams. #fseu23 🗓️ Oct 18-20 2023Fabrizio Bianchi @_fbrz
9K Followers 637 Following 10+ years of solo development. Spacebars destroyer. Working from my Tesla. 🌈 https://t.co/ucuLm3BlAs (5M+ users) 🌸 https://t.co/OtN1dbmSTh 💬 https://t.co/TjJwsCvykV 🤖 https://t.co/BaNCXyLHZv@tobias_petry @IndexingBook My question is always, do you combine the 2 columns In one index, or index then separately?
@tobias_petry I’ve happily made the switch. There are some areas where catchup is needed. Like I don’t have a great online schema change tool just yet. And I’d love something like ProxySQL and Vitess, but I’m having a good ti with the PG crowd
@tobias_petry used to be die hard mysql fan. then i made a mistake. I tried postgres..... i will leave it there.
@tobias_petry I migrated my erp project from MySQL to PostgreSQL because of a performance issue. Simple group by query of thousands of records by user_id took ~30sec in MySQL but milliseconds in PostgreSQL.
@tobias_petry @adilshahzad MySQL is not standing still.. just maybe running in the wrong direction
@tobias_petry @valorin You can limit HTTP methods at the web server level too. It's really easy to do in NGINX eg: location /api/admin { limit_except GET POST PUT DELETE { deny all; } .... location /api/public { limit_except GET { deny all; } ....
@tobias_petry I like reading texts, but In my case with reality tight family life I only have really small time gaps across the day so if text (or video) is long most likely won't be able to finish it. 😞🤷🏻♂️
@tobias_petry I wasn't aware of this, mainly because I've always worked with MySQL primarily. A really nice piece of information. Thanks Tobias. And also, nice images, making the tweets to look really elaborated. 😉
This is a meme @aarondfrancis & @tobias_petry would love ... #GeekCred #DatabaseHumor
This is an awesome tip, especially the MySQL part - filing here for use later for performance improvements #DatabaseDesign #PartialIndex
Indexes make database queries faster. Easy thing. But did you know you can create an index only on the rows you are searching for? 👇 Learn about partial/filtered indexes in two minutes
@tobias_petry For systems that support soft deletes via a deleted=0 / 1 value, does it make sense to have most indexes be partial indexes for WHERE deleted=0? Of does it make sense only if there's a certain percentage of deleted records to make this effective?
curl is software written by a European who can’t even enter in the US… x.com/bagder/status/…
san francisco literally has curl commands as ads and europe will unironically think they can compete with us
People who use your product will never interact with your fancy and super polished design system, or your auto layouts, your smart UI components…
That itch to teach entrepreneurship and share advice once you reach $103 MRR.
@ModestasMV The great thing with static analysis is that your tests can focus on real behavior testing instead of simple/stupid return 200 OK response. As the static analysis already tells you that your code is executable.
@tobias_petry Liked this tweet to showcase some humanity here left
@tobias_petry I made this new account a few months ago. I’ve hardly posted much (I’m guilty for being a scroller and not engaging in conversation) but I have 28 followers, 4 people are real the others are the same as you 🥴