Best ChatGPT prompts for Web Developers

Given a web application with a PostgreSQL database, a Node.js backend, and a React frontend, analyze the current database schema and query patterns to identify bottlenecks and propose a revised schema and query optimization strategy to reduce latency by at least 30%. Consider factors such as indexing, caching, and connection pooling, and provide a step-by-step plan for implementing the proposed changes, including any necessary code updates and testing protocols.

A recent deployment of a mission-critical web application to a Kubernetes cluster on AWS resulted in unexpected downtime and errors. Analyze the deployment script, container logs, and system metrics to identify the root cause of the failure, and provide a detailed report outlining the corrective actions needed to prevent similar failures in the future, including any updates to the CI/CD pipeline, infrastructure configuration, or application code.

Develop a comprehensive framework for A/B testing and user experience optimization on a high-traffic e-commerce web application, including a detailed plan for defining test hypotheses, designing test variants, implementing testing infrastructure using a library such as Optimizely, and analyzing test results to inform data-driven design decisions. Provide example code snippets and pseudocode to illustrate key concepts, and discuss strategies for minimizing testing overhead and ensuring seamless user experiences.

Develop a comprehensive disaster recovery plan for a cloud-based web application hosted on GCP, including a detailed analysis of potential failure modes, a step-by-step plan for restoring service in the event of a disaster, and a discussion of strategies for minimizing downtime and data loss. Provide example scripts and configuration files to illustrate key concepts, such as data backup and restore procedures, and discuss the trade-offs between different disaster recovery strategies, including pilot lights, warm standsbys, and hot standbys.