Copy page

Guides

DuckDB with Go

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

To run this example, follow these steps:

1. Install the CLI and a container runtime engine, for example Docker. Use the unikraft CLI or the legacy kraft CLI.

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

Code
git clone https://github.com/unikraft-cloud/examples
cd examples/duckdb-go1.21/

Make sure to log into Unikraft Cloud and pick a metro close to you. This guide uses fra (Frankfurt, 🇩🇪):

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

The output shows the instance address and other details:

Code
[●] Deployed successfully!
 │
 ├────────── name: duckdb-go1.21-qfd8x
 ├────────── uuid: 90960d27-458b-4dd7-a037-2a9a3a47f095
 ├───────── state: running
 ├─────────── url: https://autumn-gorilla-hg4h6sup.fra.unikraft.app
 ├───────── image: duckdb-go1.21@sha256:6999293f8694ac00beb6a1d639fab8f96f78c2e6ecb8ccb2311539908895a699
 ├───── boot time: 32.12 ms
 ├──────── memory: 256 MiB
 ├─────── service: autumn-gorilla-hg4h6sup
 ├── private fqdn: duckdb-go1.21-qfd8x.internal
 ├──── private ip: 172.16.6.2
 └────────── args: /server

In this case, the instance name is duckdb-go1.21-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
curl https://autumn-gorilla-hg4h6sup.fra.unikraft.app

Code
id: %d, name: %s 42 John

You can list information about the instance by running:

Code
NAME                 FQDN                                      STATE    STATUS        IMAGE                                MEMORY   VCPUS  ARGS     BOOT TIME
duckdb-go1.21-qfd8x  autumn-gorilla-hg4h6sup.fra.unikraft.app  running  1 minute ago  duckdb-go1.21@sha256:6999293f869...  256 MiB  1      /server  32118us

When done, you can remove the instance:

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:

Or visit the CLI Reference or the legacy CLI Reference.