Docker Benchmarking Battle

The app demonstrates the performance differences between SingleStore, MySQL, and PostgreSQL on a dataset of over 110 million records. It is a demo application built using the SingleStore Free Dev image, as well as MySQL and PostgreSQL images.

Getting Started

1. Install and launch Docker Desktop.
2. Open a terminal in the root directory of the project and install dependencies by running: npm i.
3. In the ./apps/db directory, create a .env file based on .env.example.
4. Start the Docker containers by running: make up.
5. Wait 5–10 seconds, then initialize the singlestore image by running: make singlestore-init.
6. In the ./packages/singlestore, ./packages/mysql, and ./packages/postgres directories, create .env files based on the corresponding .env.example files.
7. From the root directory of the project, push the database schemas by running: npm run db:push.

Generating and Loading Data

1. In the ./apps/data-generator directory, create a .env file based on .env.example.
2. Generate data (100M+ records) by running: npm run generate:start.
3. Load the data by running: npm run load:start.
4. Create indexes by running: npm run indexes:create.

Running the Client App

1. In the ./apps/client directory, create a .env file based on .env.example.
2. Build and start the app by running: npm run build && npm run start.
3. Open http://localhost:3000 in your browser.

---

Start With SingleStore – $600 in Free Credits