Hire Expert CockroachDB
Developers from India

-- CockroachDB geo-distributed table CREATE TABLE users ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), email TEXT UNIQUE NOT NULL, region TEXT NOT NULL CHECK (region IN ('us-east', 'eu-west', 'ap-south')), created_at TIMESTAMPTZ DEFAULT now() ) PARTITION BY LIST (region); CREATE TABLE users_us PARTITION OF users FOR VALUES IN ('us-east'); CREATE TABLE users_eu PARTITION OF users FOR VALUES IN ('eu-west'); CREATE TABLE users_ap PARTITION OF users FOR VALUES IN ('ap-south'); -- Pin each partition to its home region ALTER PARTITION users_us OF TABLE users CONFIGURE ZONE USING constraints = '[+region=us-east-1]';