DEV Community

Cover image for YBDemo: simple πŸ’» demo lab for YugabyteDB with Java client and DockerπŸš€β˜•πŸ³πŸ˜

YBDemo: simple πŸ’» demo lab for YugabyteDB with Java client and DockerπŸš€β˜•πŸ³πŸ˜

Here is the demo environment I use on my laptop to test YugabyteDB deployment options and operations. You find the docker-compose.yaml in https://github.com/FranckPachot/ybdemo/tree/main/docker/yb-lab

GitHub logo FranckPachot / ybdemo

Lab environment for YugabyteDB demos

🐳 The best use of this is from the docker-compose environment set in ./docker/yb-lab on Podman, Docker

or even:

Open in Gitpod

YBDemo

YBDemo is a simple Java program that creates an HikariCP connection pool from the hikari.properties file in the current directory, and takes SQL statements to execute as lines from stdin. There's no multi-line statement: each line is a thread, executing the statement in a loop. The goal is to make it easy to run a demo with concurrent threads by providing the set of queries in a simple way, interactive or though file redirection. Only the first column of the first row is displayed, I use row_to_json() or json_agg() to format a larger result into one value. The thread stops if no row is returned, I use RETURNING to get a row from DML.

The goal is to run it on PostgreSQL compatible databases, especially distributed ones like YugabyteDB…






All feedbacks and comments welcome, follow twitter, linkedin to share and learn more, and ⭐ are highly appreciated on the repo 😎

πŸš€ YugabyteDB is a distributed SQL database, open source, and PostgreSQL compatible.

Top comments (0)