v1.4.5

Changelog

Bug Fixes

• 608d278: fix(security): bump Go to 1.25.10 to patch stdlib CVEs (@iamvirul)

Other

• 2fabf2e: Brew formula update for deepdiffdb version v1.4.4 (@goreleaserbot)
• f78590d: Scoop update for deepdiffdb version v1.4.4 (@goreleaserbot)
• a350143: chore(changelog): add v1.4.5 release notes (@iamvirul)
• 3601209: chore(deps): bump @babel/plugin-transform-modules-systemjs in /website (@dependabot[bot])
• d234927: chore(deps): bump fast-uri from 3.1.0 to 3.1.2 in /website (@dependabot[bot])

v1.4.4

Changelog

Bug Fixes

• 04bd60b: fix(nsis): prefix StrReplaceAll with un. for uninstall section (@iamvirul)

Other

• b0bbabf: Brew formula update for deepdiffdb version v1.4.3 (@goreleaserbot)
• 355950e: Scoop update for deepdiffdb version v1.4.3 (@goreleaserbot)
• ce0ff36: chore(changelog): add v1.4.4 release notes (@iamvirul)

v1.4.3

Changelog

Bug Fixes

• f3fcc21: fix(ci): remove non-existent MUI_PAGE_README macro from NSIS script (@iamvirul)
• df38b48: fix(macos-installer): dark mode CSS and Gatekeeper code signing (@iamvirul)

Other

• 7ed05d5: Brew formula update for deepdiffdb version v1.4.2 (@goreleaserbot)
• d77c3b9: Scoop update for deepdiffdb version v1.4.2 (@goreleaserbot)
• 350a3e0: Update .github/workflows/release.yml (@iamvirul)
• 74c3d8b: chore(changelog): add v1.4.3 release notes (@iamvirul)

v1.4.2

Changelog

Bug Fixes

• 04e0eec: fix(ci): remove inline heredoc from YAML to fix L184 syntax error (@iamvirul)
• 4268d17: fix: address CodeRabbit review comments (@iamvirul)

Other

• b65036a: Brew formula update for deepdiffdb version v1.4.1 (@goreleaserbot)
• 6154613: Scoop update for deepdiffdb version v1.4.1 (@goreleaserbot)
• 42b6af1: chore(changelog): add v1.4.2 release notes for macOS pkg installer and Windows NSIS fix (@iamvirul)
• 53840c9: ci(release): replace simple DMG with proper macOS .pkg installer wizard (@iamvirul)
• 7af2527: ci(release): upgrade Windows installer to MUI2 wizard UI (@iamvirul)

v1.4.1

Changelog

Other

• fea2a1c: Brew formula update for deepdiffdb version v1.4.0 (@goreleaserbot)
• 90391e9: Scoop update for deepdiffdb version v1.4.0 (@goreleaserbot)
• 7846906: chore(changelog): add v1.4.1 release notes for macOS DMG and Windows installer (@iamvirul)
• 698a7d9: ci(release): add Windows NSIS installer job (@iamvirul)
• 7103a32: ci(release): add macOS DMG build job for darwin amd64 and arm64 (@iamvirul)

v1.4.0

What's New

