Getting Started with DuckDB

1. Getting Started with DuckDB#

1.1. Introduction#

1.2. Learning Objectives#

1.3. What Makes DuckDB Different from Traditional Databases#

1.4. When (and When Not) to Use DuckDB for Spatial Work#

1.4.1. When to Use DuckDB#

1.4.2. When Not to Use DuckDB#

1.5. Installing DuckDB CLI and Running Your First Query#

1.5.1. Windows Installation#

1.5.2. macOS or Linux Installation#

1.6. Installing the DuckDB Python Client#

1.6.1. Installing DuckDB Using pip#

1.6.1.1. Installing uv#

1.6.1.2. Basic uv Usage#

1.6.2. Installing DuckDB Using Conda#

1.6.2.1. Installing Miniconda on Windows#

1.6.2.2. Installing Miniconda on macOS#

1.6.2.3. Installing Miniconda on Linux#

1.6.2.4. Installing DuckDB in the Conda environment#

1.6.3. Verifying Installation#

1.7. Installing Visual Studio Code#

1.7.1. Download and Installation#

1.7.2. Installing VS Code Extensions#

1.7.3. Installing DuckDB Extensions#

1.8. Using the DuckDB UI#

1.9. Installing DBeaver SQL IDE#

1.10. Key Takeaways#

1.11. Exercises#

1.11.1. Exercise 1: Installation Verification#

1.11.2. Exercise 2: Installing and Loading Extensions#

1.11.3. Exercise 3: Python Environment Setup#

1.11.4. Exercise 4: DBeaver SQL Editor Setup#

1.11.5. Exercise 5: Exploring the DuckDB UI#

Contents