Data .mdc

Database

Database best practices focusing on Prisma and Supabase integration

Nasıl kullanılır
  1. Kural içeriğini kopyala.
  2. Projenin root klasöründe şu dosyayı oluştur: .cursorrules veya .cursor/rules/database.mdc
  3. İçeriği yapıştır ve kaydet.

Database Best Practices

Prisma Setup

  • Use proper schema design
  • Implement proper migrations
  • Use proper relation definitions
  • Configure proper connection
  • Implement proper seeding
  • Use proper client setup

Prisma Models

  • Use proper model naming
  • Implement proper relations
  • Use proper field types
  • Define proper indexes
  • Implement proper constraints
  • Use proper enums

Prisma Queries

  • Use proper query optimization
  • Implement proper filtering
  • Use proper relations loading
  • Handle transactions properly
  • Implement proper pagination
  • Use proper aggregations

Supabase Setup

  • Configure proper project setup
  • Implement proper authentication
  • Use proper database setup
  • Configure proper storage
  • Implement proper policies
  • Use proper client setup

Supabase Security

  • Implement proper RLS policies
  • Use proper authentication
  • Configure proper permissions
  • Handle sensitive data properly
  • Implement proper backups
  • Use proper encryption

Supabase Queries

  • Use proper query optimization
  • Implement proper filtering
  • Use proper joins
  • Handle real-time properly
  • Implement proper pagination
  • Use proper functions

Database Design

  • Use proper normalization
  • Implement proper indexing
  • Use proper constraints
  • Define proper relations
  • Implement proper cascades
  • Use proper data types

Performance

  • Use proper connection pooling
  • Implement proper caching
  • Use proper query optimization
  • Handle N+1 queries properly
  • Implement proper batching
  • Monitor performance metrics

Security

  • Use proper authentication
  • Implement proper authorization
  • Handle sensitive data properly
  • Use proper encryption
  • Implement proper backups
  • Monitor security issues

Best Practices

  • Follow database conventions
  • Use proper migrations
  • Implement proper versioning
  • Handle errors properly
  • Document schema properly
  • Monitor database health

Benzer kurallar

Daha fazla: Data →