💭 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.

[code]
  con = duckdb.connect('file.db')

Then work off of the connection con rather than duckdb.

[code]
  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/>