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
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:
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)