Cockroach support #802

Closed
opened 4 years ago by miton18 · 13 comments
miton18 commented 4 years ago (Migrated from github.com)
Owner

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

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

@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 4 years ago (Migrated from github.com)
Owner

Hope support CockroachDB ASAP. Thanks!

Hope support CockroachDB ASAP. Thanks!
koalalorenzo commented 4 years ago (Migrated from github.com)
Owner

+1 Waiting for cockroachdb support :)

+1 Waiting for cockroachdb support :)
Owner

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

I need to change the circleci to version2 and add cockroachdb docker and then add the test to check anything break.
koalalorenzo commented 4 years ago (Migrated from github.com)
Owner

Any ETA? :)

Any ETA? :)
vtolstov commented 3 years ago (Migrated from github.com)
Owner

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

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

~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 2 years ago (Migrated from github.com)
Owner

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

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

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

We have a PR in #896, but I think it needs more work.
vtolstov commented 2 years ago (Migrated from github.com)
Owner

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

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

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.

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.
lunny unlocked this conversation 2 years ago
lunny modified the milestone from 1.1.1 to 1.0.0 2 years ago
Owner

Closed by #896

Closed by #896
lunny closed this issue 2 years ago
Owner

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

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Loading…
There is no content yet.