How to create multiple instances of chDB ?

[aadant]

If chDB is not thread safe, how do you create multiple instances in a single golang process ?

[agoncear-mwb]

chdb is thread safe, in fact you can share the db connection between multiple goroutine.

the limitation is that you can have a single connection for the entire process, not multiple one

[minguyen9988]

When we try to use chdb with engine Memory, we encounter memory build up if we dont constantly close and remake the session even though we drop the table periodically.

So we were wondering if we can have multiple instances of chdb per thread so we can do this independently.