DuckDB: Up and Running: Fast Data Analytics and Reporting

Cover
Copyright
Table of Contents
Preface
	Conventions Used in This Book
	Using Code Examples
	O’Reilly Online Learning
	How to Contact Us
	Acknowledgements
Chapter 1. Getting Started with DuckDB
	Introduction to DuckDB
		Why Use DuckDB?
		High-Performance Analytical Queries
		Versatile Integration and Ease of Use Across Multiple Programming Languages
		Open Source
	A Quick Look at DuckDB
		Loading Data into DuckDB
		Inserting a Record
		Querying a Table
		Performing Aggregation
		Joining Tables
		Reading Data from pandas
	Why DuckDB Is More Efficient
		Execution Speed
		Memory Usage
	Summary
Chapter 2. Importing Data into DuckDB
	Creating DuckDB Databases
	Loading Data from Different Data Sources and Formats
		Working with CSV Files
		Working with Parquet Files
		Working with Excel Files
		Working with MySQL
	Summary
Chapter 3. A Primer on SQL
	Using the DuckDB CLI
		Importing Data into DuckDB
		Dot Commands
		Persisting the In-Memory Database on Disk
	DuckDB SQL Primer
		Creating a Database
		Creating Tables
		Viewing the Schemas of Tables
		Dropping a Table
	Working with Tables
		Populating Tables with Rows
		Updating Rows
		Deleting Rows
		Querying Tables
		Joining Tables
		Aggregating Data
		Analytics
	Summary
Chapter 4. Using DuckDB with Polars
	Introduction to Polars
		Creating a Polars DataFrame
		Understanding Lazy Evaluation in Polars
	Querying Polars DataFrames Using DuckDB
		Using the sql() Function
		Using the DuckDBPyRelation Object
	Summary
Chapter 5. Performing EDA with DuckDB
	Our Dataset: The 2015 Flight Delays Dataset
	Geospatial Analysis
		Displaying a Map
		Displaying All Airports on the Map
		Using the spatial Extension in DuckDB
	Performing Descriptive Analytics
		Finding the Airports for Each State and City
		Aggregating the Total Number of Airports in Each State
		Obtaining the Flight Counts for Each Pair of Origin and Destination Airports
		Getting the Canceled Flights from Airlines
		Getting the Flight Count for Each Day of the Week
		Finding the Most Common Timeslot for Flight Delays
		Finding the Airlines with the Most and Fewest Delays
	Summary
Chapter 6. Using DuckDB with JSON Files
	Primer on JSON
		Object
		String
		Boolean
		Number
		Nested Object
		Array
		null
	Loading JSON Files into DuckDB
		Using the read_json_auto() Function
		Using the read_json() Function
		Using the COPY-FROM Statement
	Exporting Tables to JSON
	Summary
Chapter 7. Using DuckDB with JupySQL
	What Is JupySQL?
		Installing JupySQL
		Loading the sql Extension
		Integrating with DuckDB
		Performing Queries
		Storing Snippets
	Visualization
		Histograms
		Box Plots
		Pie Charts
		Bar Plots
	Integrating with MySQL
		Using Environment Variables
		Using an .ini File
		Using keyring
	Summary
Chapter 8. Accessing Remote Data Using DuckDB
	DuckDB’s httpfs Extension
	Querying CSV and Parquet Files Remotely
		Accessing CSV Files
		Accessing Parquet Files
	Querying Hugging Face Datasets
		Using Hugging Face Datasets
		Reading the Dataset Using hf:// Paths
		Accessing Files Within a Folder
		Querying Multiple Files Using the Glob Syntax
		Working with Private Hugging Face Datasets
	Summary
Chapter 9. Using DuckDB in the Cloud with MotherDuck
	Introduction to MotherDuck
		Signing Up for MotherDuck
		MotherDuck Plans
	Getting Started with MotherDuck
		Adding Tables
		Creating Schemas
		Sharing Databases
		Creating a Database
		Detaching a Database
	Using the Databases in MotherDuck
		Querying Your Database
		Writing SQL Using AI
	Using MotherDuck Through the DuckDB CLI
		Connecting to MotherDuck
		Querying Databases on MotherDuck
		Creating Databases on MotherDuck
		Performing Hybrid Queries
	Summary
Index
About the Author
Colophon