Tootfinder

from my link log —
Three cases against IF NOT EXISTS / IF EXISTS in PostgreSQL DDL.
https://postgres.ai/blog/20211103-three-cases-against-if-not-exists-and-if-exists-in-postgresql-ddl
saved 2021-11-12

Three Cases Against IF NOT EXISTS / IF EXISTS in Postgres DDL | Postgres AI

What is this about?

Many DDL statements in PostgreSQL support modified IF EXISTS / IF NOT EXISTS. For example:

 test=# create table if not exists mytable(); CREATE TABLE test=# drop table if exists mytable; DROP TABLE 

I recommend using `IF EXISTS` / `IF NOT EXISTS`…

Gestern war wieder die Zeit für eine #Mangoldernte gekommen.
Diesmal wurden auch die #Fleischtomaten geerntet, von denen es dieses Jahr nicht so viele auf meinem #Balkon gibt.
Es…

Bandnudeln mit Mangold-Tomaten-Sahne-Soße
Mangold habe ich 2021 zum ersten Mal angepflanz und hatte im Juni so viel Ernte aus nur zwei Pflanzkästen, dass ich eingekocht habe. Ich verzichte nach Möglichkeit auf einfrieren, weil das Strom kostet. Eine Konserve...

Am 25. Oktober um 12 Uhr werden die beiden 161 Meter hohen #Kühltürme des ehemaligen AKW #Gundremmingen gesprengt.
Nach der Abschaltung 2021 markiert dies einen weiteren Schritt im Rückbau.
Rund 11.000 Tonnen Schutt werden erwartet. Die Behörden bereiten sich auf zahlre…

AKW Gundremmingen: Termin für die Sprengung der Kühltürme steht
Auf Nachfrage der Redaktion bestätigt der Betreiber RWE jetzt offiziell: Am Samstag, 25. Oktober, fallen die Kühltürme. Auf Gundremmingen wird einiges zukommen.

"May It Be Time"
- instrumental explorations -
#NowPlaying #MusicVideos
https://muz4n…

May It Be Time #NowPlaying
Stan Stewart - @muz4now

Cowboys trade Micah Parsons to Packers: Source https://www.nytimes.com/athletic/6582707/2025/08/28/micah-parsons-trade-packers-cowboys-nfl-2025/

Wimbledon 2025:
Coco Gauff will be the No 2 seed for the second straight Grand Slam event following her victory at the 2025 French Open.
https://www.tennis365.com/tennis-news/wimbledon-2025-womens-seeds-confir…

Wimbledon 2025 women's singles seeds confirmed: Sabalenka & Gauff lead, Swiatek's lowest position since 2021
The full list of women's singles seeds for the 2025 Wimbledon Championships.

Saving Electricity and Gas (2021) - Meter readings at home. #4kWhDHWClub - https://www.earth.org.uk/saving-electricity-2021.html

Saving Electricity and Gas (2021)
Meter readings at home. #4kWhDHWClub

Las Vegas Raiders Superstar Links Up With Legendary Mentors https://heavy.com/sports/nfl/las-vegas-raiders/brock-bowers-nfl-legend-mentors/?adt_ei=[email]

150,000 Sq. Miles to Be Protected in Canada’s Northwest by Coalition of First Nations https://www.goodnewsnetwork.org/150000-sq-miles-to-be-protected-in-canadas-far-northwest-by-coalition-of-first-nations/

150,000 Sq. Miles to Be Protected in Canada's Northwest by Coalition of First Nations
Over 12,000 members of various First Nations' people lived there as of 2021, making up over 40% of the territory's population. 

Importe aus Russland massiv gesunken
Deutschland hat im vergangenen Jahr fast 95 Prozent weniger Waren aus Russland importiert als vor dem Ukraine-Krieg. 2024 wurden Waren im Wert von 1,8 Milliarden Euro aus Russland eingeführt, wie das Statistische Bundesamt mitteilte.
Vor den bisher 17 Sanktionspaketen der EU gegen Russland beliefen sich die Importe 2021 - dem Jahr vor dem Überfall Russlands auf die Ukraine - noch auf 33,1…
📑

