quack

Connecting Go and DuckDB Quack Server with ADBC

Instructions

Tip

If you already have a DuckDB Quack server instance running, skip the steps to set up DuckDB.

Prerequisites

1. Install Go

2. Install dbc

3. Install DuckDB

Set up DuckDB server

1. Start the DuckDB CLI:

   duckdb

2. Create a table:

   CREATE TABLE penguins AS FROM read_csv('https://blobs.duckdb.org/data/penguins.csv', nullstr = 'NA');

3. Start a server from the DuckDB session:

   CALL quack_serve('quack:localhost');

   Note the auth_token value that DuckDB prints.

Connect to DuckDB via Quack protocol

1. Install the Quack ADBC driver:

   dbc install --pre quack

2. Customize the Go program main.go as needed

   • Change the uri connection argument
     • Replace YOUR_AUTH_TOKEN with the auth_token printed by DuckDB
     • Change the host and port if applicable
   • If you changed which database you're connecting to, also change the SQL SELECT statement in stmt.SetSqlQuery()

3. Run the Go program:

   go mod tidy
   go run main.go

Clean up

If you started a DuckDB server, exit the DuckDB CLI:

.exit