databases

To write secure SQL queries and prevent SQL injection, use parameterized queries instead of string concatenation. This Skill provides guidance on implementing parameterized queries to ensure your database interactions remain safe from injection attacks.

Database schema design best practices involve normalizing tables, defining clear relationships, and adding appropriate indexes. This Skill offers guidance on structuring schemas for data integrity and optimizing query performance across SQLite and PostgreSQL.

Yes, this guidance covers Redis patterns for caching and rate limiting. It provides specific database patterns and best practices for implementing efficient caching strategies and managing rate limits within your application architecture.

Managing database transactions in PostgreSQL requires adherence to best practices for data integrity. This Skill addresses transaction management strategies to ensure your database operations remain reliable and consistent during complex workflows.

SQLite WAL mode is a journaling mode that allows concurrent read and write operations. This Skill provides database-specific guidance on leveraging WAL mode in SQLite to improve performance and concurrency in your applications.

Implementing indexing strategies requires adding appropriate indexes to your database tables based on query patterns. This Skill guides you through schema design and indexing strategies to optimize data retrieval and overall database performance.