Недавно втянулся в использование SQL синтаксиса LEFT JOIN LATERAL. Буквально по-другому стал смотреть на решение некоторых задач!

Проверил по документации, погугил, в популярных PHP ORM – нигде нет поддержки LATERAL, ни в Doctrine, ни в Laravel Query Builder, ни в Yii Query Builder, ни в Cycle ORM.

тут хочу дать пояснение, моё отношение к различным Query Builder и обёрткам над SQL синтаксисом. Вот какой подход я применяю при выборе между написанием простого SQL и использованием Query Builder или ORM...

В дополнение к подкасту ссылка на презентацию Валентина Удальцова с PHP Russia 2021: https://phprussia.ru/moscow/2021/abstracts/7654

Пятиминутка PHP - подкаст о PHP, DBA, архитектуре, DevOps. Авторское мнение о современных трендах в веб-разработке и интересные беседы с гостями. https://5minphp.ru

Пятиминутка PHP

Чистый SQL или ORM и Query Builder?

site

First Fantasy

Join XLS for 2 hours of the best techno, trance and hard trance around!

| The Hyper Reality Radio show airs on the 1st and 3rd Thursday of each month on DI.FM/harddance |

01. Thomas Schumacher - Interlinked (Original Mix)
02. Jay Lumen - Human (Original Mix)
03. Ramon Tapia - Morphing (Extended Version)
04. Sam Paganini - Rave (Adam Beyer & Layton Giordani Remix)
05. Roy De Best & The Scientist - Gaan! (Evanti Remix)
06. Kai Tracid, A*S*Y*S, Tom Wax - Freedom of Expression (Dark Acid Mix)
07. Marie Vaunt, Gizmo & Mac - Pulse (Marie Vaunt Remix)
08. Margo & Pam - Revolution (Original Mix)
09. May-i - Can't Take Me (Original Mix)
10. Smith & Brown - Supercell (Extended Mix)
11. Enrico Sangiuliano - Future Dust (Original Mix)
12. John Askew - Future Dust (Original Mix)
13. Dmitry Chelnokov & Damian Wasse - We Are Back (Extended Mix)
14. Caolan McConville - White Widow (Extended Mix)
15. Enerlift - Warfighter (Extended Mix)
16. Artena - Mercia (Extended Mix)
17. ID - ID
18. Stuarty Baillie - Quantum Leap (Original Mix)
19. Renegade System & Marty Cassidy - Escalate (Extended Mix)
20. C.O.L.D. - Klangwelten (Original Mix)
21. C.O.L.D. - Acid Storm (Original Mix) [Track of the Week]
22. J Rogers - Deranged (Original Mix)
23. Lee Greenaway & Jake Ayres - Psychedelic Drugs (TrickyDJ Remix)
24. Jody 6 - Funky Pills (Extended Mix)
25. H! Dude - Seduction (Original Mix)
26. Alignment - Dream State (Original Mix)
27. elMefti & Per Pleks - Techno On My Mind (Original Mix)
28. DJ Thera - Wasteland (DJ Thera 2022 Remix)

Hyper Reality Radio 183 – feat. XLS

Sad Boy

Sad Boy (feat. Nouveau Arcade)

Highfish mix

1. Ginchy x Johan Gielen - Loops N Tings Extended
2. Avalynn - Dirty Little Secret (Original Mix) [Dauntless Digital Black]
3. Mindflux & Glojin - Infiltrate My Mind (Original Mix) [Rebels Records] - soon
4. JTB Live - Matrix (Extended mix) [HTE]
5. Hedonistik Ritual - Sunshine & Rainbows (Original mix) [Fatal Energy]
6. Lee Greenaway - Mankind (Dave Spinout & Trickydj rmx) [Dauntless Digital Black]
7. Jay Turio-Big Foot (Original Mix) [Dauntless Digital Black]
8. Mark EG & D-Willz - Let Me See You Dance (Original mix) [Fatal Energy]
9. Renegade System - Feelin' In Demand (Extended mix) [Outburst records]
10. Mindflux - Pushin' On (Original Mix) [Hard Trance Revolution]
11. Dean Zone & Galvatron - The Calling (Extended mix) [HTE]
12. Lab4 - Muzika Del Futuro (Extended mix) [HTE]

Trickydj Hard Trance Classics mix

1. Wragg & Log One - Creatures [Atmosphere]
2. Vandall - Agape [Trancewarez Recordings]
3. Green Court - Silent Heart, feat Lina Rafn (Flutlicht remix) [Club Culture]
4. Tommy Pulse - The Answer (DJ Holocaust Remix)
5. Dave Joy - Third Pleasure (Überdruck Remix) [Thrust Groove Records]
6. Deepforces - Last Wish (Original Mix) [Zooland Records]
7. Beam Vs. Cyrus - Thunder in Paradise (DJ Scot Project Remix) [Cyrus Trax]
8. Hennes & Cold - First Session [Tracid-Traxx]
9. DJ Ornator - Save Me (DJ Ornator club mix) [Lengo] 
10. Jones & Stephenson - The First Rebirth (Mic-E 2006 Rework) [Bonzai Classics]

