Questions tagged [cockroachdb]

Questions related to CockroachDB and how to install and set it up (secure and insecure) and run it across a cluster on any/all of the cloud vendors - and also on local/private clouds. Any particular database issues with CockroachDB (e.g. performance, PostgreSQL compatibility). Other database matters touching on CockroachDB as a db system would also be on-topic.

Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

Error: pq: 1 columns must reference exactly 1 columns in referenced table (found 2) [closed]

I have a few tables and I am facing this issue most likely with the table "item". When I remove restaurant_id and category_id, it works fine. CREATE TABLE IF NOT EXISTS restaurant ( id ...
0
votes
1answer
166 views

Replicate Postgres to Cockroach

We are planning to replicate our Postgres database to Cockroach. We are looking for a relatively simpler solution to achieve that. Currently, we are working on a Stream based replication (something ...
-2
votes
1answer
58 views

Is it efficient to design chat/likes/relationship database in separate table per user? [closed]

The specs: there would be about 1 billion users there would be probably 1 million topics each topics has subtopics stored at the same level as topics user has many to many relationship with topics (...