#aggregation — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #aggregation, aggregated by home.social.
-
Двигаем PostgreSQL в сторону OLAP: оптимизация параллельного вычисления агрегатов
В данной статье я хочу рассказать о проверке одной гипотезы - возможности использования shared memory для ускорения параллельной агрегации методом хэширования. Статья Xu&Marcus, PVLDB, 2025 утверждает, что общая хэш-таблица — незаслуженно списанный со счетов способ параллельной агрегации, если использовать т.н. тикетинг и разделить операции поиска группы и обновления агрегата. Звучит завлекательно. Собираем в кучу свои знания Internals, подписку на Claude и, поскольку в период летних Heat Wave выходные всё-равно проходят дома под кондиционером - разрабатываем идею так глубоко, насколько это получится.
https://habr.com/ru/companies/tantor/articles/1066692/
#postgresql #shared_memory #aggregation #parallelism #performance #query_execution
-
I ♥ RSS – A directory of people who love RSS
https://andrewshell.org/2026/07/i-%e2%99%a5-rss/
Comments: https://news.ycombinator.com/item?id=49136063
#HackerNews #RSS #Love #Directory #Tech #Community #Online #Tools #News #Aggregation
-
I ♥ RSS – A directory of people who love RSS
https://andrewshell.org/2026/07/i-%e2%99%a5-rss/
Comments: https://news.ycombinator.com/item?id=49136063
#HackerNews #RSS #Love #Directory #Tech #Community #Online #Tools #News #Aggregation
-
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/ -
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/ -
🔄 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, 2026https://github.com/trackawesomelist/trackawesomelist
#selfhosted #homelab #selfhost #selfhosting #opensource #aggregation #rss
-
Как я создал локальное хранилище и агрегатор VLESS конфигураций
Я думаю, что все заметили, что в последнее время доступ к большинству зарубежным ресурсам и API оставляет желать лучшего. Для обычного человека потеря связи с любимыми или нужными ресурсами посреди рабочего дня — это очень неприятно. Полагаться на один зарубежный сервер стало неэффективно: узлы падают, скорость проседает. У меня у самого появилась это проблема, поэтому я захотел ее решить. Что я решил сделать, рассказываю дальше Читать дальше
https://habr.com/ru/articles/1057636/
#vless #vless+reality #whitelist #белые_списки #vpn #localhost #обход #v2ray #aggregation #open_source
-
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
https://atlasflux.saynete.net/atlas_des_flux_rss_ang_aggregated_google.htm
Flipboard Platform : 77 RSS feeds
https://atlasflux.saynete.net/atlas_des_flux_rss_ang_platform_flipboard.htm
Flipboard Aggregator : 310 RSS feeds
https://atlasflux.saynete.net/atlas_des_flux_rss_ang_aggregated_flipboard.htm#RSS #OPML #google #flipboard #aggregation #agregation #aggregator #agregateur
-
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 https://doi.org/10.1107/S2053230X26000798
-
🌟 𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐢𝐧𝐠 [Google Research’s] 𝐆𝐫𝐨𝐮𝐧𝐝𝐬𝐨𝐮𝐫𝐜𝐞 - 𝐀𝐧 𝐨𝐩𝐞𝐧 𝐬𝐨𝐮𝐫𝐜𝐞 𝐝𝐚𝐭𝐚𝐬𝐞𝐭 𝐨𝐟 𝐡𝐢𝐬𝐭𝐨𝐫𝐢𝐜 𝐟𝐥𝐨𝐨𝐝 𝐞𝐯𝐞𝐧𝐭𝐬 𝐟𝐫𝐨𝐦 𝐧𝐞𝐰𝐬 𝐚𝐫𝐭𝐢𝐜𝐥𝐞𝐬.
--
https://doi.org/10.31223/X5RR2K / https://eartharxiv.org/repository/view/12083/ <-- shared paper
--
https://zenodo.org/records/18647054 <-- shared link to associated dataset
--
https://sites.research.google/gr/floodforecasting/ <-- 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 -
🌟 𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐢𝐧𝐠 [Google Research’s] 𝐆𝐫𝐨𝐮𝐧𝐝𝐬𝐨𝐮𝐫𝐜𝐞 - 𝐀𝐧 𝐨𝐩𝐞𝐧 𝐬𝐨𝐮𝐫𝐜𝐞 𝐝𝐚𝐭𝐚𝐬𝐞𝐭 𝐨𝐟 𝐡𝐢𝐬𝐭𝐨𝐫𝐢𝐜 𝐟𝐥𝐨𝐨𝐝 𝐞𝐯𝐞𝐧𝐭𝐬 𝐟𝐫𝐨𝐦 𝐧𝐞𝐰𝐬 𝐚𝐫𝐭𝐢𝐜𝐥𝐞𝐬.
--
https://doi.org/10.31223/X5RR2K / https://eartharxiv.org/repository/view/12083/ <-- shared paper
--
https://zenodo.org/records/18647054 <-- shared link to associated dataset
--
https://sites.research.google/gr/floodforecasting/ <-- 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 -
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
-
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
-
"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."
https://hamishcampbell.com/journalists-generally-don-t-understand-what-journalism-is/ -
"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."
https://hamishcampbell.com/journalists-generally-don-t-understand-what-journalism-is/ -
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.
https://magicmarcy.de/assoziationen-in-java-entschuldigung-kennen-wir-uns
#Assoziationen #einfach #bidirektional #Aggregation #Komposition #hat-eine #besteht-aus #one-to-one #one-to-many #eins-zu-eins #eins-zu-viele
-
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
-
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
-
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
-
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
-
-
-
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.
https://magicmarcy.de/assoziationen-in-java-entschuldigung-kennen-wir-uns
#Assoziationen #einfach #bidirektional #Aggregation #Komposition #hat-eine #besteht-aus #one-to-one #one-to-many #eins-zu-eins #eins-zu-viele
-
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
-
A sharded DuckDB on 63 nodes runs 1T row aggregation challenge in 5 sec
https://gizmodata.com/blog/gizmoedge-one-trillion-row-challenge
#HackerNews #DuckDB #Sharding #Aggregation #Challenge #1T #Rows #BigData #Performance
-
A sharded DuckDB on 63 nodes runs 1T row aggregation challenge in 5 sec
https://gizmodata.com/blog/gizmoedge-one-trillion-row-challenge
#HackerNews #DuckDB #Sharding #Aggregation #Challenge #1T #Rows #BigData #Performance
-
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
- AI-Fueled Spiritual Delusions Are Destroying Human Relationships: This is a great example of how the quest to understand ourselves with things like this is paved with nonsense. And it’s so easy and appealing to go down a wrong path Something to be mindful and skeptical about.
- Don’t Chop Up Your Apple Trees to Make Barrels for Your Apples: On TBC CEO’s notes that web pages won’t be the primary interface for a browser…
- How To Know What To Do: A guide on how to plan your life
- OpenAI has an unsubtle communications strategy.: The load-bearing relationships between futurity-vibes and finance
- Screen Names, BBM, and MP3s The Oral History of Millennial Tech: By the turn of the century, millennials found themselves as test dummies on the cutting edge of technology. Chat rooms! Music in your pocket! Tamagotchis! It all sounds pretty quaint now …
- The Anxiety-Curiosity Switch • Ness Labs: The anxiety-curiosity switch is the process of redirecting the mental energy that causes creative paralysis into curiosity-driven exploration. It’s particularly useful as anxiety and curiosity are reframes of very similar brain patterns. Doing this can often be the difference between creation and a slam of the metaphorical book.
- The Critical Difference Between Complex and Complicated: When you manage complex problems as if they’re complicated, you’re setting your company up to fail.
- Who You Are is Not What You Do: Rather than drastic, very difficult changes, get hobbies a little at a time, make friends a little at a time. Ultimately, it’s similar to diversifying a financial portfolio. You have to diversify your life. Diversify yourself
- Why I’m meditating 300 hours: This is an interesting follow. They’ve already achieved close to 100-150 hours and that’s might impressive. While I’ve mulled about meditation, I am continuing journaling.
#2025 #aggregation #blogs #curation #links #lol #posts #weekly #weeklyLol
-
'Sharp Bounds for Sequential Federated Learning on Heterogeneous Data', by Yipeng Li, Xinchen Lyu.
http://jmlr.org/papers/v26/24-0668.html
#federated #aggregation #heterogeneous -
'Sharp Bounds for Sequential Federated Learning on Heterogeneous Data', by Yipeng Li, Xinchen Lyu.
http://jmlr.org/papers/v26/24-0668.html
#federated #aggregation #heterogeneous -
For the first time since the start of his second term, #Trump hit 50% #disapproval in #VoteHub's #polling #aggregation today. https://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.
-
For the first time since the start of his second term, #Trump hit 50% #disapproval in #VoteHub's #polling #aggregation today. https://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.
-
Fake Angel Reese quotes keep spreading https://www.rawchili.com/4117822/ #Aggregation #AngelReese #FakeQuotes #MichaelJordan #WNBA
-
📚 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."
-
📚 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."
-
GeoFeeds Is Online
--
https://blog.geomusings.com/2025/02/13/geofeeds-is-online/ <-- shared blog outlining the resurrection
--
https://geofeeds.me/list <-- shared GeoFeeds home page
--
[a welcome return of a wonderful set of resources, one-stop-shopping!]
#GIS #spatial #news #mapping #blogs #newsaggregation #aggregation #Node #substack #feed #singlefeed #RSS #writing #GeoFeeds #georelated #onestopshopping #jumpingoffpoint -
GeoFeeds Is Online
--
https://blog.geomusings.com/2025/02/13/geofeeds-is-online/ <-- shared blog outlining the resurrection
--
https://geofeeds.me/list <-- shared GeoFeeds home page
--
[a welcome return of a wonderful set of resources, one-stop-shopping!]
#GIS #spatial #news #mapping #blogs #newsaggregation #aggregation #Node #substack #feed #singlefeed #RSS #writing #GeoFeeds #georelated #onestopshopping #jumpingoffpoint -
Sleeping #bacteria: New study uncovers mechanisms of #dormancy involving #protein #aggregation.
https://phys.org/news/2025-01-bacteria-uncovers-mechanisms-dormancy-involving.html
-
Sleeping #bacteria: New study uncovers mechanisms of #dormancy involving #protein #aggregation.
https://phys.org/news/2025-01-bacteria-uncovers-mechanisms-dormancy-involving.html
-
'Risk Measures and Upper Probabilities: Coherence and Stratification', by Christian Fröhlich, Robert C. Williamson.
http://jmlr.org/papers/v25/22-0641.html
#measures #risk #aggregation -
'Risk Measures and Upper Probabilities: Coherence and Stratification', by Christian Fröhlich, Robert C. Williamson.
http://jmlr.org/papers/v25/22-0641.html
#measures #risk #aggregation -
Firefox under fire for enabling ‘privacy-protecting ad measurements’
https://stackdiary.com/firefox-under-fire-for-enabling-privacy-protecting-ad-measurements/
#Firefox #Privacy #Advertising #Mozilla #Controversy #Tracking #UserConcerns #DataProtection #WebStandards #AdMeasurement #DefaultSettings #Backlash #PrivacyPreserving #Attribution #API #UserConsent #Aggregation #DifferentialPrivacy #Encryption #Anonymous #OptOut #MarketShare #UserDecline #AdTech #DataCollection #BrowserWars #TechEthics #UserRights #InternetFreedom #DigitalPrivacy
-
Firefox under fire for enabling ‘privacy-protecting ad measurements’
https://stackdiary.com/firefox-under-fire-for-enabling-privacy-protecting-ad-measurements/
#Firefox #Privacy #Advertising #Mozilla #Controversy #Tracking #UserConcerns #DataProtection #WebStandards #AdMeasurement #DefaultSettings #Backlash #PrivacyPreserving #Attribution #API #UserConsent #Aggregation #DifferentialPrivacy #Encryption #Anonymous #OptOut #MarketShare #UserDecline #AdTech #DataCollection #BrowserWars #TechEthics #UserRights #InternetFreedom #DigitalPrivacy
-
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 https://oer-informatik.de/sql-uebungsaufgaben
-
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 https://oer-informatik.de/sql-uebungsaufgaben
-
'Fat-Shattering Dimension of k-fold Aggregations', by Idan Attias, Aryeh Kontorovich.
http://jmlr.org/papers/v25/21-1193.html
#aggregations #aggregation #aggregate -
'Fat-Shattering Dimension of k-fold Aggregations', by Idan Attias, Aryeh Kontorovich.
http://jmlr.org/papers/v25/21-1193.html
#aggregations #aggregation #aggregate -
#DavidChalmers - What #Exists?
https://www.youtube.com/watch?v=w6FodXTwB04
#Philosophhy #Metaphysics #Existence #Things #Objects #Being #LawsOfNature #LawsOfPhysics #Physics #Science #PhilosophyOfScience #Metaphysician #Matter #Energy #SpaceTime #Universe #Physicalism #Physicalist #Consciousness #Mind #Panpsychism #Monism #Dualism #Contingency #Idealism #AbstractObjects #Aggregation #CloserToTruth #RobertKhun
-
#DavidChalmers - What #Exists?
https://www.youtube.com/watch?v=w6FodXTwB04
#Philosophhy #Metaphysics #Existence #Things #Objects #Being #LawsOfNature #LawsOfPhysics #Physics #Science #PhilosophyOfScience #Metaphysician #Matter #Energy #SpaceTime #Universe #Physicalism #Physicalist #Consciousness #Mind #Panpsychism #Monism #Dualism #Contingency #Idealism #AbstractObjects #Aggregation #CloserToTruth #RobertKhun
-
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
-
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
-
The BIN1 gene is a key risk locus for #AlzheimersDisease, but how does it impact #TauPathology? This study shows that during aging, the protease legumain is activated and cleaves BIN1, promoting tau #aggregation & spreading of #pathology #PLOSBiology https://plos.io/3tOPYtE
-
The BIN1 gene is a key risk locus for #AlzheimersDisease, but how does it impact #TauPathology? This study shows that during aging, the protease legumain is activated and cleaves BIN1, promoting tau #aggregation & spreading of #pathology #PLOSBiology https://plos.io/3tOPYtE
-
hm, bei feed.informer (https://feed.informer.com) gibts mal wieder technische probleme. hoffentlich werden sie behoben, obwohl das tool nicht mehr groß "maintained" wird. ich sollte mich wohl doch mal nach alternativen umsehen und z.b. https://www.pipes.digital/ testen. #RSS #aggregation