Quellen, sql-db-migrations
10 Quellen in /var/www/code/sql-db-migrations/sources.yaml.
| ID | Titel | URL / Referenz | Publisher | Typ | Relevanz |
|---|---|---|---|---|---|
| POSTGRES_CONSTRAINTS | PostgreSQL Documentation: Constraints | https://www.postgresql.org/docs/current/ddl-constraints.html | PostgreSQL Global Development Group | documentation | Primary Keys, Foreign Keys, Unique, Check und Not Null. |
| POSTGRES_INDEXES | PostgreSQL Documentation: Indexes | https://www.postgresql.org/docs/current/indexes.html | PostgreSQL Global Development Group | documentation | Indexarten und Indexnutzung fuer Filter, Sortierung und Suche. |
| POSTGRES_TRANSACTIONS | PostgreSQL Documentation: Transactions | https://www.postgresql.org/docs/current/tutorial-transactions.html | PostgreSQL Global Development Group | documentation | Atomare Arbeitseinheiten und Commit/Rollback. |
| POSTGRES_ISOLATION | PostgreSQL Documentation: Transaction Isolation | https://www.postgresql.org/docs/current/transaction-iso.html | PostgreSQL Global Development Group | documentation | Nebenlaeufigkeit, Isolation und sichtbare Datenzustaende. |
| POSTGRES_EXPLAIN | PostgreSQL Documentation: Using EXPLAIN | https://www.postgresql.org/docs/current/using-explain.html | PostgreSQL Global Development Group | documentation | Nachweis fuer Query-Plan, Indexnutzung und Kosten. |
| POSTGRES_ALTER_TABLE | PostgreSQL Documentation: ALTER TABLE | https://www.postgresql.org/docs/current/sql-altertable.html | PostgreSQL Global Development Group | documentation | Schema-Aenderungen, Constraints und Lock-Risiken. |
| POSTGRES_BACKUP | PostgreSQL Documentation: Backup and Restore | https://www.postgresql.org/docs/current/backup.html | PostgreSQL Global Development Group | documentation | Backup- und Restore-Grundlagen fuer Migrationen. |
| OWASP_SQL_INJECTION | OWASP SQL Injection Prevention Cheat Sheet | https://cheatsheetseries.owasp.org/cheatsheets/SQL_Injection_Prevention_Cheat_Sheet.html | OWASP | security_guidance | Prepared Statements und sichere Query-Konstruktion. |
| LOCAL_PHP_SPECS | Lokale PHP YAML Library | file:/var/www/code/php | Projekt | local_policy | DDD/Hexagonal/OOP/MVC-Regeln fuer Repository- und Domain-Grenzen. |
| LOCAL_GUI_TABLES | Lokale GUI Library Datentabellen CRUD | file:/var/www/code/gui/datentabellen-crud | Projekt | local_policy | Tabellenanforderungen an Suche, Filter, Sortierung und Pagination. |