← all publishers

ysys143

@ysys143 source repo

2 published skills

  1. Pg Extension Lab · ysys143 bundle
    Develop, test, benchmark, and operate PostgreSQL extensions with reusable harnesses and reference protocols. Use for C/PGXS or Rust/pgrx extension work, planner hooks, CustomScan or index AM design, pg_regress/pg_isolation_regress TDD, filtered ANN/vector benchmarks, matched-recall and pages-per-query analysis, bounded parameter-space exploration, Pareto curves, hypothesis/evidence/report management, accelerator-vs-CPU crossover, resource Pareto tuning, Shape B microservice extensions, Shape C sidecar daemons, service-boundary contracts, async outbox workers, and SECURITY hardening. Balances docs, code evidence, and execution results. Includes copy-ready test, benchmark, contract, and ops assets. Not for projects without a PostgreSQL extension layer.
    0
    installs
  2. Adversarial Review · ysys143
    Adversarial code review for PostgreSQL extension work — finds the bugs a self-review misses by computing the DIFF between the model the author STATED and the model that Postgres, the sibling code, and the downstream consumers actually ENFORCE. Use when reviewing a PR, a diff, or your own change before pushing; when the user says "적대적 리뷰", "리뷰해줘", "이 PR 검토", "코드 리뷰", "adversarial review", "review this", "self-review before push"; and for extension-specific review requests — extension review, C/PGXS or pgrx diff review, pg_regress .out diff review, isolation spec review, planner hook review, CustomScan review, index AM review, extension upgrade script review, GUC or shared_preload_libraries review, benchmark claim review. A well-documented, self-critical PR is the highest-risk case: its disclosed risks are the author's threat model, and the surviving bugs live outside it. NOT for quick lint/style passes, formatting, or generating new code.
    0
    installs