Stéphan MestachOct 11

Re-compressing a parquet file with duckdb

copy (select * from 'existing.parquet' ) to 'compressed.parquet' (FORMAT PARQUET, COMPRESSION 'ZSTD', ROW_GROUP_SIZE 10000);

from to 195MB to 125MB

#duckdb #duckdb_snippets

 Hacker NewsApr 24, 2025
Instant SQL for results as you type in DuckDB UI
https://motherduck.com/blog/introducing-instant-sql/
#ycombinator #duckdb #snippets #duckdb_snippets #duckdb_snippets_com #Instant #SQL #here #Speedrun #ad_hoc #queries #you #type #MotherDuck #Blog
Instant SQL is here: Speedrun ad-hoc queries as you type - MotherDuck Blog

Type, see, tweak, repeat! Instant SQL is now in Preview in MotherDuck and the DuckDB Local UI. Bend reality with SQL superpowers to get real-time query results as you type. | Reading time: 8 min read

MotherDuck
 Hacker NewsOct 17, 2024
The Prompt() Function: Use the Power of LLMs with SQL
https://motherduck.com/blog/sql-llm-prompt-function-gpt-models/
#ycombinator #duckdb #snippets #duckdb_snippets #duckdb_snippets_com #Introducing #the #prompt #Function #Use #Power #LLMs #with #SQL
Introducing the prompt() Function: Use the Power of LLMs with SQL! - MotherDuck Blog

We make your database smarter with small language model (and LLM) support in SQL | Reading time: 6 min read

MotherDuck
 Hacker NewsMay 27, 2024
Big data is dead (2023)
https://motherduck.com/blog/big-data-is-dead/
#ycombinator #duckdb #snippets #duckdb_snippets #duckdb_snippets_com #Big #Data #Dead
Big Data is Dead - MotherDuck Blog

Big data is dead. Long live easy data. | Reading time: 19 min read

MotherDuck
 Hacker NewsMar 12, 2024
Differential storage: A key building block for a DuckDB-based data warehouse
https://motherduck.com/blog/differential-storage-building-block-for-data-warehouse/
#ycombinator #duckdb #snippets #duckdb_snippets #duckdb_snippets_com #Differential #Storage #Key #Building #Block #For #DuckDB_Based #Data #Warehouse
Differential Storage: A Key Building Block For A DuckDB-Based Data Warehouse

Differential Storage: A Key Building Block For A DuckDB-Based Data Warehouse

MotherDuck
 Hacker NewsMar 12, 2024
Differential Storage: A Key Building Block for a DuckDB-Based Data Warehouse
https://motherduck.com/blog/differential-storage-building-block-for-data-warehouse/
#ycombinator #duckdb #snippets #duckdb_snippets #duckdb_snippets_com #Differential #Storage #Key #Building #Block #For #DuckDB_Based #Data #Warehouse
Differential Storage: A Key Building Block For A DuckDB-Based Data Warehouse

Differential Storage: A Key Building Block For A DuckDB-Based Data Warehouse

MotherDuck
 Hacker NewsMar 10, 2024
Perf Is Not Enough
https://motherduck.com/blog/perf-is-not-enough/
#ycombinator #duckdb #snippets #duckdb_snippets #duckdb_snippets_com #Perf #not #enough
Perf is not enough - MotherDuck Blog

Are database benchmarks still relevant ? Let's understand why it's a poor way to choose a database. | Reading time: 17 min read

MotherDuck
 Hacker NewsJan 25, 2024
An open source DuckDB text to SQL LLM
https://motherduck.com/blog/duckdb-text2sql-llm/
#ycombinator #duckdb #snippets #duckdb_snippets #duckdb_snippets_com #That #Quacks #Introducing #DuckDB_NSQL_7B #LLM #for #DuckDB
AI That Quacks: Introducing DuckDB-NSQL-7B, A LLM for DuckDB

Our first Text2SQL model release!

MotherDuck