CockroachDB Cheat Sheet

cockroach start --insecure --store=node1 --listen-addr=localhost:26257 \  --http-addr=localhost:8080 --join=localhost:26257,localhost:26258,localhost:26259 &cockroach start --insecure --store=node2 --listen-addr=localhost:26258 \  --http-addr=localhost:8081 --join=localhost:26257,localhost:26258,localhost:26259 &cockroach start --insecure --store=node3 --listen-addr=localhost:26259 \  --http-addr=localhost:8082 --join=localhost:26257,localhost:26258,localhost:26259 &cockroach init --insecure --host=localhost:26257cockroach sql --insecure --host=localhost:26257

BEGIN;SAVEPOINT cockroach_restart;UPDATE accounts SET balance = balance - 100 WHERE id = 1;UPDATE accounts SET balance = balance + 100 WHERE id = 2;RELEASE SAVEPOINT cockroach_restart;COMMIT;-- On a 40001 (serialization_failure) error, client should:-- ROLLBACK TO SAVEPOINT cockroach_restart; and retry the statements.-- Most drivers (pgx, node-postgres via cockroach adapters) do this automatically.

ALTER TABLE users ADD COLUMN region STRING NOT NULL DEFAULT 'us-east';ALTER TABLE users PARTITION BY LIST (region) (    PARTITION us (VALUES IN ('us-east', 'us-west')),    PARTITION eu (VALUES IN ('eu-west')));ALTER PARTITION us OF TABLE users  CONFIGURE ZONE USING constraints = '[+region=us-east1]';ALTER PARTITION eu OF TABLE users  CONFIGURE ZONE USING constraints = '[+region=eu-west1]';