database-design

Choosing the right database involves evaluating project requirements against options like PostgreSQL, Turso, and SQLite. This Skill guides database selection by matching deployment environments, such as edge deployments, with scalable and performant data storage solutions.

Relational database schema design best practices include normalization, primary key selection, and timestamp implementation. This Skill provides principles for relationship modeling to ensure efficient data storage and retrieval across your chosen architecture.

Comparing PostgreSQL and SQLite for edge deployment depends on your scalability needs. This Skill helps you decide whether a traditional PostgreSQL setup or an edge-optimized SQLite solution like Turso better fits your performance requirements.

Creating effective indexing strategies requires knowing when and how to apply indexes. This Skill explains indexing techniques to improve query performance and facilitate efficient data retrieval within your database architecture.

Choosing the best ORM involves comparing options like Drizzle, Prisma, and Kysely. This Skill helps you select the right ORM for your needs, ensuring safe database migrations and optimized queries across PostgreSQL or SQLite environments.