Real Randy
banner
emotional-schema.bsky.social
Real Randy
@emotional-schema.bsky.social
It’s really me
They just need to sell it already in a whiskey flask for treatment on the go
January 17, 2025 at 12:38 PM
This guy’s living in 9999
December 17, 2024 at 1:14 PM
THE BEST
December 17, 2024 at 10:35 AM
Raycast is my favorite tool of all time. You gave me my original invite 🙏

I think they’ve got the best wrapped around. I lost half my history this year moving to a databricks laptop but still so fun to see.

Spotify was my top app for sure haha.
December 17, 2024 at 10:30 AM
What?? Snowflake iceberg is parquet in s3
December 13, 2024 at 3:18 PM
What are the two sides
December 13, 2024 at 1:49 AM
I knew I had to be missing something. Thank you, Danny.

Even the example records weren’t making sense the way I read the problem
December 12, 2024 at 1:22 PM
I bet the min isn’t needed as well. The days difference will be null for it and that can be turned into a true in the case statement assuming no null dates in the input.
December 12, 2024 at 2:34 AM
Then you do a case statement:
- If date is the min date, true
- if days diff is greater than 90 (or any arbitrary cooldown), also true
- otherwise false
December 12, 2024 at 2:31 AM
What if you add a window function computing the days of diff between the current and previous entry sorted by date.

Also grab the min date while you’re at it. This is more useful if you need to run this for multiple partitions instead of for just the entire table.

Then…
December 12, 2024 at 2:29 AM
I’ve been thinking about this.

I think an annoying computer science approach can do this without recursion.

I think it’ll run nlogn as well.

I need some paper
December 12, 2024 at 2:26 AM
This comes back to the core missing piece in duck imo. No catalog support.
December 12, 2024 at 12:44 AM
That’s the beauty of it! The answer is always sql hahaha
December 11, 2024 at 12:34 AM
I think you can run duckdb in python. I’ve installed it for a demo but I’m not sure if that is what you mean.
December 11, 2024 at 12:34 AM
Trash. Offensive
December 11, 2024 at 12:09 AM
SQL
December 9, 2024 at 2:05 PM
Bigquery and databricks sql both have it on lock too 💪
December 9, 2024 at 2:04 PM
Let’s smoke about it. King sized
November 29, 2024 at 2:45 PM
1 - Poetry just because it works. I don’t package and distribute Python libraries so I have pretty basic package management needs. No opinion on uv either way.

2 - Nothing fancy like that, I just wanted a minimal prompt. It was just trickier than I expected haha
November 28, 2024 at 4:50 AM
I’m a poetry guy, but this would work so nicely there too. Thank you for sharing.

My zshrc is filled with my nonsense language of aliases and a surprisingly long chunk to make my terminal prompt just be a battery emoji 🔋
November 28, 2024 at 1:36 AM