search

mkabilov / pg2ch

Data streaming from postgresql to clickhouse via logical replication mechanism
MIT License
195 stars 35 forks source link

Upgrade to modules, pgx/v4 & accoutrements - WIP #36

Open mattTruebill opened 3 years ago

mattTruebill commented 3 years ago

Upgrade to using go modules.

Upgrade to pgx/4.

EugeneKovalev commented 3 years ago

@mkabilov @mattTruebill any news on this?

I am not able to install pg2ch. Right now I am getting this:

go get -u github.com/mkabilov/pg2ch

# github.com/mkabilov/pg2ch/pkg/utils/kvstorage
go/pkg/mod/github.com/mkabilov/pg2ch@v1.0.0/pkg/utils/kvstorage/diskv.go:52:41: s.storage.ReadString undefined (type *diskv.Diskv has no field or method ReadString)
go/pkg/mod/github.com/mkabilov/pg2ch@v1.0.0/pkg/utils/kvstorage/diskv.go:60:18: s.storage.WriteString undefined (type *diskv.Diskv has no field or method WriteString)
buildscientist commented 3 years ago

Hello @mkabilov and @mattTruebill - thanks for your hard work on this project.

Do either of you have an ETA when this PR will be pulled in? I have an outstanding issue where pg2ch will not handle DateTime64 CH fields due to the underlying ch-go library not supporting them. This has been fixed in the current version of clickhouse-go which is being pulled in via gomod dependency management.

buildscientist commented 3 years ago

@EugeneKovalev

You can clone the repository and build locally. Until this PR Is merged go get will not work.