Недавно втянулся в использование 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

Sakura hira hira maiorite ochite
Haru no sono mukou e to aruki dasu
Kimi to haru ni chikai shi kono yume wo
Tsuyoku mune ni daite
Sakura maichiru

https://www.youtube.com/watch?v=CAwE9LVpdao

08/11/2018

Sakura

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

Sakura

IDENTIFICATOR