Listing Thumbnail

    DBLab SE - instant cloning and database branching for PostgreSQL

     Info
    Deployed on AWS
    DBLab Standard Edition (DBLab SE) delivers fast, cost-effective database cloning, enabling agile teams to create instant, full-size production clones for development, testing, and staging, all managed like code, integrated into CI/CD pipelines, and optimized with transparent pricing.
    5

    Overview

    Play video

    DBLab Standard Edition (DBLab SE) delivers blazing-fast database cloning and database branching capabilities, empowering agile teams to create instant, full-size clones of production databases for building robust development, testing, QA, and staging environments. With a self-service UI, team members can quickly spin up virtual test data environments, managed like code, supporting version control and seamless sharing across teams. These environments enable efficient testing of migrations, SQL query optimization, troubleshooting, and deployment of staging applications with production-grade data. Integrated into the CI/CD pipeline, DBLab SE accelerates development, integration, bug resolution, and testing while minimizing storage overhead.

    Instant cloning is enabled by ZFS's copy-on-write (CoW) feature and containers, with processes optimized for Postgres-specific requirements.

    An example of a small team of 3-5 engineers and a 1 TiB database:

    • r7i.2xlarge (8 vCPUs, 64 GiB RAM) and 3 TiB disk space
    • total monthly cost $962.77 (compute: $386.32, DBLab SE $330.69, storage $245.76
    • serves 3 snapshots, unlimited user snapshots and branches, 50 clones, 5-10 of which are simultaneously used

    Highlights

    • Eliminate downtime and accelerate development with instant production database clones, providing data availability that aligns with the demands of a fast-paced release cycle. Empower your CI/CD pipeline with powerful testing capabilities, enabling teams to rapidly recreate data states for debugging and problem-solving.
    • Optimize SQL queries risk-free on database clones, guided by Joe Bot, your virtual DBA assistant.
    • Give every developer their own full-size database clone without the hassle or high costs, thanks to virtual copies that stay synchronized with production environments, minimizing cloud storage and compute expenses.

    Details

    Delivery method

    Delivery option
    Database Lab Engine (DLE) for PostgreSQL

    Latest version

    Operating system
    Ubuntu 22.04

    Deployed on AWS
    New

    Introducing multi-product solutions

    You can now purchase comprehensive solutions tailored to use cases and industries.

    Multi-product solutions

    Features and programs

    Financing for AWS Marketplace purchases

    AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
    Financing for AWS Marketplace purchases

    Pricing

    DBLab SE - instant cloning and database branching for PostgreSQL

     Info
    Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time.
    Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator  to estimate your infrastructure costs.

    Usage costs (18)

     Info
    Dimension
    Cost/hour
    m7i.12xlarge
    $2.177
    r7i.16xlarge
    $3.81
    m7i.xlarge
    $0.181
    r7i.large
    $0.12
    r7i.8xlarge
    $1.91
    r7i.48xlarge
    $11.43
    m7i.16xlarge
    $2.903
    m7i.48xlarge
    $8.709
    m7i.24xlarge
    $4.354
    m7i.2xlarge
    $0.362

    Vendor refund policy

    We do not currently support refunds, but you can cancel at any time.

    How can we make this page better?

    We'd like to hear your feedback and ideas on how to improve this page.
    We'd like to hear your feedback and ideas on how to improve this page.

    Legal

    Vendor terms and conditions

    Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .

    Content disclaimer

    Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.

    Usage information

     Info

    Delivery details

    Database Lab Engine (DLE) for PostgreSQL

    DLE configuration will be done inside DLE UI, once all AWS resources are already provisioned. For provisioning, you need to:

    • Choose AWS region
    • Choose EC2 instance type (the more CPU power and RAM you have, the more thin clones can be running with good performance, e.g. m5.2xlarge with its 8 vCPUs / 32 GiB is good to run up to 30 thin clones, but more vCPUs might be needed of more than 5-8 people or CI pipelines are going to work with DLE in parallel)
    • Specify the database size (this will define the size of the EBS volume used)
    • Optionally, configure SSL
    CloudFormation Template (CFT)

    AWS CloudFormation templates are JSON or YAML-formatted text files that simplify provisioning and management on AWS. The templates describe the service or application architecture you want to deploy, and AWS CloudFormation uses those templates to provision and configure the required services (such as Amazon EC2 instances or Amazon RDS DB instances). The deployed application and associated resources are called a "stack."

    Version release notes

    This is release of DBLab SE 4.0.3 for AWS Marketplace. Release notes: https://github.com/postgres-ai/database-lab-engine/releases 

    Additional details

    Usage instructions

    To access API and UI, read instructions in the "Outputs" section once deployment is complete.

    Resources

    Support

    Vendor support

    • Asynchronous troubleshooting help (please allow us 24 hours to respond during business days)
    • If your production database is on a managed Postgres service (such as RDS) and database size exceeds 2 TiB, please reach out to us: consulting@postgres.ai 

    AWS infrastructure support

    AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.

    Product comparison

     Info
    Updated weekly

    Accolades

     Info
    Top
    10
    In Testing
    Top
    25
    In Databases

    Overview

     Info
    AI generated from product descriptions
    Copy-on-Write Cloning Technology
    Instant cloning enabled by ZFS copy-on-write (CoW) feature and containers with Postgres-specific optimization
    CI/CD Pipeline Integration
    Seamless integration into CI/CD pipelines for accelerated development, integration, bug resolution, and testing workflows
    Version Control and Code Management
    Database environments managed like code with version control support and seamless sharing capabilities across teams
    Virtual Database Branching
    Database branching capabilities enabling creation of virtual test data environments with synchronized production data
    Self-Service Environment Provisioning
    Self-service UI enabling team members to quickly provision virtual test data environments for development, testing, QA, and staging
    Data Provisioning Speed
    Provision virtual copies of production data in minutes for application development, debugging, or migration projects.
    Multi-Source Data Support
    Support for diverse data sources including AWS Aurora, AWS RDS, Oracle, SQL Server, ASE, SAP, Oracle EBS, NoSQL, PostgreSQL, and HANA.
    Data Masking and Compliance
    Integrates with Continuous Compliance to replace sensitive values with fictitious yet valid equivalents while maintaining referential integrity for GDPR, CCPA, and other regulatory requirements.
    Version Control and Data Management
    Version control data with capabilities to rewind, refresh, and share datasets from any point in time.
    Virtual Data Copies
    Create virtual copies of production data that are kept in sync with production while reducing storage and compute costs.
    Oracle Compatibility
    Native Oracle compatibility enabling seamless connection to legacy applications, code interpretation, and query execution without requiring code rewrites.
    High Availability
    Up to 99.995% availability on AWS cloud with best-in-class HA, geo-distributed databases, and disaster recovery capabilities.
    Performance Optimization
    5X performance improvement compared to open source PostgreSQL through optimized database configuration and execution.
    Distributed Database Architecture
    Multi-region distributed database deployment enabling geo-distributed data placement and disaster recovery across multiple AWS regions.
    License Portability
    Ability to move on-premises EDB Postgres workloads to AWS cloud while maintaining existing license investments and leveraging cloud discounts.

    Contract

     Info
    Standard contract
    No

    Customer reviews

    Ratings and reviews

     Info
    5
    1 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    100%
    0%
    0%
    0%
    0%
    1 AWS reviews
    Denis

    Good and useful product

    Reviewed on Dec 06, 2022
    Review from a verified AWS customer

    We have been using Database Lab Engine at Boost Sport AI for more than two years and it helped us a lot in dealing with data and the development process.
    There are two most common usage scenarios for us:
    - Having a fast clone for the data scientist or developer to be able to play with data (including necessary data modification) without having to wait for the long process of database cloning. Using Database Lab we can have a new clone in seconds, without having to wait and not needing to have much storage for each of the clones.
    - A developer can have a database he/she can use for his development backend instance without having to make a clone on his machine or elsewhere, and he can quickly update this database instance to match the current production data.

    View all reviews