Sqlx Code Reviewv1.0.3

A team is building a Rust-based backend for an online store, handling product listings, user orders, and inventory management. This skill helps review SQL queries for security and performance, ensuring compile-time checks prevent SQL injection and transactions maintain data consistency during purchases.

A fintech startup uses Rust with PostgreSQL to process payments and track account balances. The skill reviews connection pool configurations to avoid exhaustion under high load and ensures type mappings for decimal amounts are accurate, critical for regulatory compliance and financial integrity.

A healthcare application manages patient records and medical histories in a secure database. The skill checks migration patterns for safe schema updates without data loss and verifies enum mappings between Rust and SQL to maintain data consistency for sensitive health information.

An IoT company collects sensor data from devices into a PostgreSQL database for real-time analysis. The skill reviews query patterns to optimize performance with large datasets, using streaming fetches for efficiency, and ensures pool timeouts prevent resource leaks in continuous data ingestion.

A company offers a database-driven software-as-a-service platform, such as a CRM or project management tool. Using this skill ensures robust SQL code that scales with user growth, minimizes downtime from migrations, and maintains data security to support recurring revenue from subscriptions.

A consultancy firm provides specialized Rust and database review services to clients. This skill enables thorough audits of sqlx codebases, identifying critical issues like SQL injection risks and performance bottlenecks, generating revenue through project-based contracts or hourly rates.

A vendor develops proprietary enterprise software, such as inventory management or logistics systems, sold with licenses. The skill helps maintain high-quality database interactions, ensuring reliability and compliance for large-scale deployments, driving revenue from one-time sales or annual licenses.