Database

  • Use prepared statements for queries

  • Keep SQL files organized by date

  • Test migrations in development first

  • Follow table naming conventions

  • Implement proper foreign key relationships

  • Use appropriate data types

  • Keep tables normalized

  • Document database schema changes

  • Backup data regularly

  • Monitor query performance

Last updated