💭 Python API - DuckDB
━━━━━━━━━━━━━━━━━━━━━

!https://duckdb.org/docs/api/python/overview.html

Date: July 28, 2023

Image: https://duckdb.org/docs/api/python/overview.html </static/https://duckdb.org/docs/api/python/overview.html>

To persist data in duckdb you need to first make a connection to a duck db database.

```
con = duckdb.connect('file.db')
```

Then work off of the connection con rather than duckdb.

```
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 </thoughts/>. It’s a short note that I make about someone else’s content online #thoughts </tags/thoughts/>