Jonas Staudenmeir @staudenmeir profile

Jonas Staudenmeir

@staudenmeir

Followers

1,530

Following

95

Media

0

Statuses

43

Backend Developer: PHP, MySQL, Laravel | @laravelphp Core Contributor | @staudenmeir @phpc .social

https://t.co/ROIp7GFwSF

Munich, Germany

Joined September 2015

Don't wanna be here? Send us removal request.

Explore tweets Explore followers Explore following

Explore trending content on Musk Viewer

Drake • 1944526 Tweets

Kendrick • 1763353 Tweets

Lando • 468609 Tweets

LISA TEAM REDBULL • 446551 Tweets

#GranHermano • 240064 Tweets

GW最終日 • 205483 Tweets

Furia • 184850 Tweets

Menotti • 150545 Tweets

Stars • 141326 Tweets

MARTIN AL 9009 • 126634 Tweets

McLaren • 102404 Tweets

Drizzy • 100470 Tweets

Mauro • 97710 Tweets

連休最終日 • 68431 Tweets

Bahia • 66528 Tweets

Panamá • 65934 Tweets

Mulino • 55595 Tweets

FEDERICO • 42215 Tweets

ゴールデンウィーク最終日 • 41439 Tweets

Juliana • 35503 Tweets

#この漫画知っている人で100いいね • 31650 Tweets

Tom Brady • 23234 Tweets

Whitney • 21488 Tweets

TERROR COM A ANA • 19657 Tweets

Lombana • 16839 Tweets

Larson • 14401 Tweets

Del Moro • 13070 Tweets

ゴムの日 • 11215 Tweets

#NASCAR • 10240 Tweets

SE VAN A IR DE A UNO

Julian Edelman

Ron Burgundy

ANA POSTA A FOTO

トリグリさん

Mark Stone

Maria Solange

Brunão

Jeff Ross

Kevin Hart

Drew Bledsoe

Nikki Glaser

にこにこぷん

Buescher

Bill Belichick

Mother I Sober

LTIR

Rial

Gronk

#Fantastico

#TexasHockey

Last Seen Profiles

@boh_hem

@3rdEyeCat

@MattZss9

@miyuu_baystars

@DrKrych

@SCOTT74J

@G35_Polo

@OhioDawgsYA

@gdyniaerobaltic

@ArchieCarruthe1

@oc6148905

@Vvsflee

@EarDrummerSport

@amitlavi

@m_mikuru_m

@yamuva10

@FlygonHG

@JOSSEPatricia

@HexgamerT

@Ne7na_Magazine

Jonas Staudenmeir

@staudenmeir

4 years

I've released a big update for the adjacency list package with new relations, scopes, custom paths, and performance improvements:

Release v1.5 · staudenmeir/laravel-adjacency-list

Adds HasManyOfDescendants and RootAncestor relations. Adds treeOf() scope. Adds maximum depth parameter to tree scopes. Adds custom paths.

github.com

3

7

40

Jonas Staudenmeir

@staudenmeir

4 months

@taylorotwell @definients

[11.x] Support eager loading with limit by staudenmeir · Pull Request #49695 · laravel/framework

As discussed: A new version of #26035 that integrates the eloquent-eager-limit package. Support for MySQL 5.7 According to the current docs, Laravel 11 won't support MySQL 5.7 anymore. I still ...

github.com

3

0

32

Jonas Staudenmeir

@staudenmeir

5 years

All my packages now support Laravel 6.

2

22

Jonas Staudenmeir

@staudenmeir

4 years

All my packages now support Laravel 7.

1

21

Jonas Staudenmeir

@staudenmeir

4 years

If you are using the JSON relations package on PostgreSQL, you can improve the query performance with GIN indexes: Thanks to @MaxMatteo2 for the suggestion.

GitHub - staudenmeir/eloquent-json-relations: Laravel Eloquent relationships with JSON keys

Laravel Eloquent relationships with JSON keys. Contribute to staudenmeir/eloquent-json-relations development by creating an account on GitHub.

github.com

0

2

15

Jonas Staudenmeir

@staudenmeir

3 years

@tobias_petry Thanks! I thought you had maybe seen some sample benchmarks.

0

3

Jonas Staudenmeir

@staudenmeir

5 years

@timacdonald87 It was a pleasure working with you on this! Here we go:

[5.8] Add whereHasMorph() by staudenmeir · Pull Request #28928 · laravel/framework

Due to the nature of polymorphism, whereHas() doesn't work with MorphTo relationships (#5429, #18523). As a solution, @timacdonald and I are proposing whereHasMorph() and the corresponding meth...

github.com

1

0

3

Jonas Staudenmeir

@staudenmeir

3 years

@tobias_petry Do you know how the query performance typically compares to adjacency lists with parent_id and recursive CTEs?

1

0

3

Jonas Staudenmeir

@staudenmeir

5 years

@AnkurK91 @znck0 is the package I took over from Rahul, not this one ;-)

GitHub - staudenmeir/belongs-to-through: Laravel Eloquent BelongsToThrough relationships

Laravel Eloquent BelongsToThrough relationships. Contribute to staudenmeir/belongs-to-through development by creating an account on GitHub.

github.com

0

2

Jonas Staudenmeir

@staudenmeir

5 years

@LindkjR @marcelpociot @laravelphp Laravel does wrap migrations in transactions, but only PostgreSQL and SQL Server support that. MySQL can't roll back data definition language (DDL) statements.

0

2

Jonas Staudenmeir

@staudenmeir

1 year

@hazj95 Do you mean to get a specific level/depth of ancestors/descendants?

1

0

2

Jonas Staudenmeir

@staudenmeir

3 months

@tobias_petry @jerodev @LaraconEU I wrote the implementation back in 2018 and AFAIR, that was the only method that worked for all DBMS. Of course, the query could also be made DBMS-specific.

1

0

2

Jonas Staudenmeir

@staudenmeir

5 years

@rodrigopedra @taylorotwell

0

2

Jonas Staudenmeir

@staudenmeir

5 years

@Bellal__Mohamed Laravel 5.8.27 adds whereHasMorph():

[5.8] Add whereHasMorph() by staudenmeir · Pull Request #28928 · laravel/framework

Due to the nature of polymorphism, whereHas() doesn't work with MorphTo relationships (#5429, #18523). As a solution, @timacdonald and I are proposing whereHasMorph() and the corresponding meth...

github.com

0

2

Jonas Staudenmeir

@staudenmeir

1 year

@hazj95 The depth is positive for descendants and negative for ancestors.

1

0

2

Jonas Staudenmeir

@staudenmeir

1 year

@hazj95 You can use whereDepth() for that:

1

0

2

Jonas Staudenmeir

@staudenmeir

2 years

@hazj95 You can only do that manually at the moment: Loop over $ancestors and reverse every custom path with explode() -> reverse() -> implode(). I have thought about adding an option for that to getCustomPaths(), I'll look into it.

1

0

1

Jonas Staudenmeir

@staudenmeir

5 years

@adamwathan The package now supports Laravel 6.

1

0

1

Jonas Staudenmeir

@staudenmeir