🚀 [Feature]: ClickHouse Implementation

[mirusky]

Feature Description

I'd like to use Clickhouse as storage layer and having control over the table engine being used so I could store into different places effortless.

Additional Context (optional)

No response

Code Snippet (optional)

package main

import "github.com/gofiber/storage/clickhouse"

func main() {
  store := clickhouse.New(clickhouse.Config{
	Host:      "127.0.0.1",
	Port:      9000,
	Username:  "",
	Password:  "",
	Engine: clickhouse.Memory
  })
}

Checklist:

• I agree to follow Fiber's Code of Conduct.
• I have checked for existing issues that describe my suggestion prior to opening this one.
• I understand that improperly formatted feature requests may be closed without explanation.

[luk3skyw4lker]

I'll work on that!

[gaby]

@luk3skyw4lker Go driver is here https://github.com/ClickHouse/clickhouse-go seems the native interface is faster than the SQL one. The http one is experimental

[luk3skyw4lker]

@gaby thanks for finding it! I claimed the issue and was going to start looking for a driver now

[luk3skyw4lker]

I'm having some trouble executing the create table statement and I'm not finding any reference in their docs, so I opened an issue in the go client repository and will be waiting for an answer. Here's the issue: ClickHouse/clickhouse-go#1238

[luk3skyw4lker]

Turns out this isn't a thing in Clickhouse itself so I will have to come up with something different for this feature, I'll be working on some ideas and wil put up a PR soon

[gaby]

@luk3skyw4lker What was the issue?

[luk3skyw4lker]

@gaby the issue is that when creating the table inside the adapter (like all the other adapters do) you don't have a native way to safely bind a engine parameter.

[luk3skyw4lker]

I made everything work out, only missing a few docs, will send a PR this week!