Skip to content

Instantly share code, notes, and snippets.

View kavirajk's full-sized avatar
😎
Talk database to me!!

Kaviraj Kanagaraj kavirajk

😎
Talk database to me!!
134 followers · 75 following
View GitHub Profile
@kavirajk
kavirajk / variant_fail.go
Last active January 14, 2026 16:12
Variant type broken on `head` CH
package main
import (
"context"
"fmt"
"github.com/ClickHouse/clickhouse-go/v2"
)
func main() {
@kavirajk
kavirajk / json_error.go
Created January 8, 2026 11:12
json_error.go
func main() {
conn, err := clickhouse.Open(&clickhouse.Options{
Addr: []string{
"127.0.0.1:9000",
},
})
create := `
CREATE OR REPLACE TABLE test_json (
id Int,
data String
@kavirajk
kavirajk / client_lb_test.go
Created January 7, 2026 17:26
ClickHouse go client side load balancing
package code
import (
"testing"
"time"
"github.com/ClickHouse/clickhouse-go/v2"
)
func TestClientLB(t *testing.T) {
@kavirajk
kavirajk / select_perf.go
Last active November 26, 2025 13:57
select_perf
package main
import (
"context"
"crypto/tls"
"database/sql"
"fmt"
"github.com/ClickHouse/clickhouse-go/v2"
)
@kavirajk
kavirajk / query_params.go
Created November 11, 2025 07:41
Query Params clickhouse-go
package main
import (
"context"
"fmt"
"os"
"github.com/ClickHouse/clickhouse-go/v2"
)
@kavirajk
kavirajk / query_params_chgo.go
Created November 11, 2025 07:37
Query params ch-go array
package main
import (
"context"
"fmt"
"github.com/ClickHouse/ch-go"
"github.com/ClickHouse/ch-go/proto"
)
@kavirajk
kavirajk / unknown_settings.go
Created November 7, 2025 11:56
unknown_settings ClickHouse
package main
import (
"context"
"github.com/ClickHouse/clickhouse-go/v2"
)
func main() {
conn, err := clickhouse.Open(&clickhouse.Options{
@kavirajk
kavirajk / demo_zero_chunk.go
Created November 2, 2025 22:16
Demo Zero Chunk bug with ClickHouse server
package main
import (
"bytes"
"fmt"
"io"
"net/http"
"os"
"strings"
"time"
@kavirajk
kavirajk / default_http_compression_test.go
Created October 14, 2025 10:27
default_http_compression_test.go
package code
import (
"context"
"testing"
"time"
"github.com/ClickHouse/clickhouse-go/v2"
"github.com/stretchr/testify/require"
)
@kavirajk
kavirajk / withstdAsync_driverConn.go
Created October 3, 2025 09:53
withstdAsync_driverConn.go
func TestWithStdAsync(t *testing.T) {
conn, err := clickhouse.Open(&clickhouse.Options{
Addr: []string{"localhost:9000"},
Protocol: clickhouse.Native,
})
require.NoError(t, err)
ctx := context.Background()
queryID := fmt.Sprintf("%d", time.Now().Unix())
// queryID := "async-with-opendb"