CockroachDB

CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

CockroachDB supports the PostgreSQL wire protocol, so we use our well-tested native PostgreSQL client driver to work with it.

CockroachDB

data types we support

Integral
bigint (int8)
int (integer, int4)
smallint (int2)
decimal
decimal (dec, numeric, fixed)
double precision (double, float8)
float
real (float4)
text
char (bpchar, character)
text (string)
varchar (character varying)
Binary
bit
Date/Time
date
time (timetz, time without time zone)
timestamp (timestamp without time zone, timestamp(2) without time zone)
timestamptz (timestamp with time zone, timestamp(2) with time zone)
Large objects
bytes (bytea, blob)
text (string)
Other
array
boolean (bool)
enum
inet
interval
jsonb (json)
uuid
varbit (bit varying)