DuckDB and SQL - for Data Analysis and Processing

[@bugbytes3923]

☕ Buy a coffee: ko-fi.com/bugbytes ⭐Top resource to learn Python - datacamp.pxf.io/kOjKkV ⭐

[@thepigol]

Great video - concise and informative. Thank you, mate!

[@bugbytes3923]

Thanks a lot mate, glad you liked it!

[@davidtindell950]

thank you. "And Now for something completely (or, 'a bit') different !

[@iwswordpress]

Thanks - very useful and timely.

[@bugbytes3923]

Thanks! Something a bit different...

[@tmb8807]

For my money the expression syntax and method chaining of Polars is less cognitively demanding for analytical queries like this, but I do like the fact they’re interoperable with little overhead so you could potentially leverage the strengths of both in the same workflow if it made sense to do that. Cheers!

[@higiniofuentes2551]

Thank you for this very useful video!

[@bugbytes3923]

Thanks a lot, glad you found it useful!

[@j0hnc0nn0r-sec]

This guy should be paid as much as a professor

[@bugbytes3923]

Thank you!

[@CaribouDataScience]

Duckdb is BOSS!

[@bugbytes3923]

Agreed, love it!

[@themarksmith]

Useful stuff, thank you!

[@bugbytes3923]

Thanks for watching!

[@zb9458]

Great stuff Lyle! I've been hearing a lot of good things about DuckDB, would love a follow up episode on this for more advanced use cases to demonstrate the performance benefits of DuckDB over Postgres for example. I'd love to see an example with 100x the data and the performance differences there

[@bugbytes3923]

Thank you! That would be an interesting follow-up, so I'll plan that out. Cheers!

[@michwilhelmi8305]

Really good highlights. Thanks. I will be moving on to your HTMX session again soon .. I would like to try to work on a HTMX + Python + DuckDB combo soon with CRUD included.

[@bugbytes3923]

Thank you! Interesting mix of tools - I might try something like this at some point!

[@zulhishamtan4308]

Please consider to make a video for using geospatial function in duckdb. Thank you very much.

[@serychristianrenaud]

Thanks 🎉 ...

[@bugbytes3923]

@@serychristianrenaud thanks for watching, as always!

[@omegasigma4500]

Can we use DuckDB with Polars?

[@bugbytes3923]

Yeah - data can be converted to a Polars dataframe with the method used in the video!

[@MO3az-hw9qy]

What if the Data is too big to fit into the memory I work on a project where I deal with punch of a CSV's Files where each is 2.5 GB, What Should I Do

[@frameff9073]

🎉🎉🎉

[@bugbytes3923]

Thanks a lot!

[@omprakashpattnalu4046]

is it single-threaded?

[@heroe1486]

You picked up an Irish accent

[@bugbytes3923]

🤣🤣