Composable Queries with DuckDB

In this video, we'll learn about DuckDB's relational API that's available in the Python package.
Resources ▼
▶ Gwen Shapira: Things Databases don't do but should - www.thenile.de...
▶ Jeff Sackmann's Tennis Repository - github.com/Jef...
▶ DuckDB's Relational API - duckdb.org/doc...

[@danieleden1856]

Great video mate, reminds me a lot of ORM style composition against datasets but with the added benefit of columnar storage with duck

[@learndatawithmark]

Yeh it's gonna be interesting to see how that feature develops over time because it's definitely helpful to not have to write queries from scratch every time!

[@shibak4]

Fantastic demo, Mark. Thank you.

[@learndatawithmark]

Thanks :)

[@omarmoreira86]

Mark, amazing work with duckdb videos. You're the best! Regards from Brazil!

[@learndatawithmark]

Thanks Omar!

[@alfredoramirez3813]

Your videos are awesome.. thx

[@learndatawithmark]

Thanks, I'm glad you like them!

[@kuatroka]

Thanks for the video. Great as usual. One slightly tangental question: are there any mechanism in DuckDB to accomplish what Materialised Views or Projections do? That is, updated the aggregated data on the fly in the target table as soon as the source/staging table gets updated or the only mechanism is to have an ETL pipeline? I'm asking in the context of python. 1. Loading parquet to staging DuckDB table > 2. real-time update of an aggregated table. Thanks

[@learndatawithmark]

As far as I know there isn't, but I did find a discussion about implementing the feature over here - github.com/duckdb/duckdb/discussions/3638

[@ivan-nm1xn]

Loved it! Btw, what repl is this?

[@learndatawithmark]

That's the DuckDB CLI

[@Vikramhhj]

How to install duckdb for windows

[@learndatawithmark]

Did you try the instructions on the installation page? duckdb.org/docs/installation/