In this introductory session, users will learn how to use DuckDB to provide database capabilities to their Python projects without the friction of installing a separate database platform. DuckDB is an open source (under the MIT License) analytical database which runs within the host process. Although the presentation will use Python, DuckDB supports APIs for most major client platforms.

The session will be demo-heavy, using a Python notebook running in VS Code for setup and to walk through getting started with in-memory data store (persists only for the current session), we'll import data from text files and query the resulting data structure with basic Python syntax (using commands from the DuckDB package). Next, we'll import a more extensive dataset into DuckDB's "single file" persistent storage format. Once the data is imported, we can connect to the database from VS Code and develop queries outside of the Python environment. Along the way, we'll learn a bit about DuckDB's SQL syntax (which, according to the documentation, closely follows the PostgreSQL dialect).

To learn more about DuckDB, visit https://duckdb.org/.