Profile avatar
urrutia.bsky.social
Data | Bass Another DuckDB enthusiast ATX
223 posts 77 followers 145 following
Regular Contributor
Active Commenter
Posts 17 Comments 33

Dropping a cheatsheet to share some #DuckDB basics Check out some of the easy stuff to get started Going to continue rolling out more soon Stay tuned

submitted 86 days ago • 0 comments

the crŷptö böts made it

submitted 93 days ago • 0 comments

🔥 SQL Pro Tips: Filtering in the right place 🚀 HAVING: Filter groups after aggregation. QUALIFY: Filter results of window functions. FILTER: Exclude rows before aggregating. Master these, and SQL gets so much cleaner! 💡 #DuckDB

submitted 94 days ago • 0 comments

This is a pretty powerful query We're combining window functions, quantile analysis, and custom window definition to provide detailed insights The query uses a named window with a complex order and partition and the query references the window defined after the FROM clause #duckdb

submitted 96 days ago • 0 comments

Query and query_table - dynamic sql Macros in DuckDB

submitted 98 days ago • 0 comments

Creative Architecture is where this can be explored. Cryptic enough?

submitted 98 days ago • 0 comments

Finder and search bar have been and continue to be garbage

submitted 98 days ago • 0 comments

high powered ephemeral analytics at a fraction of the cost

submitted 98 days ago • 0 comments

Are all things named Lumon or alike not to be trusted?

submitted 98 days ago • 0 comments

Interactive Analysis Pipeline Component "Creative Architecture" -> This just means lambda functions on my phone. What am I talking about?

submitted 99 days ago • 0 comments

Life is funny like that

submitted 99 days ago • 0 comments

#DuckDB offers unique and flexible SQL capabilities - EXCLUDE to remove specific cols in a select - REPLACE to modify and replace col values - COLUMNS to select, filter, or agg based on regex - Aliases that can be accessed in WHERE and HAVING - GROUP BY and ORDER BY ALL to simplify grouping - SAMPLE

submitted 100 days ago • 0 comments

You should use CTEs instead of subqueries: 1. nested subqueries are not allowed to reference themselves. 2. CTEs will make individual aggregates that can then reference each other 3. Recursion in SQL is possible because of CTEs, making it possible to reference a CTE from within itself #duckdb

submitted 101 days ago • 1 comment

DuckDB - Import / Export Formats CSV JSON Parquet Partitioned Data Lakes Relational DB

submitted 102 days ago • 0 comments

SQL is the past, present, and future. If you think otherwise, you're wrong

submitted 106 days ago • 1 comment

What is DuckDB? - An in-process analytical database system - It's free, open-sourced, and designed for OLAP tasks. - Focuses on fast, vectorized processing.

submitted 106 days ago • 1 comment

DuckDB deep-dive Let's get it

submitted 106 days ago • 1 comment