How to use DuckDB: A fast, self-contained analytics database

preview_player
Показать описание
Analytics databases, or column-oriented DBs, speed up analytics jobs on big datasets. But most such DBs are big products with a lot of setup and management overhead. DuckDB bucks that trend: it's a single, self-contained executable and library that brings SQL-query-powered analytics DB functionality to most any programming language, workflow, or data trove. This video shows how you can use DuckDB with Python to work with big, multi-megabyte JSON or CSV datasets, and query the data using conventional SQL syntax.

------------------------------­----
  1. InfoWorld
  2. How to code
  3. Coding tutorial
  4. App dev
  5. App developer
  6. WebAssembly
Рекомендации по теме
DuckDB Tutorial For 0:11:25

DuckDB Tutorial For Beginners

How to use 0:05:47

How to use DuckDB: A fast, self-contained analytics database

Why use DuckDB 0:22:26

Why use DuckDB in your data pipelines ft. Niels Claeys

DuckDB Tutorial - 0:25:53

DuckDB Tutorial - DuckDB course for beginners

Unleashing DuckDB & 0:08:53

Unleashing DuckDB & dbt for local analytics triumphs

How does DuckDB 0:03:26

How does DuckDB deal with dirty data in CSV files?

DuckDB: Hi-performance SQL 0:43:57

DuckDB: Hi-performance SQL queries on pandas dataframe (Python)

An Overview of 0:27:49

An Overview of DuckDB

Exploring DuckDB: A 0:35:26

Exploring DuckDB: A relational database built for online analytical processing

Analyze MILLIONS of 0:29:34

Analyze MILLIONS of points in SECONDS (on your computer) with DuckDB for GIS

Introduction to Scaling 0:29:33

Introduction to Scaling Analytics Using DuckDB with Python

How to Use 0:06:29

How to Use DuckDB, MotherDuck and Airflow Together!

What Is Duck 0:50:46

What Is Duck DB - ft. @startdataengineering

DuckDB and SQL 0:24:31

DuckDB and SQL - for Data Analysis and Processing

DuckDB vs Pandas 0:12:05

DuckDB vs Pandas vs Polars For Python devs

Gábor Szárnyas - 0:55:27

Gábor Szárnyas - DuckDB: The Power of a Data Warehouse in your Python Process

Using DuckDB to 0:04:19

Using DuckDB to analyze the data quality of Apache Parquet files

Querying JSON Documents 0:07:10

Querying JSON Documents with DuckDB

Build a poor 0:41:57

Build a poor man’s data lake from scratch with DuckDB

Querying Parquet files 0:04:02

Querying Parquet files on S3 with DuckDB

DuckDB in Python 0:19:32

DuckDB in Python - The Next Pandas Killer?

Querying SQLite databases 0:05:51

Querying SQLite databases with DuckDB

Ingesting #csv files 0:00:54

Ingesting #csv files from #github into #duckdb

Composable Queries with 0:07:06

Composable Queries with DuckDB

Комментарии
Автор

I needed this about a decade ago when someone asked me to read in & do stuff with a multigb csv file. I tried powershell's CSV tool and it never came back. They wanted an answer by 5, so I never did find a solution.

pythonlibrarian
Автор

Thank you for the quick intro video. I am wondering if DuckDb supports a lot of the advanced Tableau Calculations as part of query. Any production large scale deployments of this?

neeleshkamkolkar