DuckDB: Up and Running: Fast Data Analytics and Reporting

by Wei-Meng Lee

Data Science

Book Details

Book Title

DuckDB: Up and Running: Fast Data Analytics and Reporting

Author

Wei-Meng Lee

Publisher

O’Reilly Media

Publication Date

2025

ISBN

9781098159696

Number of Pages

308

Language

English

Format

PDF

File Size

5.10MB

Subject

Data analysis and reporting with DuckDB

Table of Contents

  • Preface
  • Chapter 1. Getting Started with DuckDB
  • Introduction to DuckDB
  • A Quick Look at DuckDB
  • Why DuckDB Is More Efficient
  • Summary
  • Chapter 2. Importing Data into DuckDB
  • Creating DuckDB Databases
  • Loading Data from Different Data Sources and Formats
  • Summary
  • Chapter 3. A Primer on SQL
  • Using the DuckDB CLI
  • DuckDB SQL Primer
  • Working with Tables
  • Summary
  • Chapter 4. Using DuckDB with Polars
  • Introduction to Polars
  • Querying Polars DataFrames Using DuckDB
  • Summary
  • Chapter 5. Performing EDA with DuckDB
  • Our Dataset: The 2015 Flight Delays Dataset
  • Geospatial Analysis
  • Performing Descriptive Analytics
  • Summary
  • Chapter 6. Using DuckDB with JSON Files
  • Primer on JSON
  • Loading JSON Files into DuckDB
  • Exporting Tables to JSON
  • Summary
  • Chapter 7. Using DuckDB with JupySQL
  • What Is JupySQL?
  • Visualization
  • Integrating with MySQL
  • Summary
  • Chapter 8. Accessing Remote Data Using DuckDB
  • DuckDB’s httpfs Extension
  • Querying CSV and Parquet Files Remotely
  • Querying Hugging Face Datasets
  • Summary
  • Chapter 9. Using DuckDB in the Cloud with MotherDuck
  • Introduction to MotherDuck
  • Getting Started with MotherDuck
  • Using the Databases in MotherDuck
  • Using MotherDuck Through the DuckDB CLI
  • Summary
  • Index
  • About the Author
  • Colophon