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
🐳 The best use of this is from the docker-compose environment set in ./docker/yb-lab on Podman, Docker
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
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.