Cockroach support #802

New Issue

lunny · 2017-12-12T10:21:11Z

miton18 commented

2017-12-12 10:21:11 +00:00

(Migrated from github.com)

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.

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 commented

2017-12-12 11:17:10 +00:00

@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.

smcduck commented

2018-04-11 13:42:21 +00:00

(Migrated from github.com)

Hope support CockroachDB ASAP. Thanks!

koalalorenzo commented

2018-04-14 07:46:12 +00:00

(Migrated from github.com)

+1 Waiting for cockroachdb support :)

lunny commented

2018-04-14 11:59:47 +00:00

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

koalalorenzo commented

2018-04-15 07:41:32 +00:00

(Migrated from github.com)

Any ETA? :)

vtolstov commented

2018-10-19 20:43:39 +00:00

(Migrated from github.com)

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

techknowlogick commented

2018-10-19 20:45:10 +00:00

~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

~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 commented

2019-09-13 22:21:42 +00:00

(Migrated from github.com)

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

lunny commented

2019-09-14 02:20:56 +00:00

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

vtolstov commented

2019-09-14 09:48:54 +00:00

(Migrated from github.com)

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

lunny commented

2019-09-14 12:12:49 +00:00

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.

vtolstov referenced this issue

2019-11-13 09:34:38 +00:00

why issue about cockroach support disallows comments? #1479

lunny unlocked this conversation 2019-11-13 10:59:52 +00:00

lunny referenced this issue

2019-11-13 11:01:31 +00:00

Add cockroach support and tests #896

lunny modified the milestone from 1.1.1 to 1.0.0

2020-03-03 08:19:00 +00:00

lunny commented

2020-03-03 08:20:05 +00:00

Closed by #896

lunny closed this issue

2020-03-03 08:20:05 +00:00

lunny commented

2020-03-03 08:25:19 +00:00

Although now xorm supported cockroach but there are some convs.

Autoincrement will not start from 1 if you not enable experimental_serial_normalization=sql_sequence in connection string.
Update Limit will not work since cockroach didn't support CTID

Although now xorm supported cockroach but there are some convs. 1. `Autoincrement` will not start from 1 if you not enable `experimental_serial_normalization=sql_sequence` in connection string. 2. `Update Limit` will not work since cockroach didn't support `CTID`

Sign in to join this conversation.

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#802