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!

[@iwswordpress]

Thanks - very useful and timely.

[@bugbytes3923]

Thanks! Something a bit different...

[@j0hnc0nn0r-sec]

This guy should be paid as much as a professor

[@bugbytes3923]

Thank you!

[@higiniofuentes2551]

Thank you for this very useful video!

[@bugbytes3923]

Thanks a lot, glad you found it useful!

[@themarksmith]

Useful stuff, thank you!

[@bugbytes3923]

Thanks for watching!

[@davidtindell950]

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

[@CaribouDataScience]

Duckdb is BOSS!

[@bugbytes3923]

Agreed, love it!

[@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!

[@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!

[@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!

[@serychristianrenaud]

Thanks 🎉 ...

[@bugbytes3923]

@@serychristianrenaud thanks for watching, as always!

[@frameff9073]

🎉🎉🎉

[@bugbytes3923]

Thanks a lot!

[@zulhishamtan4308]

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

[@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

[@omegasigma4500]

Can we use DuckDB with Polars?

[@bugbytes3923]

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

[@omprakashpattnalu4046]

is it single-threaded?

[@heroe1486]

You picked up an Irish accent

[@bugbytes3923]

🤣🤣