Stream to stream joins are NOT currently supported. This is a regularly requested feature, and I'll look at prioritizing it.
SQLFlow uses duckdb internally for windowing and stream state storage :), and I'll look at extending it to support stream / stream joins.
Could you describe a bit more about your use case? I'd really appreciate it if you could create an issue in the repo describing your use case and desired functionality a bit!
should have made it enterprise software for HMOs - they profit when their population has better outcomes. Or sell it Epic or something and they'd package it into their systems.
Are you asserting that the government (and the public) will get more utility (benefit) from the extra 1 dollar on its $2.7 billion budget (increase of .000 000 04 percent), than I would from the extra dollar in my net annual income (on the order of a thousandth of a percent)?
On a per-dollar basis, you indeed get more marginal utility from the extra dollar than the government would.
But on a percentage basis (in a progressive taxation scheme, and especially in the higher tax brackets) the government gets more marginal utility from a 1% tax increase than you would from a 1% tax break.
In any bracket and at any percentage, the government will be adding $x to it's huge budget by taking $x from an individual or organization's much smaller budget.
(* Note that it really isn't valid to compare marginal utility between entities. It's an individual, relative measure, rather than an absolute quantity.)
It seems like they are making the case that if reality is biased then models of reality will retain that bias.
If so they seem to make the point well.
If the only information you have about a loan applicant is where they live, your decision will be 'biased' if the location of where someone lives is correlated with other factors (as opposed to, say, the fact they live on a flood plain means don't give them a loan).
In this context, saying "Math is Racist" is like saying "Physics hates Fat People" because gravity disproportionately affects heavier people. Accurately reporting what is happening is not biased, making decisions without considering [edit: or not making a decision because you didn't consider] the context is biased.
Maths is a tool (well, collection of tools), and the onus is first on the tool user to use it in a fair way. Yes it is important for educators and tool creators to be mindful of how these tools will be used in practice, but there is a big jump from that idea to "Math is Racist".
Isn’t this a similar argument that could be made against race and gender based affirmative action? I don’t understand how organizations like ACLU are critical of face recognition tech because it reenforces implicit bias that engineers have but then turns around and supports race and gender based affirmative action that similarly reenforces implicit bias where PoC (but not Asians for some reasons) and non-males are presumed to be disadvantaged purely due to their identity.
I'm not sure what argument you are referring to here (if it was one above).
I think these organisations are criticising the tool builders for creating tools that are easily misused (or are created with unreasonable limitations, like only being valid for university students at one university, but are sold as widely applicable).
Supporting affirmative action initiatives like you list is trying to address the biases that exist in reality. I think this is often a bit backward (not addressing the root cause) but it can be expensive (in time, effort, money, politics) to address the actual root cause so these programs aim to address the bias at the place in manifests.
This is a similar (dare I say pragmatic?) argument to "it would be cheaper and more effective to just give everyone a no-strings attached payment each month then to provide means-tested payments to those who need help".
Detrmining if these arguments are correct is a different thing altogether, and I have no idea if these programs are cheaper and more effective then dealing with the root problem, or if it's even possible to define and address the root problem in the first place!
The two things you contrast above are fundamentally different - one is criticising tools and tool builders, the other trying to address perceived biases in the world.
When you say "[non-white/non-males] are presumed to be disadvantaged", have you talked to or listened to black or female academics? I follow ~4 black academics on twitter, and each of them have contributed to the #BlackintheIvory topic. Their identity plays a huge role in how others treat them.
> but not Asians for some reasons
Asian people are distinct because so many of them have immigrated recently, and immigration requirements favor educated and well-off folks. That masks many issues because they should have better than average outcomes due to better than average education and skills.
They dock from the side. It works with Linux too except I have this annoying bug where my attached monitor turns off and back on randomly a few times per day.
There was an episode of Nova about energy storage that included a company that made kinetic energy storage devices. IIRC they had 5000 pound flywheels that spin in a vacuum and can be installed in your home. Expensive to purchase and install but essentially unlimited lifespan and totally renewable.
Came in here to post this. This guy is unhinged by the way. He came in to give a talk in a course I was taking at UC Berkeley and as he continued to ramble on he noticed the students starting to glance at the clock on the wall above his head. He went off on a half-baked rant about how clocks don't matter and we should think for ourselves or something, then he stands up ON A CHAIR WITH WHEELS and pulls the clock off the wall. This guy is not young obviously - I was standing under him ready to catch him if he fell and the whole class was horrified.
“Unhinged” is a pretty uncharitable description, and your “horrified” class sounds a bit closed-minded.
Another way to describe the same is “excitable, passionate, and non-conforming”.
But I would instead say “Cliff Stoll is a national treasure”. I’m super jealous of the middle school kids who got to have him as their science teacher.
I feel like the world needs more people like Clifford Stoll. He represents one of the last vestiges of the "old, weird America", from a time when "Think Differently" meant something real and wasn't a marketing slogan. Sure he's eccentric, but that's what makes him unique, and I tend to optimize for uniqueness when it comes to things like art, literature, music, and even science.
I read his book The Cuckoo's Egg when I was in high school and I found it vastly entertaining and enlightening. It's dated now but I think people could still get something out of reading it.
I saw him speak in the late 1990s. He was absolutely a character, but also a fantastic speaker. Nobody was looking at their watches at the (well-attended) talk I was at.
>He went off on a half-baked rant about how clocks don't matter and we should think for ourselves or something
I had a conversation recently with someone who was telling me how visiting Cape Canaveral didn't convince them of the existence of space travel. This comment is eliciting a similar feeling of despair.
The DLQ and Prometheus integration out of the box are nice.