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!
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
![[LIVE] : ONE ลุมพินี 89 | คู่เอก "ยอดไอคิว vs คิริลล์"](http://i.ytimg.com/vi/Z3vYkHJ_5Ig/mqdefault.jpg)
Great video mate, reminds me a lot of ORM style composition against datasets but with the added benefit of columnar storage with duck
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!
Fantastic demo, Mark. Thank you.
Thanks :)
Mark, amazing work with duckdb videos. You're the best! Regards from Brazil!
Thanks Omar!
Thank you for this very useful video!
Loved it! Btw, what repl is this?
That's the DuckDB CLI
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
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
Your videos are awesome.. thx
Thanks, I'm glad you like them!
How to install duckdb for windows
Did you try the instructions on the installation page? duckdb.org/docs/installation/