database-design

Selecting between PostgreSQL and SQLite depends on your deployment environment and latency needs. This skill provides decision trees for technology selection, evaluating factors like scalability and whether managed services like Neon or Turso fit your project needs.

Select an ORM by matching it to your database technology and query patterns. This skill assists in choosing between Drizzle, Prisma, and Kysely, ensuring your selection aligns with your schema design and optimization strategies.

Fix the N+1 query problem by implementing proper indexing and query optimization techniques. This skill offers solutions for N+1 issues, guiding you through indexing strategies and relationship modeling to optimize database queries effectively.

Performing zero-downtime database migrations requires following safe migration best practices. This skill guides you through zero-downtime migration processes, ensuring schema changes do not disrupt application availability during deployment.

Yes, you can use this database design guidance for a new Python project, as it requires Python3. The skill provides comprehensive principles for schema design, normalization, and primary keys applicable across various database systems.

Key principles for database schema design include proper normalization, defining primary keys, and structuring relationships effectively. This skill offers comprehensive guidance on these principles to help you design robust and efficient databases.