Git-Database Branch Integration with DDL Versioning and Webhook Automation
We present a deep integration between Git version control and database branching, comprising six sub-systems: (1) LinkManager for bidirectional Git-branch to DB-branch mapping, (2) CommitTracker for recording database state at Git commits, (3) DdlVersioning for automatic WAL-based DDL capture with schema snapshots, (4) DiffEngine for schema and data comparison between branches at arbitrary LSN/SCN points, (5) HookManager for Git hooks (post-checkout, pre-commit, post-merge) that auto-switch database branches, and (6) WebhookServer for GitHub/GitLab PR lifecycle automation. The DiffEngine supports three levels: schema-only (<100ms), schema plus sampled data (1-5s), and full data diff (scales with data size). Diff targets include branch current state, branch-at-LSN, and branch-at-SCN, enabling cross-branch time-travel comparisons. No existing database links Git branches to database branches with automatic DDL capture from WAL monitoring and PR webhook automation.
Authors
- Daniel Moya Vaca
Publication Details
- Journal
- Zenodo (CERN European Organization for Nuclear Research)
- Published
- 2026-03-27
- DOI
- https://doi.org/10.5281/zenodo.19244217
- Primary Topic
- Advanced Database Systems and Queries
- Type
- article
- Field-Weighted Citation Impact
- 0.00