bearddan2000/groovy-cli-gradle-cockroachdb-multi-node-without-ssl-concat

Creates a small database table

groovy-cli-gradle-cockroachdb-multi-node-without-ssl-concat

Description

Creates a small database table called dog. This table, dog, has been normalized to 3NF. Two new tables have been added, breedLookup and colorLookup. Creates a new table dog_expanded that joins dog, breedLookup and colorLookup.

Turned dog_expanded into a view with an implicit index on dog_expanded.id. Using a subquery with the aggregate function COUNT, create a new view breed_count.

Create a new view dog_final based on breed_count

All output normally seen in a terminal will be in log which will dump to the screen. The project may seem to hang but the logs from the container must be written to the project this can take up to 3 min.

A groovy gradle build, that connects to 3 node cluster cockroach database without ssl.

Tech stack

• groovy
• gradle
  • postgres drivers

Docker stack

• cockroachdb/cockroach:v19.2.2
• gradle:jdk11

To run

sudo ./install.sh -u

• Master node webui
• Slave node 1 webui
• Slave node 2 webui

To stop

sudo ./install.sh -d

For help

sudo ./install.sh -h

Credit

Cockroach setup