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=0HLyBsc4VjzGKvok

#Photo

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

In a short exchange with @jankatins I was stimulated to figure out a concise answer to needing to grab the previous or the upcoming non-null value in a column in PostgreSQL, in the order decided by the user, which would be similar to using `lead` and `lag` with the non-supported IGNORE NULLS directive.

The implementation I came up with nears poetry in its simplicity and elegance: https://gist.github.com/diraneyya/4455b69e034651151983228cd8b2114b

I am getting into writing PostgreSQL functions in the C language and I am particularly interested in ordered-set aggregate functions.

Is there anyone out here who can direct me in the right direction?

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

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.

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

https://www.chemistryviews.org/enhancing-infrared-photodetectors-with-2d-supramolecular-organic-frameworks/

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/

'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)

https://www.chemistryviews.org/nanoparticles-with-ultrabright-aggregation-A-emission-for-immunoassays/

A quotation from Hugo, Victor:

«
The greatest follies, like the stoutest ropes, are often composed of a multitude of strands. Take the cable thread by thread, take separately each petty determining motive, and you can snap them one by one and say, “There’s no more to it than that!” Braid them and twist them together, and what you have is momentous.
»

Full quote, sourcing, notes:
https://wist.info/hugo-victor/1988/

How Do Organic Radicals Aggregate in Polar Fluorocarbon Solvents?
Aggregates of radicals that form intermolecular hydrogen bonds can accelerate catalysis

https://www.chemistryviews.org/how-do-organic-radicals-aggregate-in-polar-fluorocarbon-solvents/

@AggregateOA #chemistry #chemistryviews #chemviews #chemiverse #research #aggregate #organicchemistry

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

https://bit.ly/47aoooE

#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

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

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

@ellie_rigby die Idee hatte ich auch schon aber gleich für nen ganzen #Fitnesscenter mit #Solardach und #Windrad. Das müsste doch für eine #Kleinstadt reichen. Und alle sind verpflichtet #Sport zu machen = gesünder....
#Strom #Notstromaggregate #Notstrom #Energiespeicher #fedipower #gesund #nachhaltig #stromausfall #aggregate #Technik #Hilfe #Ideen

doing a cronch!