Ukraine-Liveblog: ++ Ukraine erhält Leichname von Gefallenen ++
Die Ukraine hat die sterblichen Überreste von mehr als 1.200 getöteten Soldaten erhalten. Russland meldet einen Vorstoß im Westen der ukrainischen Region Donezk.

The Atacama Cosmology Telescope: Release of A databaSe of millimeTeR ObservatioNs of Asteroids Using acT (ASTRONAUT)
Ricco C. Venterea, John Orlowski-Scherer, Nicholas Battaglia, Sigurd Naess, Steve K. Choi, Allen Foster, Joseph Golec, Bruce Patridge, Crist\'obal Sif\'on
https://arxiv.org/abs/2508.18300

The Atacama Cosmology Telescope: Release of A databaSe of millimeTeR ObservatioNs of Asteroids Using acT (ASTRONAUT)
We present A databaSe of millimeTeR ObservatioNs of Asteroids Using acT (ASTRONAUT) hosted on Amazon Web Services, Inc. (AWS) in the form of a public Amazon Simple Storage Service (S3) bucket. This bucket is an Amazon cloud storage database containing flux measurements for a group of asteroids at millimeter (mm) wavelengths. These measurements were collected by the Atacama Cosmology Telescope (ACT) from 2017 to 2021 in frequency bands centered near 90, 150, and 220 GHz. The ASTRONAUT database c…

Pretty unique, non-clichéd, slow, minimal, dubby, syncopated, accented with vocal/vowel fragments:
Drames Rurals - L'empelt (2021)
https://www.youtube.com/watch?v=T3SSti6bdZM

Seit 2021 konzipiere und betreue ich auf Arbeit u.a. den "Truck der Digitalisierung", einen mobilen Showroom für das, was in Sachen #Digitalisierung in der #Pflege realistisch möglich ist.
Jetzt ist im Rahmen des Podcasts der

Requiem for a Stranger
- inspiration from grief and hope -
#StrangerRequiem #NowPlaying
https://

Requiem for a Stranger #StrangerRequiem #NowPlaying
Stan Stewart - @muz4now

from my link log —
Weird architectures weren't supported to begin with.
https://blog.yossarian.net/2021/02/28/Weird-architectures-werent-supported-to-begin-with
saved 2025-04-12

Weird architectures weren't supported to begin with

#Gletscher in der #Schweiz, den #USA und #Kanada haben zwischen 2021 und 2024 rund 12 % ihrer

Gone with the glaciers: Researchers track unprecedented ice loss
A study published in Geophysical Research Letters reveals that glaciers in western Canada, the United States, and Switzerland lost around 12% of their ice between 2001 and 2024.

Ammonia, Methane, Hydrogen and Methanol Produced in Remote Renewable Energy Hubs: a Comparative Quantitative Analysis
Antoine Larbanois, Victor Dachet, Antoine Dubois, Rapha\"el Fonteneau, Damien Ernst
https://arxiv.org/abs/2507.07681

Ammonia, Methane, Hydrogen and Methanol Produced in Remote Renewable Energy Hubs: a Comparative Quantitative Analysis
Remote renewable energy hubs (RREHs) for synthetic fuel production are engineering systems harvesting renewable energy where it is particularly abundant. They produce transportable synthetic fuels for export to distant load centers. This article aims to evaluate the production costs of different energy carriers, and includes a discussion on advantages and disadvantages in terms of technical performance. To do so, we extend the study of Berger et al., (2021) which focuses on methane (CH4) as ene…

On The Green Light Signal and Beyond (2021) - Learn how I am trying a smart lighting nudge @home to use 'leccy at grid-friendly times. #IoT #CO2Intensity -

On The Green Light Signal and Beyond (2021)
Learn how I am trying a smart lighting nudge @home to use leccy at grid-friendly times. #IoT #CO2Intensity

Unavoidable pivot-minors in graphs of large rank-depth
Jungho Ahn, Kevin Hendrey, O-joung Kwon, Sang-il Oum
https://arxiv.org/abs/2507.12697 https://

