urrutia.bsky.social
Data | Bass
Another DuckDB enthusiast
ATX
223 posts
77 followers
145 following
Regular Contributor
Active Commenter
comment in response to
post
advent of come as you are
comment in response to
post
thanksgiving food in general is overrated but especially turkey
comment in response to
post
navigation without direction is fun. 5.5 is fun
that checks out
that game is a great gen
comment in response to
post
what age we at?
comment in response to
post
😂
comment in response to
post
interesting take if databricks said that because value at gold depends on quality at bronze
comment in response to
post
it’s always a nice treat to find good music on the smaller stages
or even be like “oh wait i know this song—this is THAT band?”
comment in response to
post
saw them 8 times on this last tour including marko djing twice
i feel you
comment in response to
post
went to a cory wong show (not even a huge fan)
the opener is now currently one of my favorite bands
comment in response to
post
this is always the best imo
comment in response to
post
we have different experiences
I think you can come across some hidden gems
comment in response to
post
i think you’re already doing that regardless by going
comment in response to
post
tell me more
comment in response to
post
the man for the job
comment in response to
post
friday would be the day i recognize the most artists
tell the 38 and older to check out parcels
comment in response to
post
People are overreacting about this lineup.
It’s definitely niche but there’s at least 5 artists I’d see each day.
Never been to coachella but festivals are also where you find artists you don’t know—that’s kinda the point
comment in response to
post
dystopian world where dreaming can change the outcomes irl?
comment in response to
post
🦆
comment in response to
post
comment in response to
post
👋
comment in response to
post
🙌
comment in response to
post
Note: In transactional systems, CTEs can add planning overhead. Use them judiciously where performance is critical.
s/o @matsonj.bsky.social for the call out
comment in response to
post
I've never used V8 but I've heard dependencies are annoying and there's too much complexity for versions/compatibility
comment in response to
post
oh no doubt, I'm 100% just complaining and impatient
hope it's worth the wait
comment in response to
post
still waiting for severance season 2
comment in response to
post
Looking at a high-level overview of the query-processing pipeline
comment in response to
post
Extensibility:
- Modular etension system
- WebAssembly support
- HTTP access capabilities
- Full-text search options
- JSON processing features
comment in response to
post
Transaction Management:
- ACID compliant
- snapshot isolation
- MVCC (Multi-version concurrency control)
- Optimized for vectorized processing
comment in response to
post
Data Format Support:
- Native Parquet reader/writer
- CSV and JSON support
- Direct connections to Postgres/SQLite
- Query external data sources
comment in response to
post
Execution Model:
- Push-based execution architecture
- Centralized Control Flow
- Supports Asynchronous I/O
- Built-in backpressure handling
comment in response to
post
Parallelism and Performance:
- DuckDB transitioned from pull-based to a push-based execution model to improve parallel processing.
- Multi-threaded execution and morsel-driven parallelism
- Optimized for multi-core systems
comment in response to
post
Storage- Columnar and Single-File:
- Single-file database like SQLite
- Columnar storage format
- Uses row groups for parallelization
- Per-column compression
comment in response to
post
Vectorized Processing Engine:
- DuckDB uses a vectorized push-based model
- Efficient data processing with custom vector formats optimized for execution.
- Optimized for analytical workloads.