Patrick
banner
psanker.me
Patrick
@psanker.me
I mainly shitpost about SQL Server

- data dude at local hospital
- takes photos 4 fun
- New Mexican in New York
- R, OCaml, and DuckDB shill
and even though the docs only reference Parquets, you can use CSVs too
November 18, 2025 at 9:46 PM
duckdb.org/docs/stable/... helpful way of organizing your data that can take advantage of partial data loads
Hive Partitioning
Examples Read data from a Hive partitioned dataset: SELECT * FROM read_parquet('orders/*/*/*.parquet', hive_partitioning = true); Write a table to a Hive partitioned dataset: COPY orders TO 'orders' (...
duckdb.org
November 18, 2025 at 9:45 PM
Why not use hive_partitioning?
November 18, 2025 at 9:42 PM
The pain of having to go back to the SELECT block to get Intellisense ugh.. FROM first would be incredible.
November 18, 2025 at 4:17 PM
Reposted by Patrick
moments ago, ice agents again came out of the broadview detention/“professing” facility to escort a silver suv out of the lot.

one of the agents picked up and threw congressional candidate kat abughazaleh to the ground.
September 19, 2025 at 11:46 AM
Ironically (perhaps), I have observed better professionalism in research practices outside of academia than I have inside of it. Very much agree with your points about the failings of the open science movement.
July 9, 2025 at 3:40 PM
📌
May 4, 2025 at 5:05 PM