Unavoidable pivot-minors in graphs of large rank-depth
Shrub-depth and rank-depth are related graph parameters that are dense analogs of tree-depth. We prove that for every positive integer $t$, every graph of sufficiently large rank-depth contains a pivot-minor isomorphic to a path on $t$ vertices or a graph consisting of two disjoint cliques of size $t$ joined by a half graph. This answers an open problem raised by Kwon, McCarty, Oum, and Wollan in 2021.

Surgeons Awareness, Expectations, and Involvement with Artificial Intelligence: a Survey Pre and Post the GPT Era
Lorenzo Arboit, Dennis N. Schneider, Toby Collins, Daniel A. Hashimoto, Silvana Perretta, Bernard Dallemagne, Jacques Marescaux, EAES Working Group, Nicolas Padoy, Pietro Mascagni
https://arxiv.org/abs/2506.08258

Surgeons Awareness, Expectations, and Involvement with Artificial Intelligence: a Survey Pre and Post the GPT Era
Artificial Intelligence (AI) is transforming medicine, with generative AI models like ChatGPT reshaping perceptions of its potential. This study examines surgeons' awareness, expectations, and involvement with AI in surgery through comparative surveys conducted in 2021 and 2024. Two cross-sectional surveys were distributed globally in 2021 and 2024, the first before an IRCAD webinar and the second during the annual EAES meeting. The surveys assessed demographics, AI awareness, expectations, inv…

The $3$-sparsity of $X^n-1$ over finite fields
Kaimin Cheng
https://arxiv.org/abs/2507.06655 https://arxiv.org/pdf/2507.06655

The $3$-sparsity of $X^n-1$ over finite fields
Let $q$ be a prime power and $\mathbb{F}_q$ the finite field with $q$ elements. For a positive integer $n$, the binomial $f_n(X):= X^n-1\in\mathbb{F}_q[X]$ is called $3$-sparse over $\mathbb{F}_q$ if each irreducible factor of $f_n(X)$ over $\mathbb{F}_q$ is either a binomial or a trinomial. In 2021, Oliveira and Reis characterized all positive integers $n$ for which $f_n(X)$ is $3$-sparse over $\mathbb{F}_q$ when $q = 2$ and $q = 4$, and posed the open problem of whether, for any given $q$, th…

@… Als geborener Lindener muss ich sagen: Das mit der SPD ist vorbei und kommt auch nicht wieder:
https://…

Note on the interpretation of magnetic diffraction in NdAlSi: helical or fan?
Takashi Kurumaji
https://arxiv.org/abs/2506.04000 https://

Note on the interpretation of magnetic diffraction in NdAlSi: helical or fan?
We revisit the magnetic structure analysis reported in Nat. Mater. 20, 1650 (2021), which concluded that a Weyl semimetal candidate NdAlSi hosts a helical magnetic order. This conclusion was based on magnetic neutron diffraction peaks corresponding to modulation vectors $\vec{k}_{in} = (1/3, 1/3, 0)$ and $\vec{k}_{out} = (2/3, 2/3, 0)$, attributed to in-plane and out-of-plane components of the magnetic moments, respectively. Upon careful reanalysis, we suggest that a fan-type magnetic structure…

Gear Fever - Musicians, Take Your Temperature
#MusicianTips #GearAquisitionSyndrome
https://

Gear Fever - Musicians, Take Your Temperature
Stan Stewart - @muz4now

Certification of High-Dimensional Entanglement Within the Resource Theory of Buscemi Nonlocality
Xian Shi
https://arxiv.org/abs/2506.07195 https://

Certification of High-Dimensional Entanglement Within the Resource Theory of Buscemi Nonlocality
The study on the certification of high degree entanglement, which is quantified in terms of Schmidt number, attracts much attention recently. Drawing inspiration from the work [PRX QUANTUM 2, 020301 (2021)], we first introduce resource theories of distributed measurements and teleportation instruments generated by a bipartite mixed state. Next we quantitatively characterized the relations among the convex resource theories of distributed measurements, teleportation instruments, and bipartite mi…

