chdb-go

chDB go bindings and chDB cli.

Install

1. Download and install libchdb

• run make update_libchdb to download and extract libchdb.so. or
• run make install to install libchdb.so

2. Build chdb-go

• run make build

3. Run chdb-go with or without persistent --path

• run ./chdb-go

chdb-go CLI

1. Simple mode

./chdb-go "SELECT 123"
./chdb-go "SELECT 123" JSON

2. Interactive mode

./chdb-go # enter interactive mode, but data will be lost after exit
./chdb-go --path /tmp/chdb # interactive persistent mode

3. Shortcuts

• \l to list databases;
• \dt dbname to list tables in database;

chdb-io/chdb-go [main] » ./chdb-go 
Enter your SQL commands; type 'exit' to quit.
 :) CREATE DATABASE IF NOT EXISTS testdb;

 :) \l
┏━━━━━━━━━━━━━━━━━━━━┓
┃ name               ┃
┡━━━━━━━━━━━━━━━━━━━━┩
│ INFORMATION_SCHEMA │
├────────────────────┤
│ _local             │
├────────────────────┤
│ information_schema │
├────────────────────┤
│ system             │
├────────────────────┤
│ testdb             │
└────────────────────┘

 :) CREATE TABLE IF NOT EXISTS testdb.testtable (id UInt32) ENGINE = MergeTree()
:-] ORDER BY id;

 :) \dt testdb
┏━━━━━━━━━━━┓
┃ name      ┃
┡━━━━━━━━━━━┩
│ testtable │
└───────────┘

Go lib Example

package main

import (
    "fmt"
    "github.com/chdb-io/chdb-go/chdb"
)

func main() {
    // Stateless Query (ephemeral)
    result := chdb.Query("SELECT version()", "CSV")
    fmt.Println(result)

    // Stateful Query (persistent)
    session, _ := NewSession(path)
    defer session.Cleanup()

    session.Query("CREATE DATABASE IF NOT EXISTS testdb; " +
    "CREATE TABLE IF NOT EXISTS testdb.testtable (id UInt32) ENGINE = MergeTree() ORDER BY id;")

    session.Query("USE testdb; INSERT INTO testtable VALUES (1), (2), (3);")

    ret := session.Query("SELECT * FROM testtable;")
    fmt.Println(ret)
}

Golang API docs

• See lowApi.md for the low level APIs.
• See chdb.md for high level APIs.

Thanks

• cli implementation is based on clickhouse-cli