Exploring DuckDB: A relational database built for online analytical processing

Thoughtworks Technology Podcast

Thoughtworks

Careers, Business, 907234, Technology

4.7 • 53 Ratings

🗓️ 19 September 2024

⏱️ 35 minutes

🔗️ Recording | iTunes | RSS

🧾️ Download transcript

Summary

There are no shortage of options when it comes to relational databases. While the likes of PostgreSQL have proven enduring, even as the market has evolved, for data scientists and data engineers that need to manage and query particularly complex or large data sets, the most popular databases aren't always right for the job. Thankfully, this is where projects like DuckDB can help. Built for what's called 'vectorized query execution', it's well-suited to the demands of online analytical processing (OLAP).

To get a deeper understanding of DuckDB and how the product has developed, on this episode of the Technology Podcast, hosts Ken Mugrage and Lilly Ryan are joined by Thoughtworker Ned Letcher and Thoughtworks alumnus Simon Aubury. Ned and Simon explain the thinking behind DuckDB, the design decisions made by the project and how its being used by data practitioners in the wild.

Learn more about DuckDB: https://duckdb.org/why_duckdb.html

Explore Ned and Simon's book Getting Started with DuckDB: https://www.amazon.com/Getting-Started-DuckDB-practical-efficiently/dp/1803241004

Transcript

Click on a timestamp to play from that location

0:00.0	Hello, and welcome to the ThoughtWorks podcast.
0:10.0	My name is Ken McGreg.
0:11.2	I'm one of your regular hosts.
0:12.9	With me today as a co-host is Lily Ryan.
0:15.0	Lily, you want to choose yourself?
0:16.0	Hi, I'm Lily Ryan, and I'm another one of the hosts of the Thoughtwix Technology podcast.
0:21.8	We have a couple of guests with us today to talk about kind of a cool new product.
0:25.7	Simon Aubrey and Ned Letcher.
0:27.7	Simon, you want to say hi?
0:29.4	Gide.
0:29.9	I'm Simon Aubrey.
0:31.1	I'm a director of data platforms, and I'm based out of Sydney, Australia.
0:35.0	It's great to meet you this morning.
0:36.8	Welcome.
0:37.6	Ned, how about yourself?
0:38.9	Hey, yeah, I'm Ned.
0:40.4	I'm a data scientist in ThoughtWorks, Australia, Melbourne.
0:45.6	Welcome.
0:47.1	Astute listeners may notice that only one of us this time has a North American accent,
0:51.8	and so thank the three of you for joining from Australia.
0:55.2	So today we're going to be talking about a product called DuckDB,
0:58.5	which is kind of a cool new database or newer database that Simon and Ned wrote a book about
	...

Transcript will be available on the free plan in -191 days. Upgrade to see the full transcript now.

Previous episode | Next episode

Disclaimer: The podcast and artwork embedded on this page are from Thoughtworks, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Thoughtworks and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.