القائمة
PostgreSQL database configuration and best practices
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
| name | postgresql |
| description | PostgreSQL database configuration and best practices |
| license | MIT |
| compatibility | opencode |
| metadata | {"type":"database","engine":"postgresql"} |
cycle-orm)# config/packages/doctrine.yaml (Symfony)
doctrine:
dbal:
url: '%env(resolve:DATABASE_URL)%'
options:
# SSL/TLS para conexiones seguras
1009: '%env(resolve:DATABASE_SSL_CA)%'
-- migrations/V001__initial_schema.sql
CREATE TABLE categories (
id UUID PRIMARY KEY,
name VARCHAR(50) NOT NULL,
icon VARCHAR(50),
color_hex VARCHAR(7) NOT NULL DEFAULT '#6B7280',
display_order INT NOT NULL DEFAULT 0,
CONSTRAINT uq_categories_name UNIQUE (name)
);
CREATE INDEX idx_categories_display_order ON categories(display_order);
Nota: Este proyecto usa Cycle ORM, no Doctrine. Ver skill
cycle-ormpara patrones de mapeo.
Multi-provider LLM integration for phrase generation (Groq, OpenAI, Gemini, extensible)
Cycle ORM patterns, configuration and common pitfalls for Symfony integration
Docker with multi-stage builds, security best practices and Docker Compose
Symfony framework with PestPHP testing and Clean Architecture patterns
WCAG 2.2 AA compliance for SAAC applications
Symfony with Pest PHP testing framework and TDD patterns