#duckdb_snippets — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #duckdb_snippets, aggregated by home.social.
-
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
-
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 -
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 -
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
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 -
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