All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 4,325
- 181
Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.
Open in full browserBrowse databases skills
Showing 1,177–1,200 of 4,325 skills
- Drizzle Relations Pattern> Define Drizzle relations with relations(), one(), many(), references(), and inferred typesVotes: 0GitHub stars: 20
- Drizzle Raw Sql> Execute raw SQL safely in Drizzle with the sql template tag, db.execute(), and placeholder()Votes: 0GitHub stars: 20
- Drizzle Query Builder> Compose type-safe SQL with Drizzle's fluent query builder for select, insert, update, and deleteVotes: 0GitHub stars: 20
- Drizzle Performance Patterns> Optimize Drizzle queries with prepared statements, db.batch(), explain analysis, and join-based N+1 avoidanceVotes: 0GitHub stars: 20
- Drizzle Migrations> Manage Drizzle schema evolution with drizzle-kit generate/push/migrate and introspectVotes: 0GitHub stars: 20
- Drizzle Filtering Pattern> Filter Drizzle queries with eq(), and(), or(), between(), sql template tag, and custom conditionsVotes: 0GitHub stars: 20
- Db Zero Downtime Migration> Online schema changes that avoid table locks and keep the application serving traffic throughout the migration.Votes: 0GitHub stars: 20
- Db Vertical Partitioning> Splitting a wide table into multiple narrower tables, separating hot columns from cold columns, and managing large objects with TOAST to reduce I/O and improve cache efficiency.Votes: 0GitHub stars: 20
- Db Time Series> Designing append-heavy tables for metrics, events, and logs with time-based partitioning, retention policies, and efficient aggregation.Votes: 0GitHub stars: 20
- Db Third Normal Form> "Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key." -- Codd's memorable definition of full normalization through 3NF.Votes: 0GitHub stars: 20
- Db Temporal Data> Modeling when facts are true (valid-time), when they were recorded (transaction-time), or both (bitemporal), enabling time-travel queries and regulatory audit.Votes: 0GitHub stars: 20
- Db Table Partitioning> Splitting a large table into smaller physical partitions by range, list, or hash to improve query performance, simplify maintenance, and enable efficient data lifecycle management.Votes: 0GitHub stars: 20
- Db Second Normal Form> Every non-key column must depend on the entire composite primary key, not just part of it -- eliminating partial dependencies.Votes: 0GitHub stars: 20
- Db Scan Types> Understanding when the planner chooses sequential scan, index scan, bitmap scan, or index-only scan and why each is optimal for different selectivity ranges.Votes: 0GitHub stars: 20
- Db Read Phenomena> The SQL standard defines three read anomalies (dirty, non-repeatable, phantom) that isolation levels progressively prevent, plus PostgreSQL adds write skew as a fourth anomaly relevant to Serializable.Votes: 0GitHub stars: 20
- Db Query Statistics> How the planner uses table statistics (pg_stats, histograms, most-common-values) to estimate row counts and choose execution plans.Votes: 0GitHub stars: 20
- Db Query Rewriting> Structural query transformations that help the planner choose better execution plans without changing results.Votes: 0GitHub stars: 20
- Db Polymorphic Associations> Modeling inheritance hierarchies and type-varying relationships in relational databases using single-table inheritance (STI), class-table inheritance (CTI), or shared foreign key patterns.Votes: 0GitHub stars: 20
- Db Pessimistic Locking> Pessimistic locking acquires locks before modifying data, guaranteeing exclusive access and preventing conflicts at the cost of reduced concurrency.Votes: 0GitHub stars: 20
- Db Partial Index> Indexes with a WHERE clause that index only a subset of rows, reducing size and improving performance for targeted query patterns.Votes: 0GitHub stars: 20
- Db Optimistic Locking> Optimistic locking assumes conflicts are rare, allows concurrent reads without locks, and detects conflicts at write time using version columns or conditional updates.Votes: 0GitHub stars: 20
- Db Nested Sets> Encoding hierarchy position with left/right boundary numbers for O(1) subtree and ancestor queries at the cost of expensive writes.Votes: 0GitHub stars: 20
- Db Mvcc> MVCC allows readers and writers to operate concurrently without blocking each other by maintaining multiple versions of each row, with visibility determined by transaction snapshots.Votes: 0GitHub stars: 20
- Db Migration Rollback> Forward-only vs reversible migrations, data backfill safety, and blue-green schema patterns for confident schema evolution.Votes: 0GitHub stars: 20