'I know he's proud': Cowboys coach Brian Schottenheimer leans on life lessons from dad, Marty https://www.espn.com/nfl/story/_/id/45512273/nfl-dallas-cowboys-brian-marty-schottenheimer-fathers-day

👋 Hello! I’m Łukasz. Thirty-something, living in Warsaw, Poland. On fedi since 2021 or so. Right now, I'm merging my two accounts into one and giving this profile a fresh new start.
I live a few parallel lives.
Most of the time I’m a web developer. I work with TypeScript, React and all that jazz. But I still enjoy static site generators and good ol’ HTML/CSS.
In another life, I’m a documentary photographer and photojournalist. I’m interested in activism, art and culture, politics, and pretty much anything interesting happening on city streets. A big part of my photography journey involves documenting protests and demonstrations in Poland, especially those related to human rights and social issues. I’m also drawn to street art, particularly when it carries strong messages.
I occasionally blog and translate. Many years ago I wrote two books about WordPress. However, these days I’m more likely to go outside and touch grass than spend even more time in front of a screen.
Outside of that, expect me to post about mental health and politics. I promise to use CWs when appropriate.
I post in both English and Polish, depending on the topic.
Aaaand that’s it. Nice to meet you! ☺️
#introduction

On the spectral theory in the Fock space with polynomial eigenfunctions
A. V. Turbiner (deceased), N. L. Vasilevski (deceased)
https://arxiv.org/abs/2508.05924 https://

On the spectral theory in the Fock space with polynomial eigenfunctions
The notion of the eigenvalue problem in the Fock space with polynomial eigenfunctions is introduced. This problem is classified by using the finite-dimensional representations of the $\mathfrak{sl}(2)$-algebra in Fock space. In the complex representation of the 3-dimensional Heisenberg algebra, proposed by Turbiner-Vasilevski (2021) in Ref.7, this construction is reduced to the linear differential operators in $(\frac{\partial}{\partial \overline{z}}\,,\,\frac{\partial}{\partial z})$ acting on …

