TECHNICAL GUIDES

Technical guides

These guides use local and synthetic examples to explain Schema Migrator and Atheros Search. Each includes source links and the limits of its checks.

POSTGRESQL / FILE REVIEW

PostgreSQL migration dry runs

Run a two-file PostgreSQL migration example through discovery, validation, and an offline dry-run preview. Learn what the checks establish and what needs a target.

Read guide

POSTGRESQL / CATALOG REVIEW

Investigating PostgreSQL schema drift

Compare expected PostgreSQL definitions, live catalog objects, and migration control state in a worked schema drift example. Separate detection from remediation.

Read guide

POSTGRESQL / SOURCE INTEGRITY

Migration checksum mismatches

Reproduce a SQL-file checksum mismatch locally, interpret added, removed, and changed snapshot paths, and distinguish file integrity from PostgreSQL schema drift.

Read guide

SEARCH / RETRIEVAL REVIEW

Hybrid search over network observations

Compare term, vector, and hybrid retrieval on the same synthetic observations. Work through weighted reciprocal-rank fusion and interpret explain data and sparse fallback.

Read guide

CONTACT

Questions about a project?

Email me with the project, environment, and constraints you want to discuss. We can arrange a walkthrough or technical call by email.

Email Rafael

Opens your email app, or email rafael@rclabs.uk. Start by email. We can arrange a technical call together.