Scale By the Bay 2023 intro video by Alex Monahan

Scale By the Bay 2023 intro video by Alex Monahan

Recording: Scale By the Bay 2023 intro video by Alex Monahan

Hi everyone, my name is Alex Monnier and I'm a forward deployed software engineer at MotherDuck. I also do blogging and documentation for DuckTab Labs. Plus, I'm DuckTab's biggest fan on Twitter. I mean, X. So, what is DuckTab? is an open source analytical database. We call it the SQLite for analytics. It's the fastest and easiest way to add analytical horsepower to any data science or data engineering workflow. Our Python client has a million and a half downloads every month, so come find out what the hype is about with DuckTab

I'll cover three things in my talk. DuckTab is easy to use, it can run anywhere, and it's fast for crunching large data sites. DuckTab is easy to use. Installation is simple. You can download a 20 megabyte file or pip install DuckTab with no dependency. There's no server to manage because it runs inside your application. We have the friendliest SQL syntax in the world. Or, if you prefer data frame syntax, you can use our relational API, PySpart compatible API, you can use Ponder for the pandas API, or iBis data frames

Secondly, DuckTab can run anywhere. You can use the command line tool, or clients in Python, R, Node.js, Java, Rust, Go, Julia, even in the browser with WebAssembly. DuckTab is also under the hood of many of the leading business intelligence tools, so you might already be using it. Third, DuckTab is fast for large data sets. It will automatically parallelize across all your cores. We have a vectorized execution engine to take full advantage of your CPU. And it's an in-process database, so transfer back and forth from your application is instant. But it's in-process, not in-memory

So we can definitely still crunch those larger-than-ram data sets. Looking forward to chatting more about DuckTab. Welcome to the Flap.