Nuclear Physics Confronts Relativistic Collisions Of Isobars
Giuliano Giacalone, Jiangyong Jia, Vittorio Som\`a, You Zhou, Anatoli Afanasjev, Massimiliano Alvioli, Benjamin Bally, Federica Capellino, Jean-Paul Ebran, Hannah Elfner, Fernando G. Gardim, Andr\'e V. Giannini, Fr\'ed\'erique Grassi, Eduardo Grossi, Jan Hammelmann, Andreas Kirchner, Dean Lee, Matthew Luzum, Hadi Mehrabpour, Emil G. Nielsen, Govert Nijs, Tamara Nik\v{s}i\'c, Jacquelyn Noronha-Hostler, Jean-Yve…

Nuclear Physics Confronts Relativistic Collisions Of Isobars
High-energy collisions involving the $A=96$ isobars $^{96}$Zr and $^{96}$Ru have been performed in 2018 at Brookhaven National Laboratory's Relativistic Heavy Ion Collider (RHIC) as a means to search for the chiral magnetic effect in QCD. This would manifest itself as specific deviations from unity in the ratio of observables taken between $^{96}$Zr+$^{96}$Zr and $^{96}$Ru+$^{96}$Ru collisions. Measurements of such ratios (released at the end of 2021) indeed reveal deviations from unity, but th…

Be (5) Yourself
An album featuring the sounds of the Hammond B3
#B3 #HammondB3 #NowPlaying

Be (5) Yourself #NowPlaying
Stan Stewart - @muz4now

from my link log —
Creating a read-only PostgreSQL user.
https://blog.crunchydata.com/blog/creating-a-read-only-postgres-user
saved 2021-05-12

Creating a Read-Only Postgres User | Crunchy Data Blog
Learn how to create a read only user in Postgres both now and with a look ahead to Postgres 14.

Down But Not Out: The Case of Long-Period Comet C/2021 O3 (Panstarrs)
David Jewitt. Jing Li, Michael Jaeger, Yoonyoung Kim
https://arxiv.org/abs/2506.09263

Down But Not Out: The Case of Long-Period Comet C/2021 O3 (Panstarrs)
We combine ground- and space-based observations of long-period comet C/2021 O3 (Panstarrs) (perihelion distance 0.287 au) in order to investigate its reported near-perihelion destruction. Pre-perihelion photometric observations show a remarkably small heliocentric dependence of the scattered light, $\propto r_H^{-s}$ with $s = 2.59\pm0.21$, distinct from values reported in other long-period comets, for which $s$ = 4 is the canonical standard. The index is smaller than expected of coma productio…

Anzahl der errichteten #Balkonkraftwerke pro Jahr in #Deutschland mit Stand vom 10.07.2025.
Unplausible Inbetriebnahmedaten von 1900 bis 2015 wurden durch das Registrierungsdatum der #Steckersolaranlage

Refuting Perfect Matchings in Spectral Expanders is Hard
Ari Biswas, Rajko Nenadov
https://arxiv.org/abs/2506.07700 https://arxiv.org…

Refuting Perfect Matchings in Spectral Expanders is Hard
This work studies the complexity of refuting the existence of a perfect matching in spectral expanders with an odd number of vertices, in the Polynomial Calculus (PC) and Sum of Squares (SoS) proof system. Austrin and Risse [SODA, 2021] showed that refuting perfect matchings in sparse $d$-regular \emph{random} graphs, in the above proof systems, with high probability requires proofs with degree $Ω(n/\log n)$. We extend their result by showing the same lower bound holds for \emph{all} $d$-regul…

May It Be Time #NowPlaying https://muz4now.com/2021/may-it-be-time-nowplaying/

May It Be Time #NowPlaying
Stan Stewart - @muz4now

Kumulativer Zubau von #Balkonsolarleistung in #Deutschland mit Stand vom 10.07.2025.
Die summarische Leistung aller offiziell registrierten #Steckersolaranlagen beträgt…

Wren Loud and Bold Ambient (2021-06) - Ambient soundscape from 16WW back garden birdlife; small bird makes big noise! #wren #soundscape #fieldRecording -

Anzahl der #Balkonkraftwerke in #Deutschland mit Stand vom 19.06.2025.
Der aktuelle Höchststand liegt bei 989236 registrierten Anlagen.
12.347 mehr als am 11.06.2025.
Unplausible Inbetriebnahmedaten von 1923 bis 2015 wurden durch das Registrierungsdatum der

🇵🇱 Cześć! Jestem Łukasz. Trójka z przodu. Warszawa. Na fedi mniej-więcej od 2021 r. Łączę dwa konta w jedno i od tej pory będzie tu więcej polskojęzycznych postów (a jeśli obserwowałxś mnie na polskojęzycznym koncie, to dostaniesz więcej treści po angielsku 😄).
Mam kilka równoległych żyć.
Przez większość czasu buduję rzeczy w internetach, głównie z użyciem TypeScriptu, Reacta i całej reszty tego jazzu. Ciągle jednak lubię generatory stron statycznych i stary dobry HTML/CSS.
W innym życiu jestem fotografem-dokumentalistą i fotoreporterem. Interesuje mnie aktywizm, sztuka, kultura, polityka oraz wszystko, co jest ciekawe, a dzieje się na ulicach miast. Dużo uwagi poświęcam protestom i demonstracjom w Polsce, zwłaszcza dotyczącym praw człowieka i kwestii społecznych. Interesuje mnie też sztuka uliczna, zwłaszcza taka, która niesie ze sobą mocne komunikaty.
Zdarza mi się blogować i tłumaczyć teksty. Wiele lat temu napisałem dwie książki o WordPressie. Obecnie jednak wolę gdzieś wyjść niż spędzać jeszcze więcej czasu przed ekranem.
Okazjonalnie zdarza mi się postować o zdrowiu psychicznym i polityce. Staram się używać CW kiedy to możliwe.
Postuję po polsku i angielsku w zależności od tematu.
No i... chyba tyle. Miło Cię widzieć!
#introduction #witajswiecie #przywitanie #wprowadzenie