Schema object diffing (issues #99–#102)

DeepDiff DB now detects and migrates views, stored routines, triggers, and sequences alongside table-level changes.

Views

• Added/removed/modified views tracked with full definition comparison
• Materialised view support (PostgreSQL)
• Driver-aware migration: CREATE OR REPLACE VIEW (PostgreSQL), CREATE VIEW with drop guard (MySQL/SQLite)
• ignore.views config key; allow_drop_view safety control

Routines (stored procedures & functions)

• Diffs across definition, kind (FUNCTION/PROCEDURE), return type, language, and parameters
• Driver-aware migration: MySQL DELIMITER $$ blocks; PostgreSQL CREATE OR REPLACE FUNCTION
• ignore.routines config key; allow_drop_routine safety control

Triggers

• Per-table tracking with timing (BEFORE/AFTER/INSTEAD OF), event (INSERT/UPDATE/DELETE), and definition comparison
• PostgreSQL ON table syntax; MSSQL/Oracle variants
• ignore.triggers config key; allow_drop_trigger safety control

Sequences (PostgreSQL only)

• Loaded from pg_sequences (PG 10+) or information_schema.sequences (PG <10)
• Diffs start value, increment, min/max value, cache size, and cycle flag
• ignore.sequences config key; allow_drop_sequence safety control

HTML report extended

The Schema tab now shows Views, Routines, Triggers, and Sequences sections alongside table changes. The tab badge counts all object types combined.

A live sample report is available at the documentation site.

Bug Fixes

• MySQL views introspected as tables — added table_type = 'BASE TABLE' filter to column query
• MySQL view definition false-positive diff — strip embedded `dbname`. prefix before comparison
• HTML report version showing v0.5 — now injected from ldflags version variable
• add template function arity mismatch — changed to variadic to support 2+ arguments
• PostgreSQL <10 sequence scan panic — scan character_data columns as strings, parse with strconv.ParseInt
• loadSequences error for MSSQL/Oracle — non-PostgreSQL drivers now return nil

Test Coverage

Package	Before	After
internal/schema	64%	70%
internal/report/html	68%	90%

Full Changelog

https://github.com/iamvirul/deepdiff-db/blob/main/CHANGELOG.md#140---2026-05-03

v1.3.0

Changelog

New Features

• 5c76cb1: feat(cicd): add Jenkins declarative pipeline example (@iamvirul)
• ba5123b: feat(cicd): add official pre-commit framework hooks definition (@iamvirul)
• 315cfcd: feat(cli): add --quiet and --output-dir flags to schema-diff command (@iamvirul)

Bug Fixes

• 53de422: fix(cicd): fix GitHub Actions example to use actual JSON output files (@iamvirul)
• c945c71: fix(cicd): fix GitLab CI example to use actual schema_diff.json output (@iamvirul)
• a579ca6: fix(security): bump Go 1.25.8 → 1.25.9 to resolve GO-2026-4947, GO-2026-4946, GO-2026-4870, GO-2026-4865 (@iamvirul)

Other

• 558f198: Add CodeQL analysis workflow configuration (@iamvirul)
• 781a690: Brew formula update for deepdiffdb version v1.2.0 (@goreleaserbot)
• 0cc92a9: Potential fix for code scanning alert no. 2: Workflow does not contain permissions (@iamvirul)
• 36d7d95: Potential fix for code scanning alert no. 3: Workflow does not contain permissions (@iamvirul)
• dcc85c9: Potential fix for code scanning alert no. 6: Workflow does not contain permissions (@iamvirul)
• ed88ccb: Potential fix for code scanning alert no. 8: Workflow does not contain permissions (@iamvirul)
• 22ea2c1: Remove PR title validation from checks (@iamvirul)
• 8ed00be: Remove PR title validation job from workflow (@iamvirul)
• 759f7a5: Remove validate-pr-title from required checks (@iamvirul)
• 6771844: Scoop update for deepdiffdb version v1.2.0 (@goreleaserbot)
• 4199d1b: chore(deps): bump brace-expansion from 1.1.12 to 1.1.14 in /website (@dependabot[bot])
• 8e218ec: chore(deps): bump filippo.io/edwards25519 from 1.1.0 to 1.1.1 (@dependabot[bot])
• ad76e09: chore(deps): bump follow-redirects from 1.15.11 to 1.16.0 in /website (@dependabot[bot])
• 2d829d4: chore(deps): bump github.com/jackc/pgx/v5 from 5.7.6 to 5.9.0 (@dependabot[bot])
• c92fc4e: chore(deps): bump google.golang.org/grpc from 1.75.1 to 1.79.3 (@dependabot[bot])
• 524fff7: chore(deps): bump lodash from 4.17.23 to 4.18.1 in /website (@dependabot[bot])
• 48c9db8: chore(deps): bump node-forge from 1.3.3 to 1.4.0 in /website (@dependabot[bot])
• ca342ef: chore(deps): bump path-to-regexp from 0.1.12 to 0.1.13 in /website (@dependabot[bot])
• 3c7fa3e: chore(deps): bump picomatch from 2.3.1 to 2.3.2 in /website (@dependabot[bot])
• 109c75a: chore(release): bump version to v1.3.0 — update website, navbar, docker docs, README badge (@iamvirul)
• f28c915: chore(release): update v1.3.0 changelog date to 2026-04-23 (@iamvirul)

v1.2.0

Changelog

New Features

• a99cb88: feat(version): authenticate author via GitHub OAuth device flow (@iamvirul)

Bug Fixes

• d8378fd: fix(security): suppress gosec G101 false positive on GitHub OAuth token URL constant (@iamvirul)
• a6218d6: fix: address all CodeRabbit review comments on PR #78 (@iamvirul)

Other

• ffb2b28: Brew formula update for deepdiffdb version v1.1.0 (@goreleaserbot)
• b857191: Scoop update for deepdiffdb version v1.1.0 (@goreleaserbot)
• eb18d70: ci(docs): switch to official actions/deploy-pages to fix GitHub Pages 404 (@iamvirul)
• 17eb27f: docs(blog): add Kaviru as co-author on origin story post (@iamvirul)
• 0a045b8: docs(blog): link Kaviru's name to his GitHub profile in post body (@iamvirul)
• 121d416: docs(cicd): add version commit CI example and --skip-auth guidance (@iamvirul)
• d25e1f7: docs(website): add blog with origin story post and enable blog section (@iamvirul)
• c0d3a64: docs(website): add git-like versioning feature guide and wire into sidebar (@iamvirul)
• 7e4feff: docs(website): update hero badge version label to v1.1 (@iamvirul)
• 1d8e622: docs(website): update navbar version label to v1.1 (@iamvirul)
• 5af0bf5: docs(website): update version refs to v1.1.0 and add git-like versioning to feature highlights (@iamvirul)

v1.1.0

Changelog

New Features

• ce1913e: feat(sample): add sample 17 git-like versioning with MySQL demo (@iamvirul)
• fcba0ce: feat(version): add branch, checkout, and tree subcommands (@iamvirul)
• c2342ec: feat(version): add internal/version package with zlib object store (@iamvirul)

Bug Fixes

• bfe8596: fix(gitignore): anchor binary pattern to root, add .deepdiffdb/ ignore (@iamvirul)
• 73693f3: fix(security): resolve gosec G703 path traversal and G306 file permission issues (@iamvirul)
• d444f2e: fix(version): use file-existence check for duplicate branch detection in CreateBranch (@iamvirul)

Other

• 9845bff: Brew formula update for deepdiffdb version v1.0.0 (@goreleaserbot)
• 855933d: Scoop update for deepdiffdb version v1.0.0 (@goreleaserbot)
• fcd1fa6: Update action.yml (@iamvirul)
• 1086c5a: chore(release): prepare v1.1.0 (@iamvirul)
• 00224f3: docs(sample): fix storage layout diagram to match fanout + symbolic ref implementation (@iamvirul)
• e6698df: docs(website): add version command reference and sample 17 to docs site (@iamvirul)
• b621229: test(version): add unit tests for store, branch, and tree (@iamvirul)

v1.0.0

Changelog

New Features

• 22de156: feat(action): add GitHub Marketplace action with composite workflow (@iamvirul)
• b57b4a6: feat(quality): fix Go Report Card to A and raise unit coverage to 80%+ (@iamvirul)
• f162379: feat(release): add deb/rpm/apk packages, Scoop manifest, and updated install docs (@iamvirul)
• 3f9e085: feat(v1.0): add Apache 2.0 license, update README badges, fix brew tap to same repo (@iamvirul)
• edd212c: feat(v1.0): production readiness — Docker, security hardening, benchmarks, CI/CD (@iamvirul)

Bug Fixes

• 9288130: fix(action): build from source in test; skip install if binary already in PATH (@iamvirul)
• f23b65a: fix(action-test): continue-on-error for diff step — exit 1 on drift is expected (@iamvirul)
• 7670685: fix(action-test): replace heredoc with echo block to fix YAML parse error (@iamvirul)
• b0d28a6: fix(action-test): use identical schemas so diff runs full pipeline (@iamvirul)
• 70afc69: fix(ci): remove duplicate test functions that clash when -tags integration is set (@iamvirul)
• 4a820d8: fix(diff): continue data diff and write all outputs when schema drift detected (@iamvirul)
• b44436c: fix(lint): remove redundant nil check before len() in primary_keys_test (@iamvirul)
• 2d31c95: fix(release): remove GPG signing block to unblock GoReleaser (@iamvirul)
• 13e38e9: fix(release): use Dockerfile.goreleaser with pre-built binary for GoReleaser docker builds (@iamvirul)
• 5ad1b2e: fix(review): address all CodeRabbit comments on PR #69 (@iamvirul)
• 450680f: fix(security): suppress gosec false positives in seed data file (@iamvirul)

Other

• acd429e: Update internal/content/pack.go (@iamvirul)
• 0a562d8: chore(release): Prepare v1.0.0 — production-ready release (@iamvirul)
• 0ba4fd6: chore(security): add SECURITY.md policy and CODEOWNERS (@iamvirul)
• c964832: chore(security): add SECURITY.md policy and CODEOWNERS (@iamvirul)
• 9a76e46: chore(security): rename files (@iamvirul)
• 3e0be68: chore(security): update .github/SECURITY.md with full policy (@iamvirul)
• 2b23c33: ci(action-test): add workflow_dispatch trigger for manual runs (@iamvirul)
• a6a8fb8: docs(v1.0): update version references, CHANGELOG, ROADMAP, and installation guide (@iamvirul)
• 2ec680f: docs(website): add Docusaurus v3 documentation site with GitHub Pages deployment (@iamvirul)