Lmst

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?

#postgresql #sql #aggregate #function #clang #programming

Обходим подводные камни работы с UDA в коде на Lua для ScyllaDB: дружим Java-драйвер и пустые значения

Привет, Хабр! Мое имя Александр Коваль, я разработчик IoT-сервисов в МТС Web Services. Сейчас ScyllaDB поддерживает ограниченное количество функций, в том числе агрегационных. В стандартном наборе: min, max, count, avg. Но ее функциональность расширяется двумя типами пользовательских функций : скалярными (scalar functions) и агрегационными (aggregate functions). Первые работают со значениями одной строки, а вторые — нескольких. Реализовать такие функции можно на Lua или Rust. В процессе работы с агрегационными функциями можно столкнуться с тем, что ScyllaDB и Java-драйвер по-разному обрабатывают пустые значения. В этом посте я расскажу, как это можно решить относительно просто и без сложных дополнительных телодвижений. Для примера возьму код на Lua и покажу, как он реализуется в виде функции ScyllaDB. Дисклеймер: этот материал написан на основе личного опыта — все решения получены методом проб и ошибок. Конструктивные предложения и советы по их улучшению приветствуется. Код с примерами и ссылки на ресурсы можно найти у меня в репозитории GitHub .

https://habr.com/ru/companies/ru_mts/articles/902544/

#scylladb #java #function #driver #база_дынных #uda #Драйвер_Java_Data_Base_Connectivity #Агрегационные_функции #базы_данных #обработка_данных

⚡️ Quick tips for R function returns! Learn about explicit vs implicit returns and how to document your functions. Read the full guide and share your thoughts!

👉 How to Return Value from a Function in R: https://www.spsanderson.com/steveondata/posts/2025-04-21/

#Rstats #Rprog #Data #Code #Learn #Tips #Blog #Function #Return #Programming

⚡️ Quick tips for R function returns! Learn about explicit vs implicit returns and how to document your functions. Read the full guide and share your thoughts!

👉 How to Return Value from a Function in R: https://www.spsanderson.com/steveondata/posts/2025-04-21/

#Rstats #Rprog #Data #Code #Learn #Tips #Blog #Function #Return #Programming

Unicursal ABSOLUTE RULE ABSOLUTE LIBERTY INDIVIDUAL WILL Propaganda from Hermetic Library Office of the Ministry of Information https://hermetic.com/information/absolute-rule-absolute-liberty-individual-will/index

#propaganda #thelema #rule #state #function #liberty #individual #will

Square image blue background, white text. In the style of the WWII propaganda series from the UK, of which Keep Calm is one. Instead of a crown, an unicursal hexagram, because it bugs some certain people. The words are, from a Crowley essay on government, "The absolute rule of the state shall be a function of the absolute liberty of each individual will." The words "absolute rule", "absolute liberty", and "individual will" are underlined.

#propaganda #thelema #rule #state #function #liberty #individual #will

Perspective changes everything...

#Math #Function

How to Improving the Strategy Design Experience
In order to make strategy design more convenient, trading logic clearer, and easier for beginners to get started, the platform has upgraded the API interface used by the strategy. Dockers using the latest version can enable these new features.
#docker #strategy #crypto #trading #API #interface #exchange #order #OKX #function
https://www.fmz.com/bbs-topic/10456

“We require from buildings two kinds of goodness: first, the doing their practical duty well: then, that they be graceful and pleasing in doing it.” — John Ruskin

#Architecture #Design #Function #Beauty #Grace #Craftsmanship #Structure #Elegance #Aesthetics #Form #buildings #goodness #JohnRuskin #inspired #inspiration #inspiringquotes #quotes #construction

One day, one decomposition
A217139: Numbers n such that phi(n) = phi(n+12), with Euler's totient function phi = A000010

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A217139.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A217139.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #Euler #totient #function #phi #graph #threejs #webGL

Decomposition into weight × level + jump of A217139 in 2D (log(weight), log(level))

Decomposition into weight × level + jump of A217139 in 3D (threejs - WebGL) (log(weight), log(level), log(jump))

“The Book of the Law was given to mankind chiefly in order to provide it with an impeccable principle of practical politics. I regard this as more important for the moment than its function as a guide in its evolution towards conscious godhead.”

https://library.hrmtc.com/2025/04/03/the-book-of-the-law-was-given-to-mankind-chiefly-in-order-to-provide-it-with-an-impeccable-principle-of-practical-politics-i-regard-this-as-more-important-for-the-moment-than-its-function-as-a-guid/

#aleisterCrowley #book #chiefly #consciousGodhead #evolution #forTheMoment #function #givenTo #guide #impeccablePrinciple #inOrderTo #mankind #moreImportant #practicalPolitics #provide #quote #regardThisAs #TheBookOfTheLaw #TheConfessionsOfAleisterCrowley

Hermetic quote Crowley Confessions the book of the law given mankind chiefly in order to provide impeccable principle practical politics more important function guide evolution conscious godhead

Looking for ideas for building a little #Rstats function.

Let's say I asked a bunch of people if they felt older, younger, or the same age as half a dozen randomly-selected ages.

Let's say that because that's what I did.

Example: Jane is asked this question about ages 17, 19, 25, 38, 41, and 52.

Each person answers younger/same/older to each of the ages (each person also gets a different selection of ages to answer).

