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

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
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Git-Database Branch Integration with DDL Versioning and Webhook Automation

Daniel Moya Vaca
Zenodo (CERN European Organization for Nuclear Research)
Advanced Database Systems and Queries
article

Git-Database Branch Integration with DDL Versioning and Webhook Automation

Daniel Moya Vaca
article en

Abstract

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.

Zenodo (CERN European Organization for Nuclear Research)
Openalex Percentile: Top 5%
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.