@clflushopt @clflushopt.bsky.social · 02/09/2026My current Zig impressions is that its fun to work with every task you want to do ends up being full of side quests. Haven't had this much fun in a while. 010
@clflushopt @clflushopt.bsky.social · 26/08/2026our nicely crafted TPC-H/TPC-DS generators at crates.io/crates/tpchgen have now a new home at github.com/datafusion-c...crates.iocrates.io: Rust Package Registrycrates.io serves as a central registry for sharing crates, which are packages or libraries written in Rust that you can use to enhance your projects 010
@clflushopt @clflushopt.bsky.social · 28/07/2026After my previous post I got nerdsniped by@alexmillerdb.bsky.social about what an optimal IR for dbs would look like and since i am on vacation it's starting to look like a very long read 110
@clflushopt @clflushopt.bsky.social · 19/07/2026finally managed to finish a draft i started working on a month ago about Inkfuse, continuations and query execution paradigms deferworks.org/posts/inkfus...deferworks.orgInkfuse, Continuations and Query Compilation | Opinions on Software.Ramblings on databases, compilers and software matters. 071
Reposted by @clflushoptAndrew Lamb @andrewlamb1111.bsky.social · 19/07/2026Nice example of evaluating filters on compressed data: This post from Martin Prammer and @spiraldb.com is a spiraldb.com/blog/pattern...spiraldb.comPattern Matching on Compressed Strings without DecompressionEvaluating SQL LIKE directly on FSST-compressed strings: a symbol-aware automaton and a SIMD prefilter let Vortex match without decompressing the column first. 062
Reposted by @clflushoptAndrew Lamb @andrewlamb1111.bsky.social · 03/07/2026Make TPC-H data scale factor 10 faster than you can type the command (under 10 sec). The new release of tpchgen-cli is out -- try it via uvx uvx tpchgen-cli parquet --scale-factor=10 Huge thanks to @clflushopt.bsky.social and @kevinjqliu.bsky.social 062
Reposted by @clflushoptMatt Drake @drakemt.bsky.social · 09/05/2026Mike Matheson just rips one through traffic and it's 2-0 #Habs 1356
Reposted by @clflushoptFCLC (being a silly goose) @fclc.bsky.social · 29/11/2024With the next product launch season fast approaching, a reminder of the first question you should *always* be asking when a figure of merit is presented without context: #HPC 610115
Reposted by @clflushoptDuckDB @duckdb.org · 08/09/2025Big 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...duckdb.orgBig Data on the Move: DuckDB on the Framework Laptop 13We put DuckDB through its paces on a 12-core ultrabook with 128 GB RAM, running TPC-H queries up to SF10,000. 3305
@clflushopt @clflushopt.bsky.social · 17/07/2025As 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. 110
Reposted by @clflushoptJulia Evans @b0rk.jvns.ca · 23/05/2025I think I have finally managed to articulate this very fundamental but slightly counterintuitive fact about how shell redirection works 945263
@clflushopt @clflushopt.bsky.social · 15/05/2025Stopped 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...)github.comGitHub - clflushopt/sigmod-2025: My solution to the SIGMOD 2025 contest (non-registered).My solution to the SIGMOD 2025 contest (non-registered). - clflushopt/sigmod-2025 010
@clflushopt @clflushopt.bsky.social · 01/05/2025My 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 000
@clflushopt @clflushopt.bsky.social · 24/04/2025I 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 000
Reposted by @clflushoptAndrew Lamb @andrewlamb1111.bsky.social · 19/04/2025@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...datafusion.apache.orgUser defined Window Functions in DataFusion - Apache DataFusion Blog 071
Reposted by @clflushoptBryan Cantrill @bcantrill.bsky.social · 14/03/2025A great question -- and one that I used as a foundation for an entire talk speakerdeck.com/bcantrill/th...speakerdeck.comThings I Learned the Hard WayTalk given to the engineering team at Rokt on November 9th, 2023. Video: https://www.youtube.com/watch?v=bJ0y7Oqr4Zo 1423
Reposted by @clflushoptSeven Machina Rasmussen @toomanyspectra.bsky.social · 30/11/2024can I code fast? no. but can I code well? also no. but does my code work? alas, no 401182062114