Sun Aug 25 07:25:16 GMT 2024

duckdb

Operation Snippet
Pretty-printing floats SELECT (10 / 9)::DECIMAL(15, 3);
Copying the schema CREATE TABLE tbl AS FROM example LIMIT 0;
Shuffling data FROM example ORDER BY hash(rowid + 42);
Specifying types when reading CSVs FROM read_csv('example.csv', types = {'x': 'DECIMAL(15, 3)'});
Updating CSV files in-place COPY (SELECT s FROM 'example.csv') TO 'example.csv';

https://duckdb.org/2024/08/19/duckdb-tricks-part-1.html


(google search) (amazon search)
1 2 3 second