Ultimately, I want to use those answers to get an estimate of the age each person feels. First, however, I want to see how numerically consistent each person's answers are.

Examples: if Jane said
17: older
19: older
25: older
38: same age
41: younger
52: younger

That's numerically consistent. However, if she said

17: older
19: younger
25: older
38: same age
41: older
52: younger

that's not consistent (she can't be both younger than 19 and older than 41).

It's also consistent if she said she felt younger than all the ages or older than all of them.

Maybe because it's late or maybe because I'm slow, I'm having a hard time approaching this. I'll leave it on the back burner for a couple of days since it's late where I am and I won't have time for it tomorrow.

If any of y'all (and many of you are ridiculously more quantitatively skilled than I am) have ideas of how to approach a function for this, or -- even better -- if a solution already exists as a formula or something, lay it on me. I'll be in your debt*.

*up to but not surpassing verbal compliments and possibly $2 USD

#help #statistics #math #function #formula #problem

I fear it is still a long way to get #CSS #function schemed-value() to return more color values extending light-dark function

https://www.bram.us/2023/10/09/the-future-of-css-easy-light-dark-mode-color-switching-with-light-dark/

thx to @niya-d.bsky.social for focussing in her talk on #CSS #function #light-dark #a11y
and I will check out the proposed schemed-value :) #SotB2025

https://web.dev/articles/light-dark#introducing_light-dark

Gemma3 Function Calling

https://ai.google.dev/gemma/docs/capabilities/function-calling

#HackerNews #Gemma3 #Function #Calling #AI #Technology #Functionality #Google #Developers

Python – Functions

https://peertube.wtf/w/mDgTYK7qeGyMYDsjNXNbkc

→ #Speedrunners are #vulnerability researchers, they just don't know it yet
https://zetier.com/speedrunners-are-vulnerability-researchers/

“Super Mario World runners will place items in extremely precise locations so that the X,Y coordinates form #shellcode they can jump to with a dangling reference. Legend of #Zelda: Ocarina of Time players will do heap grooming and write a #function pointer […] so the game “wrong warps” directly to the #end #credit sequence… with nothing more than a #game #controller and a steady #hand”

#Mario

The Fourier Transform is a mathematical operation that transforms a function of time (or space) into a function of frequency. It decomposes a complex signal into its constituent sinusoidal components, each with a specific frequency, amplitude, and phase. This is particularly useful in many fields, such as signal processing, physics, and engineering, because it allows for analysing the frequency characteristics of signals. The Fourier Transform provides a bridge between the time and frequency domains, enabling the analysis and manipulation of signals in more intuitive and computationally efficient ways. The result of applying a Fourier Transform is often represented as a spectrum, showing how much of each frequency is present in the original signal.

\[\Large\boxed{\boxed{\widehat{f}(\xi) = \int_{-\infty}^{\infty} f(x)\ e^{-i 2\pi \xi x}\,\mathrm dx, \quad \forall\xi \in \mathbb{R}.}}\]

Inverse Fourier Transform:
\[\Large\boxed{\boxed{ f(x) = \int_{-\infty}^{\infty} \widehat f(\xi)\ e^{i 2 \pi \xi x}\,\mathrm d\xi,\quad \forall x \in \mathbb R.}}\]

The equation allows us to listen to mp3s today. Digital Music Couldn’t Exist Without the Fourier Transform: http://bit.ly/22kbNfi

#Fourier #FourierTransform #Transform #Time #Frequency #Space #TimeDomain #FrequencyDomain #Wavenumber #WavenumberDomain #Function #Math #Maths #JosephFourier #Signal #Signals #FT #IFT #DFT #FFT #Physics #SignalProcessing #Engineering #Analysis #Computing #Computation #Operation #ComplexSignal #Sinusoidal #Amplitude #Phase #Spectra #Spectrum #Pustam #Raut #PustamRaut #EGR #Mathstodon #Mastodon #GeoFlow #SpectralMethod

Motivation:

Let $X\subseteq \mathbb{R}$ and $Y\subseteq\mathbb{R}$ be arbitrary sets, where we define a function $f:X\to Y$.

I want a measure of discontinuity which ranges from zero to positive infinity, where

• When the limit points of the graph of $f$ is continuous almost everywhere, the measure is zero
• When the limit points of graph of $f$ can be split into functions, where $n$ of those functions are continuous almost everywhere, the measure is $n-1$
• When $f$ is discrete, the measure is $+\infty$
• When $f$ is "hyper-discontinuous" [1], the measure is $+\infty$
• When the graph of $f$ is dense in the derived set of $X\times Y$, the measure is $+\infty$
• When the measure of discontinuity is between zero and infinity, the more "disconnected" the graph of $f$, the higher the measure of discontinuity.

Question 1: How do we fix the criteria in the motivation, so they are consistent with eachother?

Question 2: Is there a measure of discontinuity which gives what I want?

Attempt: I tried to answer [2] this using a previous question, but according to users it's needlessly complicated and likely is incorrect. I'm also struggling to explain why this answer [2] has potential.

[1]: https://math.stackexchange.com/questions/4347133/do-these-hyper-discontinuous-functions-exist

[2]: https://math.stackexchange.com/a/5025279/125918

#measure #continuity #discontinuity #function