Zudoku
Guides

DuckDB with a Go

This guide shows you how to use DuckDB, an in-process SQL OLAP database management system, in your Go project.

To run it example, follow these steps:

  1. Install the kraft CLI tool and a container runtime engine, for example Docker.

  2. Clone the examples repository and cd into the examples/duckdb-go/ directory:

Code(bash)
git clone https://github.com/kraftcloud/examples cd examples/duckdb-go/

Make sure to log into Unikraft Cloud by setting your token and a metro close to you. This guide uses fra (Frankfurt, ๐Ÿ‡ฉ๐Ÿ‡ช):

Code(bash)
# Set Unikraft Cloud access token export UKC_TOKEN=token # Set metro to Frankfurt, DE export UKC_METRO=fra

When done, invoke the following command to deploy this app on Unikraft Cloud:

Code(bash)
kraft cloud deploy -p 443:8080 .

The output shows the instance address and other details:

Code(ansi)
[โ—] Deployed successfully! โ”‚ โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ name: duckdb-go-qfd8x โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ uuid: 90960d27-458b-4dd7-a037-2a9a3a47f095 โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ state: running โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ url: https://autumn-gorilla-hg4h6sup.fra.unikraft.app โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ image: duckdb-go@sha256:6999293f8694ac00beb6a1d639fab8f96f78c2e6ecb8ccb2311539908895a699 โ”œโ”€โ”€โ”€โ”€โ”€ boot time: 32.12 ms โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ memory: 128 MiB โ”œโ”€โ”€โ”€โ”€โ”€โ”€โ”€ service: autumn-gorilla-hg4h6sup โ”œโ”€โ”€ private fqdn: duckdb-go-qfd8x.internal โ”œโ”€โ”€โ”€โ”€ private ip: 172.16.6.2 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€ args: /server

In this case, the instance name is duckdb-go-qfd8x and the address is https://autumn-gorilla-hg4h6sup.fra.unikraft.app. They're different for each run.

Use curl to query the Unikraft Cloud instance of DuckDB.

Code(bash)
curl https://autumn-gorilla-hg4h6sup.fra.unikraft.app
Code(ansi)
id: %d, name: %s 42 John

You can list information about the instance by running:

Code(bash)
kraft cloud instance list
Code(text)
NAME FQDN STATE CREATED AT IMAGE MEMORY ARGS BOOT TIME duckdb-go-qfd8x autumn-gorilla-hg4h6sup.fra.unikraft.app running 1 minute ago duckdb-go... 128 MiB /server 32118us

When done, you can remove the instance:

Code(bash)
kraft cloud instance remove duckdb-go-qfd8x

Customize your app

To customize the app, update the files in the repository, listed below:

  • src/main.go: the Go web server frontend
  • Kraftfile: the Unikraft Cloud specification, including command-line arguments
  • Dockerfile: the Docker-specified app filesystem

The following options are available for customizing the app:

  • If you only update the implementation in the main.go source file, you don't need to make any other changes.

  • If you create any new source files, copy them into the app filesystem by using the COPY command in the Dockerfile.

  • If you add new source code files, build them using the corresponding go build command.

  • If you build a new executable, update the cmd line in the Kraftfile and replace /server with the path to the new executable.

  • More extensive changes may require extending the Dockerfile (see Dockerfile syntax reference).

Learn more

Use the --help option for detailed information on using Unikraft Cloud:

Code(bash)
kraft cloud --help

Or visit the CLI Reference.

Last modified on