Posts tagged: duckdb

duckdb is a new in process database that has been making its rounds in analytics for its high performance in those applications.

Mother duck is a centeralized server that brings manages storage, data sharing and an ide to duckdb.

Harlequin is a pretty sweet example of what textual can be used to create. Its a terminal based sql ide for DuckDB.

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.

duckdb can just query any pandas dataframe that is in memory.

I tried running it against a list of objects and got this error. Great error message that gives me supported types right in the message.