chdb-io / chdb-go Goto Github PK

Is it possible to have an option to compile a statically linked Go binary so there's no dependency on having libchdb.so present on the machine it's running on?
My understanding is you need to build a static library libchdb.a file instead of a dynamic library libchdb.so, I tried modifying the chdb build script to see if it was possible and ran into a linker issue which I couldn't get past.

With the following program, I'm not able to query system.parts.

package main

import (
	"fmt"

	"github.com/chdb-io/chdb-go/chdb"
)

func main() {
	result, err := chdb.Query("SELECT version()", "CSV")
	if err != nil {
		fmt.Println(err)
		return
	}
	fmt.Println(result)

	session, _ := chdb.NewSession("./data")
	defer session.Close()

	q := `select * from system.parts`
	ret, err := session.Query(q)
	if err != nil {
		fmt.Println(err)
		return
	}

	fmt.Println(ret)
}

This outputs the following:

$ CGO_LDFLAGS="-L." go run .
"23.10.1.1"

Code: 60. DB::Exception: Table system.parts does not exist. (UNKNOWN_TABLE)

I am linking downloaded chdb v1.3.0. It is curious that the version is so old. It seems like system.parts was added in December 2023 based on these issues:

• ClickHouse/ClickHouse#58312
• ClickHouse/ClickHouse#58359

Is there a way to connect to chdb using clickhouse-go?

Hi,
When creating a database or table, it does not return an error if it already exists, but it prints a debug on the terminal.
the example code:

db, err := chdb.NewSession("a") //path is option
	if err != nil {
		fmt.Println("hata", err)
		return
	}
	fmt.Print("\nburası\n")

	a := db.Query("CREATE DATABASE db")
	fmt.Println("a değeri",a)

	db.Query("USE db")

the terminal:

burası
Code: 82. DB::Exception: Database db already exists. (DATABASE_ALREADY_EXISTS)
a değeri 

Does anyone have any solution suggestions?
Thank you, happy new year