> Google is your friend
But really, it's more like tolerated business partner, right?
1,176 karma · joined August 16, 2020
But really, it's more like tolerated business partner, right?
WITH lagged AS (
SELECT
*,
LAG(event_time) OVER (PARTITION BY user_id ORDER BY event_time) AS prev_time
FROM events
),
sessions AS (
SELECT
*,
SUM(COALESCE((date_diff('minute', prev_time, event_time) > 30)::INT, 1))
OVER (PARTITION BY user_id ORDER BY event_time) AS session_id
FROM lagged
)
SELECT
user_id,
session_id,
MIN(event_time) AS session_start,
MAX(event_time) AS session_end,
COUNT(*) AS event_count
FROM sessions
GROUP BY ALL
ORDER BY user_id, session_start;
result = (
df.sort(["user_id", "event_time"])
.with_columns(
session_id=(
pl.when(pl.col("event_time").diff().is_null())
.then(1)
.when(pl.col("event_time").diff().dt.total_minutes() > 30)
.then(1)
.otherwise(0)
.cum_sum()
.over("user_id")
)
)
.group_by(["user_id", "session_id"])
.agg(
session_start=pl.col("event_time").min(),
session_end=pl.col("event_time").max(),
event_count=pl.col("event_time").count(),
)
.sort(["user_id", "session_start"])
)Could an AI one day be suffering while plowing through some nasty legacy code? Well, who cares, I'll swing my whip, as I have a family to feed and a field to plow. I'll accept it as a fact and necessity, but ultimately it's either me or them. So practically it doesn't matter.
Did you miss the part where the convention was ratified by 180+ countries, because clearly society can't just take a seat?
> The convention [...] recognises certain powers and immunities of the aircraft commander who on international flights may restrain any person(s) he has reasonable cause to believe is committing or is about to commit an offence liable to interfere with the safety of persons or property on board or who is jeopardising good order and discipline.
I also once read a book on MS SQL Sever 200x, which I don't remember much of, and I don't think it was terribly useful anyway. If I wanted to know the size of a datatype I'd Google it.
The tests, sure. But certainly not the code itself, as that sits far too close to the implementation (i.e. it is the implementation). An almost infinite number of implantations can fulfill “does foo when bar”, so how can we prove that ours is the spec itself?
It’s kind of like a scientist coming up with a hypothesis post-hoc to fit the results of the experiment.
The house always… wins?
A few years ago in an old job I got a monster-specced Dell laptop, and it would still roar if I opened anything. I had to pull all the nerf tricks through the BIOS to at least keep it somewhat tolerable in low-load scenarios (i.e. most of the workday).
- LLMs scale with amount of data on the subject
- Even frontier labs themselves have a hard time gauging exactly how well-performing models are, across a quite rigorous set of tests in all aspects
then, how can this be true:
Using a low-data "niche language" (what is the volume of literature written in Caveman?) is supposedly of equal performance, when this anecdotally doesn't hold for e.g. niche code languages, proven by a handful of completely arbitrarily designed tests.
We've barely convinced ourselves that LLMs actually increase measurable industry productivity, instead of us just spending time to send slop to each other.
I thought it was green though.
Plus, a horizontal fridge is just… convenient. You can’t even put things on top of a vertical fridge.
But in an AI post-work future, all the sideways moves have also been taken over by AI and robots. After all, “knowledge work” as a discipline will not be there, right? Whether I can write code, manage teams or copywrite. All of them automated.
When the complexity vs cost of automation tips in the favor of humans, that’s where I’ll have to skill to. You said it, trucking, welding, … That I have a PhD in knowledge work is just worthless paper now.