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.
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
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
#postgresql #sql #aggregate #excel #lookahead #lookback #lead #lag #window #programming
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
Мой путь к быстрой и понятной архитектуре, или зачем я выбросил агрегаты из 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
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
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/
#quote #quotes #quotation #aggregate #avalanche #blunder #error #mistake #combination
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
Пиррова победа Domain-Driven Design
TL;DR: DDD неизбежно ведёт к избыточному (на порядки больше минимально необходимого) количеству саг в проекте, которые, в свою очередь, неизбежно ведут к нарушению целостности данных в БД. DDD вполне успешно решает поставленную задачу: дать разработчикам инструменты, которые позволят им справится (корректно реализовать и поддерживать) со сложной предметной областью. Но эта победа оказалась пирровой: инструменты, обеспечивающие корректность данных в памяти , оказались неспособны гарантировать корректность данных в БД . А что толку от изначально корректных данных в памяти, если со временем (после их сохранения в БД и последующего чтения) они перестают быть корректными? По сути, у DDD есть фатальный недостаток: DDD неизбежно приводит к нарушению целостности данных (инварианта бизнес-логики) в БД .
https://habr.com/ru/articles/800385/
#DDD #DomainDriven_Design #eventual_consistency #aggregate #saga #агрегат #сага
Welche Möglichkeiten gibt es, von Websuchen RSS-Feeds generieren zu lassen?
Bing hat(te?) grds. so eine Funktion.
(Bei mir scheint das nur noch bei den Suchen unter "News / Nachrichten" zu funktionieren, nicht mehr bei den klassischen Suchen.)
Andere Suchmaschinen? Selbstgehostete Metasuchmaschinen?
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
