We are happy to announce version 2.1.0 of Database Lab Engine (DLE), an open-source tool for building powerful development and testing environments based on thin cloning of PostgreSQL databases. Using Database Lab API or CLI (and if you are using Database Lab SaaS, GUI), on a single machine with, say, a 1 TiB disk, you can easily create and destroy dozens of database copies of size 1 TiB each. All these copies are independently modifiable and created/destroyed in just a few seconds. This can become a game-changer in your development and testing workflow, improving time-to-market, and reducing costs of your non-production infrastructure.
In 2.1, the main new features are:
- Better data protection and security:
- robust configuration defining how data is patched when snapshots are automatically created (both shell and SQL scripts are now supported),
- an option specifying whether or not passwords for the existing DB users need to be preserved.
- [experimental] DLE API and the CLI tool are extended to have a new feature: "CI Observer" helping control DB schema changes (DB migrations) — here is the reference on how to use it https://postgres.ai/docs/reference-guides/dblab-client-cli-reference#subcommand-start-observation. This is a small step towards the big goal: have 100% coverage for testing DB migrations in CI using full-sized thin clones. Watch the demo (turn captions on):
- Database Lab Engine 2.1.0 release notes
- Resources – an interactive tutorial, case studies
- Tutorial for RDS users
- Tutorial for any PostgreSQL database
- Database Lab Engine configuration reference
Please send us any feedback you have – it is hard to overestimate its meaning for such a young project:
- Follow us on Twitter: @Database_Lab
- Community Slack (English), and Telegram group (Russian)
- Intercom widget (located at the right bottom corner)
- Database Lab Engine repository, with the issue tracker
Database Lab Engine allows cloning PostgreSQL databases of any size in just a few seconds. This can save a lot of money for development and testing infrastructure, and at the same time, drastically improve development quality and time-to-market. Database Lab Engine is open-source software distributed under OSI-approved AGPLv3 license.
Database Lab Engine is equipped with API and CLI. Additionally, we at Postgres.ai continue developing the Enterprise version that offers GUI, authentication flexibility, and user management for Database Lab Engine API and CLI, more. The Enterprise version is in the "private beta" mode; we encourage you to sign up and request a demo.
Database Lab by Postgres.ai
An open-source experimentation platform for PostgreSQL databases. Instantly create full-size clones of your production database and use them to test your database migrations, optimize SQL, or deploy full-size staging apps.