Highfish Radio Show Mar 23 - TrickyDJ hard Trance Classics

Happy December! Here is episode 130. For this final episode of 2024 I decided to highlight some of my favorite tunes from all the EA episodes this year. Hope you enjoy these tracks as much as I have. Have a great holiday, a happy new year, and I'll see you in 2025!

Track List:
1. Will Dukster - Renegade (Phil Stringer Remix) [Addictive Sounds]
2. Tranzvission - Forbidden Memories (Extended Mix) [HTE Recordings]
3. Vangar - Mind Killer (Original Mix) [Dreamstate]
4. Christina Ashlee - Find A Way (Extended Mix) [Juiced Digital]
5. TrancEye - Good Morning Sunshine (Inrayzex Extended Remix) [Ablazing ReLaunch]
6. Kimi Ajid, TechWoot - Chaos Driving (Original Mix) [Radiation Recordings]
7. Mark Sherry - Space People (Systembreaker Extended Remix) [Outburst Records]
8. I.M.XPLODE - Lukewarm Iced Tea (Original Mix) [Radiation Recordings]
9. May-i - Schwarze Katze (Extended Mix) [Techburst Records]
10. Phase 303 - Toxic Slush (Extended Mix) [Rated Records]
11. Jackob Roenald - Rage Curse (Extended Mix) [High Voltage Recordings]
12. Indecent Noise - JK is Dead (Extended Mix) [Mental Asylum Records]
13. M.Smith - Drink, Pills & Kiss (I-K-O Remix) [LW Recordings]
14. Reinier Zonneveld, T78, MOTVS - Who is Batman? (Original Mix) [Filth on Acid]
15. Sam Dillon - Scary Dreams (Original Mix) [CM21 Recordings]
16. Alex Di Stefano - Pinnacle (Original Mix) [Drum Chapel]

Electronic Agenda 130

Christina Ashlee - Electronic Agenda 130 (DIFM) [2024-12-05]

BBP Powerhour Episode 5 - Hosted by soundcloud.com/BadboE - Guest Mix by soundcloud.com/Morongroover

Tracklist:
 
BadboE - BBP Showcase:
01 - BBP118 Calagad 13 - Think Positive - (Unreleased - Expected out in Jan 2016)
02 - BBP113 B-Side - Like This - (Unreleased - Expected out in Feb 2016)
03 - BBP106 BadboE - Eye of The Beholder - (Vinyl Only)
04 - BBP108 Arteo - Nobody Else 
05 - BBP114 Morlack - BBP114 - Gimme Some Love (Unreleased - Out Dec 12th 2015)
06 - BBP117 B-Side - Joy 
07 - BBP116 Phibes - Whos That 
08 - BBP113 TBJ vs DJP - Go Off - Expected out in Deb 2016
09 - BBP103 Father Funk - Golden Era 
10 - BBP103 Timothy Wisdom - Bad Mother Mix 
11 - BBP080 BadboE - Introducing (Kool Hertz Remix) 
12 - BBP112 Mr Bristow feat. Phil Ramocon - Drunk On Funk (Original Mix) 
13 - BBP109 Mako & Mr Bristow - Funk 'Em I'm No Good
14 - BBP092 Nynfus Corporation - The Beat Goes (Vinyl Only)
15 - BBP115 Jayl Funk feat. Tarzan Bros - Shake it 
16 - BBP096 PulpFusion & Morris Chestnut - Feelin The Blues Mix (Vinyl Only)
17 - Arteo - Time & Place (Original Mix) [BBP Free Download] 

Morongroover Guest Mix:

18 -  Featurecast & The Gaff - Ain't Got Time
19 - GRiZ - The Anthem
20 - Dr Dre & Snoop Dog - Nuthin but a G Thang (Bruno Borlone & Boogie Mike remix)
21 - Shaka Loves You - A+ Enjoy Yourself (SLY Edit)
22 - Morongroover - Fairy Tales
23 - Bondi Stereo - Funky Styles
24 - Ewan Hoozami - Can't Help It
25 - Zak Abel - Running From Myself
26 - Mr Stabalina - Money
27 - Chudy - Won't Stop Trying
28 - Slim & Slam - Boot-ta-la-za (JPOD remix)
29 - Morongroover - Good Old Days
30 - Def Cut - More Power
31 - Mako & The Hawk - Party Goin' On
32 - Morongroover - Get On Up

DOWNLOAD/SUBSCRIBE

BBP Powerhour EP005 - Hosted by Badboe - Guestmix by Morongroover

Recorded live from the Fractal Forest, Shambhala Festival 2019 Salmo B.C Canada.

Free Download

A.Skillz Shambhala Mix 2019 (Live from the fractal forest)

The track is dedicated to the great China and its culture!
Official video: https://www.youtube.com/watch?v=Ot1d2GYJ680

Hei Foon Nei

Piem & Richard Ulh - Joking Around is out now!

Hei Foon Nei

IDENTIFICATOR