start cockroachdb branch

1 files changed, 24 insertions, 0 deletions

diff --git a/rust/README.cockroach.md b/rust/README.cockroach.md
new file mode 100644
index 00000000..e42d8c4b
--- /dev/null
+++ b/rust/README.cockroach.md
@@ -0,0 +1,24 @@
+
+Setup a user and database on a local, single-host node:
+
+    # using v2.0.5 (2018/08/13)
+    cockroach start --insecure --store=fatcat-dev --host=localhost
+    cockroach user set maxroach --insecure
+    cockroach sql --insecure -e 'CREATE DATABASE fatcat'
+    cockroach sql --insecure -e 'GRANT ALL ON DATABASE fatcat TO maxroach'
+    cockroach sql --insecure -e 'CREATE DATABASE fatcat_test'
+    cockroach sql --insecure -e 'GRANT ALL ON DATABASE fatcat_test TO maxroach'
+
+Create a .env file:
+
+    DATABASE_URL=postgres://maxroach@localhost:26257/fatcat
+    TEST_DATABASE_URL=postgres://maxroach@localhost:26257/fatcat_test
+    RUST_TEST_THREADS=1
+
+Create:
+
+    cockroach sql --insecure -d fatcat < migrations/2018-05-12-001226_init/down.sql
+    cockroach sql --insecure -d fatcat < migrations/2018-05-12-001226_init/up.sql
+
+    cockroach sql --insecure -d fatcat_test < migrations/2018-05-12-001226_init/down.sql
+    cockroach sql --insecure -d fatcat_test < migrations/2018-05-12-001226_init/up.sql