#aggregate — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #aggregate, aggregated by home.social.
-
https://www.fogolf.com/1257775/what-is-the-pga-championship-playoff-format-at-aronimink/ What is the PGA Championship playoff format at Aronimink? #aggregate #aronimink #BobMay #MarisaMarcellino #PGAChampionship #PgaOfAmerica #SuddenDeath #SuddenDeathPlayoff #TigerWoods
-
https://www.fogolf.com/1257775/what-is-the-pga-championship-playoff-format-at-aronimink/ What is the PGA Championship playoff format at Aronimink? #aggregate #aronimink #BobMay #MarisaMarcellino #PGAChampionship #PgaOfAmerica #SuddenDeath #SuddenDeathPlayoff #TigerWoods
-
https://www.europesays.com/people/48549/ What score did Macron predict while believing in PSG’s victory? – Zamin.uz, 29.04.2026 #about #aggregate #Ahead #Bayern #Center #Champions #clash #defeated #EmmanuelMacron #european #First #League #level #macron #match #Munich #paris #semifinal #teams #victory #which
-
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 -
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 -
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 -
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 -
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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 2025Ref:
M. M. Lassiter et al. (2025)
https://doi.org/10.1126/scirobotics.adu8009 -
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 2025Ref:
M. M. Lassiter et al. (2025)
https://doi.org/10.1126/scirobotics.adu8009 -
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 2025Ref:
M. M. Lassiter et al. (2025)
https://doi.org/10.1126/scirobotics.adu8009 -
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 2025Ref:
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
-
🚀 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
-
🚀 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
-
🚀 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
-
🚀 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
-
🚀 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
-
The #firebug #Pyrrhocoris apterus is widespread throughout much of #Palearctic. Adults and the five nymphal stages tend to #aggregate. They are #soildwellers and feed on plant #seeds, occasionally also on insect eggs. Some mite species can be on the bugs, with the #parasitic #mite #Hemipteroseius adleri being particularly specialized for it.
© #StefanFWirth #Berlin 2025
in my #YouTube video about a tree (2025)
https://youtu.be/wZqDuEFu8Nk?si=0HLyBsc4VjzGKvokP. apterus Bln, 2020, new edit 2025 © S. F. Wirth
-
Understanding Aggregate Trends for Apple Intelligence Using Differential Privacy
https://machinelearning.apple.com/research/differential-privacy-aggregate-trends
#HackerNews #Understanding #Aggregate #Trends #for #Apple #Intelligence #Using #Differential #Privacy
aggregate #trends #apple #intelligence #differential #privacy #machine #learning
-
Understanding Aggregate Trends for Apple Intelligence Using Differential Privacy
https://machinelearning.apple.com/research/differential-privacy-aggregate-trends
#HackerNews #Understanding #Aggregate #Trends #for #Apple #Intelligence #Using #Differential #Privacy
aggregate #trends #apple #intelligence #differential #privacy #machine #learning
-
Understanding Aggregate Trends for Apple Intelligence Using Differential Privacy
https://machinelearning.apple.com/research/differential-privacy-aggregate-trends
#HackerNews #Understanding #Aggregate #Trends #for #Apple #Intelligence #Using #Differential #Privacy
aggregate #trends #apple #intelligence #differential #privacy #machine #learning
-
Understanding Aggregate Trends for Apple Intelligence Using Differential Privacy
https://machinelearning.apple.com/research/differential-privacy-aggregate-trends
#HackerNews #Understanding #Aggregate #Trends #for #Apple #Intelligence #Using #Differential #Privacy
aggregate #trends #apple #intelligence #differential #privacy #machine #learning
-
Мой путь к быстрой и понятной архитектуре, или зачем я выбросил агрегаты из DDD?
Данная статья затрагивает некоторые аспекты при выборе подхода к проектированию предметной области для сложных корпоративных систем. В ней исследуются причины возникновения классических подходов и их анализ, для возможного улучшения. Это моя первая статья на данную тему. В начале хочется сказать, что предложенная концепция не пытается претендовать на роль какой-то панацеи и уж тем более на роль единственно верной, она так же имеет рад своих преимуществ и недостатков. Это скорее попытка переосмыслить опыт, который накопился у меня за несколько лет проектировании корпоративных систем. Материал изложен в виде вопросов и попыток на них ответить.
https://habr.com/ru/articles/876742/
#ddd #domaindriven_design #domain_model #repository #use_case #c# #net #services #aggregate #entity
-
An eye-openning talk by Mette Bendixen (Geography, #McGillUniversity ) on artisanal extraction of sand and gravel for concrete in the developing world.
Back breaking work, low pay, environmentally destructive and controlled by powerful syndicates.
Below is from Rwanda.#sand #aggregate #UrbanDevelopment #DevelopingNations #rivers
-
Attention-Worthy Links for November 29th, 2024
#Sulfur #Cooling #dimethyl sulphide #biofuels #aggregate environmental costs #Brazil #Vietnam #Drought #Robusta #Arabica #microplastics #Tires #28% #zinc oxide #6PPD #salmon #tidal power #Eco Wave #CO2 #mass extinctions #igneous #magma #CycloRotor #Voith Schneider propeller #Hailin impact crater #Northeast China ##West Iceland #Sundhnúkur #Grindavík #western Iceland ##San Geronimo III ##1541 #Sobaipuri O’odham #haakbus
-
Attention-Worthy Links for November 29th, 2024
#Sulfur #Cooling #dimethyl sulphide #biofuels #aggregate environmental costs #Brazil #Vietnam #Drought #Robusta #Arabica #microplastics #Tires #28% #zinc oxide #6PPD #salmon #tidal power #Eco Wave #CO2 #mass extinctions #igneous #magma #CycloRotor #Voith Schneider propeller #Hailin impact crater #Northeast China ##West Iceland #Sundhnúkur #Grindavík #western Iceland ##San Geronimo III ##1541 #Sobaipuri O’odham #haakbus
-
Enhancing Infrared Photodetectors with 2D Supramolecular Organic Frameworks
Researchers developed a composite optoelectronic device using 2D Supramolecular Organic Frameworks (SOFs) and lead salts, achieving high detectivity and stability
#chemistry #chemistryviews #chemviews #chemiverse #aggregate #materials #organicframeworks #optoelectronic
-
It's 2024 and still, no easy way to #aggregate your data from multiple #health and #fitness #sensors without relying on 3rd party proprietary solutions.
Imagine you've been saving your data for years but then your sensor needs to be replaced but the sensor is made by another manufacturer, a new data silo is formed because most companies force you to only use their solution or big tech sync.
#sustainability #degrowth #privacy
Here's a paper on the topic from 2018. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4704968/
-
Aggregate (geology) (Petrology 💎)
In the Earth sciences, aggregate has three possible meanings. In mineralogy and petrology, an aggregate is a mass of mineral crystals, mineraloid particles or rock particles. Examples are dolomite, which is an aggregate of crystals of the mineral dolomite, and rock gypsum, an aggregate of crystals of the mineral gypsum. Lapis lazuli is a type o...
https://en.wikipedia.org/wiki/Aggregate_(geology)
#Aggregate #Pedology #Petrology #Mineralogy #IndustrialMinerals
-
'Fat-Shattering Dimension of k-fold Aggregations', by Idan Attias, Aryeh Kontorovich.
http://jmlr.org/papers/v25/21-1193.html
#aggregations #aggregation #aggregate -
Nanoparticles with Ultrabright Aggregation-Induced Emission for Immunoassays:
Probe uses nanoparticles composed of polystyrene and a near-infrared (NIR) aggregation-induced emission luminogen (AIEgen)
#chemistry #chemistryviews #chemviews #chemiverse #research #aggregate #nanoparticles
-
How Do Organic Radicals Aggregate in Polar Fluorocarbon Solvents?
Aggregates of radicals that form intermolecular hydrogen bonds can accelerate catalysishttps://www.chemistryviews.org/how-do-organic-radicals-aggregate-in-polar-fluorocarbon-solvents/
@AggregateOA #chemistry #chemistryviews #chemviews #chemiverse #research #aggregate #organicchemistry
-
Пиррова победа Domain-Driven Design
TL;DR: DDD неизбежно ведёт к избыточному (на порядки больше минимально необходимого) количеству саг в проекте, которые, в свою очередь, неизбежно ведут к нарушению целостности данных в БД. DDD вполне успешно решает поставленную задачу: дать разработчикам инструменты, которые позволят им справится (корректно реализовать и поддерживать) со сложной предметной областью. Но эта победа оказалась пирровой: инструменты, обеспечивающие корректность данных в памяти , оказались неспособны гарантировать корректность данных в БД . А что толку от изначально корректных данных в памяти, если со временем (после их сохранения в БД и последующего чтения) они перестают быть корректными? По сути, у DDD есть фатальный недостаток: DDD неизбежно приводит к нарушению целостности данных (инварианта бизнес-логики) в БД .
https://habr.com/ru/articles/800385/
#DDD #DomainDriven_Design #eventual_consistency #aggregate #saga #агрегат #сага
-
We just published a new 🎥 of #JCON WORLD ONLINE 2023!
Watch Sara Pellegrini & Milan Savić talking about 'The Aggregate is dead. Long live the Aggregate!'#DDD's definition of #Aggregate may seem somewhat confusing - "An aggregate …
Watch it now: https://youtu.be/-x0OkDfa4ek
-
Aggregated Carbon Dots Promote H2 Production under Near-Infrared Light: Carbon dot aggregates exhibit NIR light harvesting and large dipole moments for charge separation and transfer
#chemistry #chemistryviews #chemviews #research #chemiverse #aggregate #h2production
-
Seppi M. USA Moves to New Facility in West Chester, Ohio https://www.constructionequipmentguide.com/seppi-m-usa-moves-to-new-facility-in-west-chester-ohio/61940?utm_source=dlvr.it&utm_medium=mastodon #Aggregate #Ohio #SEPPI #Construction
-
Seppi M. USA Moves to New Facility in West Chester, Ohio https://www.constructionequipmentguide.com/seppi-m-usa-moves-to-new-facility-in-west-chester-ohio/61940?utm_source=dlvr.it&utm_medium=mastodon #Aggregate #Ohio #SEPPI #Construction
-
#stayawhileandlisten 🌏 🌎 🌍
Don't we all #love #MoreData? ❤️
Don't we love to #aggregate #data to higher and higher levels? ❤️If yes, then please take a moment to #scrutinize what type of #KnowledgeGain you are actually able to obtain and what #limitations aggregating imposes.
A cautionary note on aggregation in educational psychology and beyond
https://doi.org/10.1177/09593543231172495#socialsciences #psychology #education #individual #nomothetic #idiographic
-
This should be headline news in all the #architecture magazines - stop wasting #BuildingRubble, use it as #aggregate>
Recycling rubble can help rebuild Syria faster, scientists show | Recycling | The Guardian
https://www.theguardian.com/environment/2023/mar/31/recycling-rubble-rebuild-syria-war-quake-concrete -
@bunnyhero what about a server whos only job is to repost things with a target list of hashtags and not yet a #Aggregate with an #aggregate and flag as bot? so only opt in. Kinfof a poormans push?
-
Can anyone recommend a #FOSS / #FLOSS solution that will #aggregate my personally collected #health and #Fitness #data? It should be able to:
1. Be #Accessible to the general public - both code (#GPL) and #ux
2. Automate the collection of data from multiple sources (some basic ETL)
3. Reformat the data into a standardized format like [#OpenmHealth](https://www.openmhealth.org/documentation/#/schema-docs/schema-library)
4. Provide #datavisualization tools using modern techniques
5. NOT owned by Big Tech (esp., #gMafia )
6. #Decentralized