nikepan / clickhouse-bulk

Collects many small inserts to ClickHouse and send in big inserts
Apache License 2.0
474 stars 86 forks source link

http interface #34

Closed alifpay closed 4 years ago

alifpay commented 4 years ago

Hi

Why do you HTTP interface for Clickhouse? Is it better than clickhouse-go ?

nikepan commented 4 years ago

No, but it makes very simple to join small http queries from python/php projects

nikepan commented 4 years ago

And clickhouse-go is a library, and clikchouse-bulk is a service

alifpay commented 4 years ago

No, I mean in your project, you are using HTTP interface (Golang HTTP client) to connect with Clickhouse. Why you do not use Clickhouse driver like clickhouse-go?

dink10 commented 4 years ago

@alifpay I guess you can fork and provide alternative solution covered tests with clickhouse-go instead of HTTP Golang client. If you would like I can help you in that idea :)

alifpay commented 4 years ago

Just interesting, I found another project kittenhouse that uses HTTP interface

nikepan commented 4 years ago

I have no time for grow this app. And I think, it is not very actual, because this service for small projects. Big projects can write own collectors for their highload. But you can write alternate sender class. And we connect it with config option.

alifpay commented 4 years ago

clickhouse-go does not support batch insert, like bellow

conn.Exec(`INSERT INTO table3 (c1, c2, c3) VALUES ('v1', 'v2', 'v3')('v4', 'v5', 'v6')`)

thank you very much.