Database Lab Engine (DLE) is an open-source (AGPLv3) technology that allows blazing-fast cloning of Postgres databases of any size in seconds. This helps solve many problems such as:
- build dev/QA/staging environments involving full-size production-like databases,
- provide temporary full-size database clones for SQL query analysis optimization (see Joe bot),
- automatically verify database migrations (DB schema changes) and massive data operations in CI/CD pipelines to minimize risks of downtime and performance degradation.
As an example, cloning a 10 TiB PostgreSQL database can take less than 2 seconds.
- How it works
- Database Migration Testing
- SQL Optimization with Joe Bot
- Case Study: Qiwi (How Qiwi Controls the Data to Accelerate Development)
- Case Study: GitLab (How GitLab iterates on SQL performance optimization workflow to reduce downtime risks)
Please support the project giving a GitLab star! It's on the main page, at the upper right corner:
- How to install Database Lab with Terraform on AWS
- How to install and initialize Database Lab CLI
- How to manage DLE
- How to work with clones
- DLE Docker images
- Extended Docker images for PostgreSQL (with plenty of extensions)
- SQL Optimization chatbot (Joe Bot)
- DB Migration Checker
Open an Issue to discuss ideas, open a Merge Request to propose a change.
See our GitLab Container Registry to find the images built for development branches.
- Install
golangci-lint: https://github.com/golangci/golangci-lint#install