Results for “database-upsert”

Explains MariaDB's REPLACE statement: its delete-then-insert behavior, when it triggers, data-loss risks, and the upsert alternative. Use when writing or reviewing REPLACE statements.

Optimizes database queries and improves performance across PostgreSQL and MySQL systems by analyzing execution plans, designing index strategies, and tuning configurations.

Provides structured prompts for analyzing, planning, and executing .NET framework upgrades, covering project assessment, dependency management, code modernization, CI/CD updates, testing, and documentation.

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

Nested Sets

Expert-level PostgreSQL database administration, advanced queries, performance tuning, and production operations

Ecto database toolkit reference for Elixir. Covers schemas, changesets with validation, composable query DSL, joins, preloading, aggregates, migrations, transactions with Ecto.Multi, and embedded schemas.

Provides safe, reversible database schema change patterns for PostgreSQL, MySQL, and common ORMs, with guidance on zero-downtime deployments, rollbacks, and migration tooling.

Database Naming Standards

Database Review — Forge Skill

Databases Design Expert Skill

Ingests case studies, past proposals, and boilerplate from library/inbox into structured indexes. Use when the user requests to 'index proposal library', 're-index case studies', 'ingest inbox docs', or 'validate library'.

Adds a new database table and generates all six layers of the platform codebase, from schema to UI, with validation at each step.

Use when searching NCBI Entrez databases (pubmed, gene, protein, nuccore, snp, geoprofiles) with query strings and field qualifiers to retrieve record UIDs for downstream processing.

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

Safe patterns for evolving database schemas in production with decision trees and troubleshooting guidance.

**Pattern:**

Closure Table

Choose between DML statements and Database class methods for bulk Salesforce operations, handling partial success, DMLOptions, and error collection.