Skip to content

DuckDB

Jump to bottom
David Liu edited this page Aug 16, 2025 · 5 revisions

About

DuckDB enable you manipulate dataframe object using SQL

  • In more recent years, with Python becoming the lingua franca of data science, most attention have shifted to techniques on how to manipulate data in tabular format (most notably stored as a DataFrame object). However, the real lingua franca of data is actually SQL. And since most developers are familiar with SQL, isn’t it more convenient to manipulate data using SQL? ... This is where DuckDB comes in

DuckDB eliminates the need to load the dataset into a database server, and allows you to directly load the dataset using SQL

  • The proxy from Pandas dataframe to SQL
image

OLTP <--> SQLite == OLAP <--> DuckDB

image

DB Logs

Clone this wiki locally