Skip to content

b812pon/java-cli-bloop-sbt-cockroachdb-multi-node-without-ssl-function

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

java-cli-bloop-sbt-cockroachdb-multi-node-without-ssl-function

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. Added clustered indexes on dog.breedId and dog.colorId and a non-clustered index for dog_expanded.id.

Turned dog_expanded into a view with an implicit index on dog_expanded.id. Using an user defined function, create a new view 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 java bloop-sbt build, that connects to 3 node cluster cockroach database without ssl.

Compiled and ran from build server bloop.

Build note

Dependencies must be compatable with jdk8 or less.

Tech stack

  • bloop
  • java
  • bloop-sbt
    • postgres drivers

Docker stack

  • cockroachdb/cockroach:v19.2.2
  • hseeberger/scala-bloop-sbt:11.0.2-oraclelinux7_1.3.5_2.12.10

To run

sudo ./install.sh -u

To stop

sudo ./install.sh -d

For help

sudo ./install.sh -h

Credit

Cockroach setup