database-design

Choosing the right database involves evaluating project requirements like scale and deployment environment. This skill guides you through selecting between PostgreSQL, Neon, Turso, and SQLite by comparing their trade-offs for schema design, indexing, and ORM compatibility.

Selecting an ORM for edge deployment requires checking compatibility with edge environments. This skill helps you evaluate ORMs like Drizzle, Prisma, and Kysely to determine which best fits your serverless or edge architecture requirements.

Designing an efficient database schema requires applying normalization principles, defining primary keys, and structuring relationships. This skill provides indexing strategies to optimize query performance and avoid common pitfalls like the N+1 problem.

Comparing PostgreSQL and SQLite depends on your scalability and deployment needs. This skill outlines the trade-offs between relational databases and serverless options like Neon and Turso, helping you choose the best fit for scalable data management.

Fixing the N+1 query problem involves analyzing query performance and applying proper indexing strategies. This skill covers optimization techniques to resolve common pitfalls and ensure efficient data retrieval in your application.