2 Getting started with DuckDB

This chapter covers

  • Installing and learning how to use the DuckDB command-line interface
  • Executing commands in the DuckDB CLI
  • Querying remote files

Now that we have an understanding of what DuckDB is and why it came into prominence in the early 2020s, it’s time to get familiar with it. This chapter will be centered on the DuckDB command-line interface (CLI). We’ll learn how to install it on various environments, before learning about the its built-in commands. We’ll conclude by querying a remote CSV file.

2.1 Supported environments

DuckDB is available for a range of different programming languages and operating systems (Linux, Windows, and macOS) both for Intel/AMD and ARM architectures. At the time ...

Get DuckDB in Action now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.