Results for “syntax-differences”

Explains MariaDB-specific SET syntax and behavior, including scope rules, the SET STATEMENT ... FOR extension, and persistence differences from MySQL.

Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.

Documents MariaDB-specific UPDATE syntax and behavior, including single-table vs multi-table forms, assignment evaluation order, RETURNING with OLD_VALUE(), temporal tables, and common pitfalls. Use when writing, generating, or reviewing UPDATE statements targeting MariaDB.

Foundational SQL patterns for query writing, schema design, and dialect differences. Use when writing SQL queries, designing database schemas, understanding SQL syntax across PostgreSQL/MySQL/SQLite, or preparing SQL for conversion to other query languages. This is a meta-skill for SQL derivatives.

Render a side-by-side HTML diff of the original article vs the updated draft so the editor can review every change in browser.

Generates interactive HTML explainers for code diffs, branches, and PRs from a single Markdown document, using a renderer to produce styled output with diagrams and quizzes.

Creates a self-contained interactive HTML explanation of code changes, including background, intuition, code walkthrough, and quiz sections, with diagrams and responsive styling.

Translates English text paragraph by paragraph into Chinese and provides deep linguistic analysis covering vocabulary, phrases, grammar, voice, syntax, and sentence structure.

PowerShell Windows patterns. Critical pitfalls, operator syntax, error handling.

Explains MariaDB-specific view syntax and behavior, including CREATE OR REPLACE VIEW, ALGORITHM options, SQL SECURITY, updatability rules, and WITH CHECK OPTION, for writing or reviewing MariaDB view statements.

Reference for test filter syntax across VSTest and MTP platforms, covering MSTest, NUnit, xUnit v3, and TUnit frameworks with examples and translation guidance.

Create, refresh, and rewrite PR titles and descriptions following Sentry conventions, focusing on reviewer-facing content that describes the full branch diff.

Review documentation and prose for compliance with writing guidelines, checking style, voice, and tone against a fetched rule set.

Compares Trailmark code graphs at two source code snapshots to surface security-relevant structural changes that text diffs miss, such as new attack paths, blast radius growth, and privilege boundary modifications.

Compares two code versions for semantic equivalence by tracing both side-by-side, identifying divergences, and producing a structured verdict.

Write PHP following PSR coding standards, SOLID principles, and code-quality guidelines. Use for PHP style, design, refactoring, naming, and guard clauses—not Composer/PSR-4 project configuration.

Apply Optionals, Protocols, Extensions, and Type Safety patterns in Swift. Use when working with Swift Optionals, Protocols, Extensions, or type-safe APIs.

Swift language fundamentals (5.10+ / 6.x). Covers optionals, value vs reference semantics, protocols & generics, Swift Concurrency (async/await, actors, Sendable, structured tasks), Result Builders, and Apple platform interop. USE WHEN: user mentions "Swift", "SwiftUI", "async/await Swift", "actor", "Sendable", "Codable", "Combine", "Result Builder", "Apple Keychain", "Secure Enclave", "iOS native" DO NOT USE FOR: SwiftUI screen layouts in depth - use SwiftUI-specific skill if exists DO NOT USE FOR: Compose iOS via Skia - use `frontend-frameworks/compose-multiplatform` DO NOT USE FOR: Kotlin/Native ↔ Swift bridging - use `languages/uniffi`

Avoid common Ansible mistakes covering YAML syntax traps, variable precedence, idempotence failures, and handler gotchas.

Provides MariaDB-specific syntax and behavior for CREATE, ALTER, and DROP DATABASE statements, including OR REPLACE vs IF NOT EXISTS, charset and collation defaults, and the absence of RENAME DATABASE.

Runs three parallel reviewers to find code reuse, quality, and efficiency issues in a diff, then applies safe fixes and reports risky ones.

Regex/parser/DSL design specialist for grammar authoring and ReDoS-safe regex. Not for REST APIs (Gateway) or DB schemas (Schema).

Type hints are checked by a separate tool (`mypy`, `pyright`), never by CPython

Documents MariaDB-specific ALTER TABLE syntax and behavior, including online DDL algorithms, lock modes, lock timeouts, idempotent subclauses, system versioning, and partition operations, for writing and reviewing schema migrations.

Async data-fetching patterns — Fetch vs Axios, service-layer organisation, AbortController cancellation, and integration with Redux Toolkit's createAsyncThunk for pending/fulfilled/rejected state transitions. Use when writing or reviewing HTTP call sites, standardising loading/error handling, or wiring request cancellation in effects.

Writes or updates a HANDOFF.md file in the project root to capture goal, progress, and next steps for a fresh agent to continue in-progress work.

Generates unit tests for code changed in the current branch by comparing against origin/main and following existing test conventions.

Reference for MariaDB string functions: extraction, length, search, concatenation, modification, case, PCRE2 regex, formatting, and encoding, with common pitfalls and version notes.

野原新之助（子供向）认知与表达框架（压缩蒸馏）：五岁黄腔净版化、想象力、家庭温情 触发：蜡笔小新 等。全年龄净版

MySQL 与 MariaDB 的 Schema、查询、索引、事务、复制及连接池模式——面向数据库管理员与后端开发者

查找 Dify 的 DSL 语法、API 端点、SDK 用法和 CLI 命令等参考信息。

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.

Plain-object Redux actions for the chota-react-saga template — three-phase async triples (REQUEST / SUCCESS / ERROR) per CRUD verb, single-phase actions for sync ops, UPPER_SNAKE type constants, and explicit hand-written action creators (no createAsyncThunk).