database-design

Choosing the right database involves evaluating project requirements like scalability, latency, and features. This Skill provides decision trees to compare PostgreSQL, Neon, Turso, and SQLite, ensuring you select an architecture that prevents data management bottlenecks.

Effective SQL schema design relies on normalization principles, primary key selection, and defining relationships. This Skill provides actionable guidelines to structure your schema efficiently, avoiding common anti-patterns that degrade data integrity and query performance.

Optimizing database performance with indexing requires targeted strategies for query tuning. This Skill offers concrete indexing techniques to avoid performance bottlenecks and ensure efficient data retrieval across your selected database system.

Selecting between Drizzle and Prisma ORMs depends on your database choice and performance needs. This Skill facilitates informed ORM selection by outlining how each integrates with systems like PostgreSQL and SQLite to match your project requirements.

For edge deployment and low latency, you need databases designed for distributed environments. This Skill guides you through selecting appropriate systems like Turso or Neon based on your specific latency and scalability requirements.