---
title: "💠Python API - DuckDB"
description: "!https://duckdb.org/docs/api/python/overview.html"
date: 2023-07-28
published: true
tags:
- python
- data
- duckdb
- thought
template: link
---
To persist data in duckdb you need to first make a connection to a duck db database.
``` python
con = duckdb.connect('file.db')
```
Then work off of the connection `con` rather than `duckdb`.
``` python
con.sql('CREATE TABLE test(i INTEGER)')
con.sql('INSERT INTO test VALUES (42)')
# query the table
con.table('test').show()
# explicitly close the connection
con.close()
```
!!! note
This post is a thought. It's a short note that I make
about someone else's content online #thoughts