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. Use the unikraft CLI or the legacy kraft CLI. You need a BuildKit builder. The easiest way to get one is via Docker. Alternatively, you can also directly set up and use BuildKit, see the quick start.

   The unikraft CLI is the current standard, while kraft is the legacy version. Choose one of the CLIs below and only run the commands associated with it for the rest of this guide.

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:

In this case, the instance name is duckdb-go121-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:

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.