Cockroach support

[miton18]

Hi !

In our apps, we have scalability problems, we actually used PostgreSQL Databases. Cockroach DB seems a technology that can solve our problems :

• distributed SQL
• support data locality (multi-datacenters)
• read / write on each nodes
• Easy to deploy / maintain

It is PostgreSQL based Is it possible to support this database ? https://www.cockroachlabs.com/ We also look at Tidb which is already supported, but it seems very hard to deploy and maintain.

[lunny]

@miton18 I think it should be supported but I haven't test Cockroach DB. I will test it or maybe try to add it to CI.

[nifflin]

Hope support CockroachDB ASAP. Thanks!

[koalalorenzo]

+1 Waiting for cockroachdb support :)

[lunny]

I need to change the circleci to version2 and add cockroachdb docker and then add the test to check anything break.

[koalalorenzo]

Any ETA? :)

[vtolstov]

hi! does cockroach with xorm is ready to use or not?

[techknowlogick]

~The related issue on cockroach's tracker was marked as completed, just haven't tested things yet.~ Just tested, some changes will still need to be made to xorm

[vtolstov]

can @techknowlogick and @lunny share some info about feature steps to get cockroach support in xorm?

[lunny]

We have a PR in #896, but I think it needs more work.

[vtolstov]

Can you say what is missing, may be i can helps

[lunny]

You can see https://circleci.com/gh/go-xorm/xorm/975?utm_campaign=vcs-integration-link&utm_medium=referral&utm_source=github-build-link I'm trying to make cockroach pass all tests that postgres/mysq/mssql/sqlite Passed.