go-imap-sql icon indicating copy to clipboard operation
go-imap-sql copied to clipboard

Published 20 hours ago • verified publisher icon foxcpp

CockroachDB support

Open foxcpp opened this issue 5 years ago • 3 comments

CockroachDB is a cloud-native SQL database for building global, scalable cloud services that survive disasters.

CockroachDB supports the PostgreSQL wire protocol, so you can use any available PostgreSQL client drivers to connect from various languages.

go-imap-sql currenlty doesn't work with CockroachDB due to the following known problems:

  • GROUP BY behaves differently https://github.com/cockroachdb/cockroach/issues/26709

There are probably more problems, documented above are the only known ones.

go-imap-sql fully supports PostgreSQL and I would prefer to wait for CockroachDB to become more compatible with it than to introduce various hacks.

CC @NamedKitten

foxcpp avatar May 25 '19 14:05 foxcpp

Referenced issue is closed, need to review whether there are other issues preventing use of CockroachDB with go-imap-sql.

foxcpp avatar Oct 23 '19 20:10 foxcpp

PM at Cockroach Labs here. Let us know if you run into any problems!

awoods187 avatar Mar 19 '20 21:03 awoods187

go-imap-v2 branch now works with CockroachDB 20.1.5 after adding a workaround for https://github.com/cockroachdb/cockroach/issues/41558. The remaining step is to setup CI for continuous testing with it.

foxcpp avatar Oct 03 '20 15:10 foxcpp