• 

  @waylonwalker

  2023

  Python API - DuckDB

  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()
  
  
  

You found my thought's a collection of short posts generally tied to a link on the web and written through a small chrome extension. See full posts on waylonwalker.com