stored-procedures

Implement stored procedures, functions, and triggers for business logic, data validation, and performance optimization. Covers procedure design, error handling, and performance considerations.

✅ DO use procedures for complex operations ✅ DO validate inputs in procedures ✅ DO handle errors gracefully ✅ DO document procedure parameters ✅ DO test procedures thoroughly ✅ DO use transactions appropriately ✅ DO monitor procedure performance

❌ DON'T put all business logic in procedures ❌ DON'T use procedures for simple queries ❌ DON'T ignore error handling ❌ DON'T create poorly documented procedures ❌ DON'T use procedures as security layer only

تنفيذ الإجراءات والوظائف المخزنة لمنطق قاعدة البيانات. يُستخدم عند إنشاء إجراءات قاعدة بيانات قابلة لإعادة الاستخدام، أو استعلامات معقدة، أو حسابات من جانب الخادم. المصدر: aj-geddes/useful-ai-prompts.