home.social

#aggregate — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #aggregate, aggregated by home.social.

fetched live
  1. Один ко многим в Java: когда коллекция в родителе оправдана, а когда — нет

    Реляционная модель хранит FK на стороне дочерней таблицы. В Java у нас два способа отразить эту связь: коллекция в родительской сущности ( @OneToMany / List) или ссылка в дочерней ( @ManyToOne / long parentId). Выбор между ними влияет на поведение при записи — и именно здесь большинство решений принимаются без достаточного обоснования. Тест, который даёт однозначный ответ Влад Михалча формулирует так: ассоциация @ManyToOne является наиболее естественным способом отображения связи «один ко многим» в базе данных и, как правило, наиболее эффективной альтернативой. Практический критерий: если убрать коллекцию и заменить её отдельным запросом, какое бизнес-правило перестанет работать? Если ответ — «никакое, просто список будет получаться отдельным запросом» — коллекция не нужна как часть модели. Если ответ — «нарушится инвариант» — коллекция оправдана. Типичные случаи:

    habr.com/ru/articles/1050776/

    #java #jpa #hibernate #spring #spring_data #jdbc #onetomany #manytoone #ddd #aggregate

  2. RE: scicomm.xyz/@dantheclamman/116

    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
    doi.org/10.1111/1365-2664.14307

  3. RE: scicomm.xyz/@dantheclamman/116

    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
    doi.org/10.1111/1365-2664.14307

  4. Bayer Leverkusen secured a 0‑0 draw against Olympiacos Piraeus, successfully defending the 2‑0 advantage they held from the first leg and earning a place in the... news.osna.fm/?p=35781 | #news #aggregate #champions #last16 #league

  5. 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

    youtube.com/watch?v=lCeAps3FTGg

  6. 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

    youtube.com/watch?v=lCeAps3FTGg

  7. 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

    youtube.com/watch?v=fPdWHWUDZDs

  8. 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

    youtube.com/watch?v=fPdWHWUDZDs

  9. 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

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

  10. 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

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

  11. 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

    youtube.com/watch?v=5tbIlazlcGI

  12. 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

    youtube.com/watch?v=5tbIlazlcGI

  13. RE: flipboard.com/@sciencealert/te

    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)
    doi.org/10.1126/scirobotics.ad

  14. RE: flipboard.com/@sciencealert/te

    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)
    doi.org/10.1126/scirobotics.ad

  15. 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

    youtube.com/watch?v=8o4s0DK1sNM

  16. 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

    youtube.com/watch?v=8o4s0DK1sNM

  17. 🚀 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! 🔥

  18. 🚀 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

  19. Time for a reality check... I think some folks thought #Trump's approval rating would keep falling, but it's rising.

    #Ipsos has his net approval going from -8 pts to -1 pt with voters. #Aggregate has him up higher than late April too & much higher than at this point in term 1.

  20. 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)
    youtu.be/wZqDuEFu8Nk?si=0HLyBs

    #Photo

    P. apterus Bln, 2020, new edit 2025 © S. F. Wirth

  21. 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)
    youtu.be/wZqDuEFu8Nk?si=0HLyBs

    #Photo

    P. apterus Bln, 2020, new edit 2025 © S. F. Wirth

  22. Мой путь к быстрой и понятной архитектуре, или зачем я выбросил агрегаты из DDD?

    Данная статья затрагивает некоторые аспекты при выборе подхода к проектированию предметной области для сложных корпоративных систем. В ней исследуются причины возникновения классических подходов и их анализ, для возможного улучшения. Это моя первая статья на данную тему. В начале хочется сказать, что предложенная концепция не пытается претендовать на роль какой-то панацеи и уж тем более на роль единственно верной, она так же имеет рад своих преимуществ и недостатков. Это скорее попытка переосмыслить опыт, который накопился у меня за несколько лет проектировании корпоративных систем. Материал изложен в виде вопросов и попыток на них ответить.

    habr.com/ru/articles/876742/

    #ddd #domaindriven_design #domain_model #repository #use_case #c# #net #services #aggregate #entity

  23. An eye-openning talk by Mette Bendixen (Geography, ) 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.

  24. 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

  25. 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

    chemistryviews.org/enhancing-i

    #chemistry #chemistryviews #chemviews #chemiverse #aggregate #materials #organicframeworks #optoelectronic

  26. 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

    chemistryviews.org/enhancing-i

    #chemistry #chemistryviews #chemviews #chemiverse #aggregate #materials #organicframeworks #optoelectronic

  27. 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...

    en.wikipedia.org/wiki/Aggregat

    #Aggregate #Pedology #Petrology #Mineralogy #IndustrialMinerals

  28. Nanoparticles with Ultrabright Aggregation-Induced Emission for Immunoassays:

    Probe uses nanoparticles composed of polystyrene and a near-infrared (NIR) aggregation-induced emission luminogen (AIEgen)

    chemistryviews.org/nanoparticl

    #chemistry #chemistryviews #chemviews #chemiverse #research #aggregate #nanoparticles

  29. Nanoparticles with Ultrabright Aggregation-Induced Emission for Immunoassays:

    Probe uses nanoparticles composed of polystyrene and a near-infrared (NIR) aggregation-induced emission luminogen (AIEgen)

    chemistryviews.org/nanoparticl

    #chemistry #chemistryviews #chemviews #chemiverse #research #aggregate #nanoparticles

  30. Пиррова победа Domain-Driven Design

    TL;DR: DDD неизбежно ведёт к избыточному (на порядки больше минимально необходимого) количеству саг в проекте, которые, в свою очередь, неизбежно ведут к нарушению целостности данных в БД. DDD вполне успешно решает поставленную задачу: дать разработчикам инструменты, которые позволят им справится (корректно реализовать и поддерживать) со сложной предметной областью. Но эта победа оказалась пирровой: инструменты, обеспечивающие корректность данных в памяти , оказались неспособны гарантировать корректность данных в БД . А что толку от изначально корректных данных в памяти, если со временем (после их сохранения в БД и последующего чтения) они перестают быть корректными? По сути, у DDD есть фатальный недостаток: DDD неизбежно приводит к нарушению целостности данных (инварианта бизнес-логики) в БД .

    habr.com/ru/articles/800385/

    #DDD #DomainDriven_Design #eventual_consistency #aggregate #saga #агрегат #сага

  31. 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: youtu.be/-x0OkDfa4ek

  32. 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: youtu.be/-x0OkDfa4ek

  33. 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

    bit.ly/47aoooE

    #chemistry #chemistryviews #chemviews #research #chemiverse #aggregate #h2production

  34. 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

    bit.ly/47aoooE

    #chemistry #chemistryviews #chemviews #research #chemiverse #aggregate #h2production

  35. #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
    doi.org/10.1177/09593543231172

    #socialsciences #psychology #education #individual #nomothetic #idiographic

  36. 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
    theguardian.com/environment/20

  37. @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?

  38. @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?