Cockroach DBを使ってみる
サーバ起動
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>