Cockroach DBを使ってみる

www.cockroachlabs.com

Windows版入手先画面

バイナリ

サーバ起動

PS C:\Program Files\cockroach\cockroach-v19.1.1.windows-6.2-amd64> .\cockroach start --insecure --listen-addr=localhost
*
* WARNING: RUNNING IN INSECURE MODE!
*
* - Your cluster is open for any client that can access localhost.
* - Any user, even root, can log in without providing a password.
* - Any user, connecting as root, can read or write any data in your cluster.
* - There is no network encryption nor authentication, and thus no confidentiality.
*
* Check out how to secure your cluster: https://www.cockroachlabs.com/docs/v19.1/secure-a-cluster.html
*
CockroachDB node starting at 2019-06-15 07:06:10.8743553 +0000 UTC (took 1.3s)
build:               CCL v19.1.1 @ 2019/05/15 20:36:28 (go1.11.6)
webui:               http://localhost:8080
sql:                 postgresql://root@localhost:26257?sslmode=disable
client flags:        C:\Program Files\cockroach\cockroach-v19.1.1.windows-6.2-amd64\cockroach.exe <client cmd> --host=localhost:26257 --insecure
logs:                C:\Program Files\cockroach\cockroach-v19.1.1.windows-6.2-amd64\cockroach-data\logs
temp dir:            C:\Program Files\cockroach\cockroach-v19.1.1.windows-6.2-amd64\cockroach-data\cockroach-temp032909295
external I/O path:   C:\Program Files\cockroach\cockroach-v19.1.1.windows-6.2-amd64\cockroach-data\extern
store[0]:            path=C:\Program Files\cockroach\cockroach-v19.1.1.windows-6.2-amd64\cockroach-data
status:              initialized new cluster
clusterID:           2c4a907d-0445-443f-be44-f648896f61ed
nodeID:              1

クライアントからアクセス

PS C:\Program Files\cockroach\cockroach-v19.1.1.windows-6.2-amd64> .\cockroach.exe sql --insecure --host=localhost:26257
# Welcome to the cockroach SQL interface.
# All statements must be terminated by a semicolon.
# To exit: CTRL + D.
#
# Server version: CockroachDB CCL v19.1.1 (x86_64-w64-mingw32, built 2019/05/15 20:36:28, go1.11.6) (same version as client)
# Cluster ID: 2c4a907d-0445-443f-be44-f648896f61ed
#
# Enter \? for a brief introduction.
#
root@localhost:26257/defaultdb> create database bank
                             -> ;
CREATE DATABASE

Time: 9.4438ms

root@localhost:26257/defaultdb> create table bank.accounts (id INT PRIMARY KEY, balance Decimal);
CREATE TABLE

Time: 16.0357ms

root@localhost:26257/defaultdb> insert inot bank.accounts values (1, 1000.50);
invalid syntax: statement ignored: syntax error at or near "inot"
DETAIL: source SQL:
insert inot bank.accounts values (1, 1000.50)
       ^
HINT: try \h INSERT
root@localhost:26257/defaultdb> insert into bank.accounts values (1, 1000.50);
INSERT 1

Time: 16.0394ms

root@localhost:26257/defaultdb> select * from bank.accounts;
  id | balance
+----+---------+
   1 | 1000.50
(1 row)

Time: 2.4212ms

root@localhost:26257/defaultdb>

クライアントからサーバへのパケット

サーバからクライアントのパケット