@clflushopt
banner
clflushopt.bsky.social
@clflushopt
@clflushopt.bsky.social
recovering mathematician -- database hacker
Pinned
hello
Reposted by @clflushopt
Big Data on the Move: Can a Framework Laptop 13 ultrabook run terabyte-sized workloads with DuckDB?

@szarnyasg.org ran the experiments and shared his finding in our latest blog post: duckdb.org/2025/09/08/d...
Big Data on the Move: DuckDB on the Framework Laptop 13
We put DuckDB through its paces on a 12-core ultrabook with 128 GB RAM, running TPC-H queries up to SF10,000.
duckdb.org
September 8, 2025 at 7:19 PM
As someone who has exclusively used Rust, Go and C++ for the past 8+ years I find the JVM stack (lots of Java & Scala) a breadth of fresh air from a tooling and productivity perspective.
July 17, 2025 at 4:45 AM
Reposted by @clflushopt
I think I have finally managed to articulate this very fundamental but slightly counterintuitive fact about how shell redirection works
May 23, 2025 at 7:07 PM
Stopped once I hit the 18 seconds total runtime, code is available here github.com/clflushopt/s... might take this for another tour, still lots of tricks to pull (custom hashtable for the joins, morsel driven parallelism...)
May 15, 2025 at 6:04 PM
My work on SIGMOD 2025 (unregistered) continues my implementation now runs in 24 seconds instead of 11 minutes on my hardware (Ryzen 9 9950x), next goal is sub 10s.

I will write a blog post about this, since I was led down some dangerous paths hint blog.llvm.org/2011/05/what... #SIGMOD2025
May 1, 2025 at 1:06 AM
I am not having fun trying to reverse engineer and implement the TUM's db group paper on hash tables for join processing db.in.tum.de/~birler/pape...
db.in.tum.de
April 24, 2025 at 4:09 AM
Reposted by @clflushopt
@apachedatafusion.bsky.social supports a fully extensible range of user defined window functions as well as scalar, aggregate and table functions. Aditya Singh Rathore's new blog has more: datafusion.apache.org/blog/2025/04...
User defined Window Functions in DataFusion - Apache DataFusion Blog
datafusion.apache.org
April 19, 2025 at 10:15 AM
Reposted by @clflushopt
A great question -- and one that I used as a foundation for an entire talk
speakerdeck.com/bcantrill/th...
March 14, 2025 at 4:54 PM
Reposted by @clflushopt
can I code fast? no. but can I code well? also no. but does my code work? alas, no
November 30, 2024 at 9:39 PM
hello
November 8, 2024 at 7:23 PM