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
- 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
and even though the docs only reference Parquets, you can use CSVs too
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
duckdb.org/docs/stable/... helpful way of organizing your data that can take advantage of partial data loads
Why not use hive_partitioning?
November 18, 2025 at 9:42 PM
Why not use hive_partitioning?
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
The pain of having to go back to the SELECT block to get Intellisense ugh.. FROM first would be incredible.
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.
one of the agents picked up and threw congressional candidate kat abughazaleh to the ground.
September 19, 2025 at 11:46 AM
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.
one of the agents picked up and threw congressional candidate kat abughazaleh to the ground.
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
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.