Nancy CLI: Automated Database Experimentation Tool
Nancy CLI is a powerful command-line interface designed for conducting automated database experiments, enabling users to validate SQL queries and benchmark performance across various PostgreSQL versions. It seamlessly integrates with Docker, allowing for flexible experimentation in cloud and on-premise environments.
Features
Supports PostgreSQL versions 9.6, 10, 11, and 12, ensuring compatibility with a wide range of setups.
Allows execution of custom SQL queries and synthetic workloads using pgbench for comprehensive testing.
Enables automated database configuration changes, index additions, and DDL modifications, facilitating performance optimization.
Runs experiments on AWS EC2 Spot Instances with auto-detection of the lowest prices, enhancing cost-efficiency.
Collects detailed performance metrics and SQL logs for in-depth analysis and reporting.