home.social

#aggregation — Public Fediverse posts

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

fetched live
  1. Stop writing 5 queries in SQL when one ROLLUP does it all.

    You're usually running separate queries for yearly, monthly, and daily totals.

    GROUPING SETS, ROLLUP, and CUBE generate every aggregation level in a single query.

    There is no need to use UNION ALL anymore!

    #data #dataanalytics #sql #rollup #aggregation

  2. Open Social Wall 0.2.0 is out in the wild.

    New: native Gutenberg block, configurable source filters, control over the initial number of posts and inheritance of plugin defaults. Still lightweight, open source, privacy-conscious and RSS/Atom-first.

    The wp.org review is still running. Until then, I’d be very happy if anyone wants to test it…

    🔗 gitlab.com/ibigfoot/open-socia

    #WordPress #OpenSource #Aggregation #Fediverse #RSS #Mastodon

  3. How are post-translational modifications involved in the aggregation of Tau with important implications in neurodegenerative disorders?

    Wyatt Powell from the group of Jason Gestwicki highlights the importance of phosphorylation of S396 in his talk at #ICBS2026.

    biorxiv.org/content/10.64898/2

    #ChemBio #Chemistry #Science #Aggregation #Alzheimers

  4. Interesting paper by the groups of Hilal Lashuel and Muhammad Jbara in JACS.

    Using organometallic chemistry, they arylate cysteines to site-specifically introduce "native-like" phosphotyrosine mimics on the example of α-synuclein.

    doi.org/10.1021/jacs.6c12345
    #Chemistry #ChemBio #Peptides #Proteins #Aggregation

  5. Двигаем PostgreSQL в сторону OLAP: оптимизация параллельного вычисления агрегатов

    В данной статье я хочу рассказать о проверке одной гипотезы - возможности использования shared memory для ускорения параллельной агрегации методом хэширования. Статья Xu&Marcus, PVLDB, 2025 утверждает, что общая хэш-таблица — незаслуженно списанный со счетов способ параллельной агрегации, если использовать т.н. тикетинг и разделить операции поиска группы и обновления агрегата. Звучит завлекательно. Собираем в кучу свои знания Internals, подписку на Claude и, поскольку в период летних Heat Wave выходные всё-равно проходят дома под кондиционером - разрабатываем идею так глубоко, насколько это получится.

    habr.com/ru/companies/tantor/a

    #postgresql #shared_memory #aggregation #parallelism #performance #query_execution

  6. Juha-Matti Santala: In the era of AI slop, human curation is even more important. “Now, more than ever, we need human curation to find anything meaningful. The problem with LLM generated slop is that it requires close to no effort to fill every avenue with it. If you push millions of pieces of content to Youtube, music platforms, app stores and social media every day, it just drowns everything […]

    https://rbfirehose.com/2026/07/29/juha-matti-santala-in-the-era-of-ai-slop-human-curation-is-even-more-important/
  7. Vehicle-to-grid added to Massachusetts utilities’ ConnectedSolutions demand response VPP

    Vehicle-to-grid added to Massachusetts utilities’ ConnectedSolutions demand response VPP – Energy-Storage.News
    Skip to content
    #Energy #aggregation #Demandresponse #ders #massachusetts #NationalGrid #V2G #vpp
    europesays.com/3157040/

  8. 🔄 trackawesomelist/trackawesomelist

    Track 500+ Awesome List Updates, Track it - not just star it!

    Aggregates recent changes from over 500 curated resource lists into accessible RSS feeds and newsletters for tracking

    ⭐ Stars: 656
    📅 Last Update: Jul 21, 2026

    github.com/trackawesomelist/tr

    #selfhosted #homelab #selfhost #selfhosting #opensource #aggregation #rss

  9. Как я создал локальное хранилище и агрегатор VLESS конфигураций

    Я думаю, что все заметили, что в последнее время доступ к большинству зарубежным ресурсам и API оставляет желать лучшего. Для обычного человека потеря связи с любимыми или нужными ресурсами посреди рабочего дня — это очень неприятно. Полагаться на один зарубежный сервер стало неэффективно: узлы падают, скорость проседает. У меня у самого появилась это проблема, поэтому я захотел ее решить. Что я решил сделать, рассказываю дальше Читать дальше

    habr.com/ru/articles/1057636/

    #vless #vless+reality #whitelist #белые_списки #vpn #localhost #обход #v2ray #aggregation #open_source

  10. Grid operators across the United States face an unprecedented dual challenge of surging electricity demand from data centers and frequent extreme weather events.#Aggregation #EnergyStorage #Grids #UnitedStates #VirtualPowerPlants
    The aggregation imperative - pv magazine Global
  11. UK to secure critical minerals boosting economic resilience and cutting reliance on imports | Department for Business & Trade

    Households and businesses are set to benefit from stronger, more secure supply chains as the UK invests £…
    #NewsBeep #News #UnitedKingdom #accelerator #Aggregation #association #base #Britain #British #Centre #chris #Critical. #demand #DEScycle #East #founder #fund #GB #government #GreatBritain #Industry #Minerals #Strategy #UK #Wilton
    newsbeep.com/uk/652149/

  12. Google added to the aggregator category and partition between Flipboard platform and aggregation 🇬🇧
    Google ajouté à la rubrique agrégateur et partition entre Flipboard plateforme et agrégation 🇫🇷

    Google Aggregator : 318 RSS feeds
    atlasflux.saynete.com/atlas_de
    Flipboard Platform : 77 RSS feeds
    atlasflux.saynete.com/atlas_de
    Flipboard Aggregator : 310 RSS feeds
    atlasflux.saynete.com/atlas_de

    #RSS #OPML #google #flipboard #aggregation #agregation #aggregator #agregateur

  13. MBP fusion is an effective and generalizable approach to enable crystallographic studies of engineered binding proteins that are otherwise difficult to crystallize #Monobody #Aggregation #MaltoseBindingProtein doi.org/10.1107/S2053230X26000

  14. 🌟 𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐢𝐧𝐠 [Google Research’s] 𝐆𝐫𝐨𝐮𝐧𝐝𝐬𝐨𝐮𝐫𝐜𝐞 - 𝐀𝐧 𝐨𝐩𝐞𝐧 𝐬𝐨𝐮𝐫𝐜𝐞 𝐝𝐚𝐭𝐚𝐬𝐞𝐭 𝐨𝐟 𝐡𝐢𝐬𝐭𝐨𝐫𝐢𝐜 𝐟𝐥𝐨𝐨𝐝 𝐞𝐯𝐞𝐧𝐭𝐬 𝐟𝐫𝐨𝐦 𝐧𝐞𝐰𝐬 𝐚𝐫𝐭𝐢𝐜𝐥𝐞𝐬.
    --
    doi.org/10.31223/X5RR2K / eartharxiv.org/repository/view <-- shared paper
    --
    zenodo.org/records/18647054 <-- shared link to associated dataset
    --
    sites.research.google/gr/flood <-- shared link to Google Research flood forecasting effort entry page
    --
    #GoogleResearch #Google #Gemini #AI #ClimateTech #MachineLearning #DataScience #FloodForecasting #Sustainability #TechForGood #aggregation #curated #newsarticles #news #media #article #harvesting #reports #reporting #global #world #historic #naturalhazards #naturaldisaster #floods #flooding #flashflood #water #hydrology #extremeweather #climatechange #GDACS #Groundsource #GIS #spatial #mapping #spatialanalysis #spatiotemporal #geographic #openaccess #openscience #opendata #floodevents #LLM #gemini #largelanguagemodel #deeplearning #AI #precision #metrics #historicresource #model #modeling #forecasting #opensource

  15. HAVING Filters After GROUP BY?!

    HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!

    #sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=OMjcmF4mw08

  16. "The #powerOFjournalism is not only the individual stories[the water], but in shaping the riverbed through which that water flows.
    Traditional journalism binds the river through wages, hierarchy, institutional agendas. Editorial #control channels the flow in deliberate directions.
    In contrast, internet-era journalism has the potential to build rivers through #cooperation, #federation, and collective #aggregation – but this requires conscious design and understanding."
    hamishcampbell.com/journalists

  17. Ich hatte neulich erst einen Beitrag zur objektorientierten Programmieung in Java geschrieben und möchte ergänzend dazu heute über Assoziationen sprechen. Denn auch diese sind ein wichtiger Teil wenn uns um Verbindungen, bzw. Beziehungen zwischen Klassen geht.

    magicmarcy.de/assoziationen-in

    #Assoziationen #einfach #bidirektional #Aggregation #Komposition #hat-eine #besteht-aus #one-to-one #one-to-many #eins-zu-eins #eins-zu-viele

  18. Conditional Aggregation with CASE?!

    CASE inside SUM creates conditional aggregation! You can sum only certain rows based on conditions. This conditional math will transform your data!

    #sql #sqltricks #case #sum #conditionalaggregation #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=ncgl7_S0NvQ

  19. GROUPING SETS / ROLLUP / CUBE?!

    ROLLUP creates MULTIPLE grouping levels! It generates subtotals and grand totals automatically. This one query returns MANY result sets!

    #sql #sqltricks #rollup #cube #groupingsets #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

    youtube.com/watch?v=C35N6p1rooE

  20. Ich hatte neulich erst einen Beitrag zur objektorientierten Programmieung in Java geschrieben und möchte ergänzend dazu heute über Assoziationen sprechen. Denn auch diese sind ein wichtiger Teil wenn uns um Verbindungen, bzw. Beziehungen zwischen Klassen geht.

    magicmarcy.de/assoziationen-in

    #Assoziationen #einfach #bidirektional #Aggregation #Komposition #hat-eine #besteht-aus #one-to-one #one-to-many #eins-zu-eins #eins-zu-viele

  21. Yeah... Reddit blocked my server IP address. But I think most of the data that contribute to Reddit feed aggregation weren't even made by or belong to Reddit, lol.

    #Redlib #Reddit #Aggregation #IPBlock #Nulu #SelfHosting #DigitalAutonomy #OpenSource #TechIssues #API #DataOwnership #TechStruggles #Censorship #Proxy #InternetFreedom #Redditor #Web

  22. Advisor CRM and SmartData Partner to Advance Operational Efficiency for Financial Advisors  Advisor CRM, an all-in-one CRM platform designed exclusively for financial advisors, announced a strateg...

    #Fintech #News #Advisor #CRM #CRM #platform #data #aggregation #Financial #Advisors #financial

    Origin | Interest | Match
  23. Weekly Link Out Loud (LOL) – W21 • 2025

    Starting a new series of posts titled – Weekly Link Out Loud – LOLs – links to posts I read and took notes on from May 25 – May 31 2025

    #2025 #aggregation #blogs #curation #links #lol #posts #weekly #weeklyLol

  24. 'Sharp Bounds for Sequential Federated Learning on Heterogeneous Data', by Yipeng Li, Xinchen Lyu.

    jmlr.org/papers/v26/24-0668.ht

    #federated #aggregation #heterogeneous

  25. For the first time since the start of his second term, #Trump hit 50% #disapproval in #VoteHub's #polling #aggregation today. votehub.com/polls/

    Presidents have come back from this. #Reagan bottomed out at something like 30% early in his first term, and then of course won re-election in a landslide. But Trump doesn't have that kind of political acumen.

    If we have anything resembling a fair #election, 2026 will be a bloodbath, and I'm willing to bet 2028 as well. If we don't, well, it will be a bloodbath of a different kind.

  26. @pluralistic @mozillaofficial

    📚 Estimating the success of re-identifications in incomplete datasets using generative models [Nature][open access]

    2019 article about the realities of privacy of aggregated user data:

    "... 99.98% of Americans would be correctly re-identified in any dataset using 15 demographic attributes."

    🌐 nature.com/articles/s41467-019

    #privacy #GDPR #aggregation

  27. 'Risk Measures and Upper Probabilities: Coherence and Stratification', by Christian Fröhlich, Robert C. Williamson.

    jmlr.org/papers/v25/22-0641.ht

    #measures #risk #aggregation

  28. Wohl dem, der eine Kollegin mit "H" an der Schule hat. Denn die folgenden Übungsaufgaben wurden nur von allen korrekt gelöst, die sich die Eselsbrücke "Für wen geht Hubert so oft laufen?" und "Warum geht Hildegard oft laufen?" gemerkt haben. Es ist Zeit, diese Runde Klassenarbeitsaufgaben ins Netz zu stellen, Kollegas. (Aufgaben zu #SQL #Aggregation, Unterabfragen, #Joins, #Transaction). #informatikEdu oer-informatik.de/sql-uebungsa

  29. 'Fat-Shattering Dimension of k-fold Aggregations', by Idan Attias, Aryeh Kontorovich.

    jmlr.org/papers/v25/21-1193.ht

    #aggregations #aggregation #aggregate

  30. Large AI company is paying about $60 million for access to Reddit (YOUR content) so it can train its AI models

    Fediverse does have open source alternatives like lemmy, kbin, mbin etc that you can try

    #reddit #community #portal #aggregation #socialnetwork #ai #media #aitraining #software #training #fediverse #kbin #mbin #lemmy #activitypub

Share on Mastodon

Enter the server where you have an account.