RE: https://scicomm.xyz/@dantheclamman/116196703399022292

How do #animals #aggregate?#Mites can find each other based on #pheromones, while #sight is important for herd-forming #mammals. In #marine #habitats, #hearing plays a major role. D.McAfee et al.(2022) showed that #oyster #larvae react to the #soundscape of a healthy #reef via #statocysts in front of their bodies, thus finding their adult conspecifics for #reefformation. Reef formation can be artificially #stimulated via artificial #soundwaves.
©#StefanFWirth 2026
Ref
https://doi.org/10.1111/1365-2664.14307

COUNT(*) vs COUNT(column) Are DIFFERENT?!

COUNT(*) and COUNT(column) behave completely differently with NULLs! One counts NULLs, one doesn't. This breaks aggregate logic! Watch!

#sql #sqltricks #database #sqltutorial #count #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

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

SUM - AVG With Zero Rows Returns WHAT?!

Aggregate functions with zero rows return NULL, not zero! SUM of nothing is NULL, not 0. This breaks aggregate logic! Watch!

#sql #sqltricks #database #sqltutorial #aggregate #zerorows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #aggregatefunctions #sqlwtf

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

SUM Of Empty Set Returns WHAT?!

SUM of an empty set or all NULLs returns something unexpected! This breaks all math assumptions. Your mind will explode! Watch now!

#sql #sqltricks #database #sqltutorial #sum #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

https://www.youtube.com/watch?v=Z-94Yr5vElY

AVG Ignores NULL Values?!

AVG function silently ignores NULL values! This creates averages that are mathematically wrong. This breaks financial calculations! Watch!

#sql #sqltricks #database #sqltutorial #avg #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

https://www.youtube.com/watch?v=5tbIlazlcGI

RE: https://flipboard.com/@sciencealert/tech-u63nordnz/-/a-f8sUa-yQR3OxoNHOSmElaA%3Aa%3A565656366-%2F0

The #components needed to give a device the properties of a #computer have become increasingly smaller. M. M. Lassiter et al. (2025) designed the #smallest #microrobot to date, measuring just 200 by 300 μm wide and 50 μm thick. It can #aggregate, #communicate, #sense, and #move via #electricalfields inside #fluids. There are interesting applied options for using such a robot in e.g. medical contexts.
© this text StefanFWirth Berlin 2025

Ref:
M. M. Lassiter et al. (2025)
https://doi.org/10.1126/scirobotics.adu8009

MAX - MIN With All NULLs Returns WHAT?!

MAX and MIN with all NULL values return something impossible! These functions are supposed to find extremes but what about NULLs? Watch!

#sql #sqltricks #database #sqltutorial #maxmin #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

https://www.youtube.com/watch?v=8o4s0DK1sNM

🚀 Excited for next week’s EventCentric conference!
I’ll be sharing insights on Wix’s innovative, non-traditional event-driven architecture. Stay tuned for some surprising architectural decisions and real-world examples!
Don’t miss it! 🔥

#EventCentric #DDD #IntegrationEvents #EventDriven #Microservices #Aggregate