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.

Full Convert supports CockroachDB database directly.

CockroachDB data types we support

Integral

bigint (int8), int (integer, int4), smallint (int2)

Decimal

decimal (dec, numeric, fixed), double precision (double, float8), float, money, 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)

Export CockroachDB database

It may make sense to migrate your data away from CockroachDB. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current CockroachDB database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.