macOS
Homebrewvérifié · 100%
brew install apgdifflocal Homebrew formula metadata
MacPortsvérifié · 94%
sudo port install apgdiffMacPorts ports tree · databases/apgdiff/Portfile · Source: api.github.com
brew
Installer apgdiff avec Homebrew, apt, MacPorts, Nix
Consultez les chemins d'installation, exécutables, métadonnées et notes de sécurité de apgdiff pour les workflows d'agents IA.
installation
Commandes d'installation supplémentaires
Linux
Debian aptvérifié · 92%
sudo apt install apgdiffDebian stable package indexes · apgdiff · Source: deb.debian.org
Nixvérifié · 92%
nix profile install nixpkgs#apgdiffnixpkgs package indexes · pkgs/by-name/ap/apgdiff/package.nix · Source: api.github.com
aperçu
Résumé du paquet
Another PostgreSQL diff tool
Liens du projet
Commandes et alias
- apgdiff
historique
Historique du projet et usages
Another PostgreSQL Diff Tool, usually packaged as apgdiff, is a Java command-line utility for comparing PostgreSQL schema dumps and generating DDL needed to move an old schema toward a new one. Its niche is intentionally narrow: it is for schema-diffing PostgreSQL dump files, not for live database migration orchestration.
Historique du projet
The official site presents apgdiff as a free PostgreSQL database schema diff tool and notes that it compares two database dump files to produce SQL statements describing schema changes. The project predates its GitHub repository: the web site lists 2010-era 2.x releases, and a 2012 news entry says the sources and issue tracker moved to GitHub to make participation easier.
The GitHub README describes the repository as mainly unmaintained, while still accepting useful bug-fix pull requests. The changelog shows the package's long tail of PostgreSQL compatibility work: version 2.0 rewrote the SQL parser, version 2.4 added schema-creation and Slony-trigger options, version 2.5 added materialized views, extensions, foreign tables, grants, and ownership support, version 2.6 added PostgreSQL 10 support, and version 2.7.0 added early support for PostgreSQL 12-era syntax such as partitioning and identity columns.
Historique d'adoption
The official home page states that apgdiff was already being used by many developers worldwide. The batch input shows it has also crossed into several package-manager ecosystems, including Homebrew, Debian, Ubuntu, MacPorts, and Nix, which is typical for small database utilities that remain useful in scripts long after active feature development slows.
Modes d'utilisation
Typical use is to dump two PostgreSQL schemas, run apgdiff against the old and new dumps, and review or apply the generated DDL. The official site emphasizes command-line use from batches and web applications, and the project README points users to GitHub issues for bugs.
Package users care about PostgreSQL version support because apgdiff parses SQL dump syntax. Its changelog is therefore practically part of the compatibility contract: support for materialized views, unlogged tables, extensions, foreign tables, sequences, triggers, rules, grants, views, and newer CREATE syntax determines whether a given schema dump can be diffed safely.
Pourquoi les passionnés de paquets s'y intéressent
apgdiff is the kind of small, stable package that package managers preserve because it solves one specific operational problem without needing a server. It is especially interesting to PostgreSQL users who want schema comparison in CI or release scripts and are willing to inspect generated SQL rather than adopt a larger migration framework.
Chronologie
- 2010: Version 2.0 rewrote the SQL parser and expanded supported PostgreSQL DDL.
- 2012: The project moved its sources and issue tracker to GitHub.
- 2012: Version 2.4 shipped with trigger, schema, and parser fixes.
- 2016: GitHub releases recorded 2.5.0 prereleases.
- 2018-2020: Changelog entries added PostgreSQL 10, Java 11 development, PostgreSQL 12-related syntax, partitioning, and identity-column support.
Related projects
- PostgreSQL schema dump tooling, database migration frameworks, and schema comparison utilities are adjacent, but apgdiff remains focused on diffing two PostgreSQL dump files and emitting DDL.
Sources
- https://api.github.com/repos/fordfrog/apgdiff
- https://github.com/fordfrog/apgdiff#readme
- https://www.apgdiff.com/
- input source_facts.package-manager
posture de sécurité
Niveau de risque : blue
broad file, network, media, or database tool signal.
Classificateur de risque
risque blue · confiance moyen · tool
Pourquoi
- broad file, network, media, or database tool signal
Signaux
- text:sql
Comportement d'installation
- Aucun hook post-install Homebrew n’est enregistré dans les métadonnées de formule.
- Les métadonnées de bottle Homebrew sont disponibles pour 1 plateformes.
- S’installe avec 1 dépendances d’exécution.
Revue recommandée
Avant une utilisation sans surveillance par un agent, vérifiez si l'outil lit des identifiants en clair, écrit un état distant, publie des artefacts ou lance des plugins.
exécutables
Exécutables installés
| Commande | Type | Exposition | Note |
|---|---|---|---|
apgdiff | cli | exécutable global |
fraîcheur
Version et fraîcheur
Ces signaux séparent l'âge de génération de la page, l'activité du gestionnaire de paquets et la comparaison avec les versions amont. Un retard de version n'est signalé que lorsqu'une URL de preuve et des versions comparables sont présentes.
page générée2026-07-08
version du gestionnaire2.7.0
gestionnaire mis à jour
données localesOK
amontnot checked
dernière version détectéenon détecté
https://github.com/fordfrog/apgdiff
- infoNo package-manager update timestamp was available.confiance faible
- infoNo cached GitHub release or tag data was available.https://github.com/fordfrog/apgdiffconfiance none
métadonnées d'installation
Métadonnées du paquet
| Clé du paquet | brew:apgdiff |
|---|---|
| Version | 2.7.0 |
| Gestionnaire de paquets | Homebrew |
| Page du gestionnaire de paquets | https://formulae.brew.sh/formula/apgdiff |
| Page d'accueil | https://www.apgdiff.com/ |
| Dépôt | https://github.com/fordfrog/apgdiff |
| Docs amont | https://github.com/fordfrog/apgdiff#readme |
| Licence | MIT |
| Archive source | https://github.com/fordfrog/apgdiff/archive/refs/tags/release_2.7.0.tar.gz |
| Dépendances | openjdk |
| Bouteille | disponible (sur all) |
| post-install Homebrew | non défini |
| Service | aucun déclaré |
faits du registre
Détails de la base source
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | apgdiff |
| Version Scheme | 0 |
| Revision | 0 |
| Head Version | HEAD |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
correspondances dans les bases sources
Autres enregistrements de gestionnaires de paquets
Les correspondances proviennent d’index externes de gestionnaires de paquets et restent séparées des liens de paquets Automic Vault locaux.
Debian apt95%
apgdiff 2.7.0-1
Another PostgreSQL Diff Tool
sudo apt install apgdiff- Section: database
- Architecture: all
- 2 Dépendances
- normalized package name match
- Correspondance par : Apgdiff
Nix95%
apgdiff
nix profile install nixpkgs#apgdiff- normalized package name match
- Correspondance par : Apgdiff
Ubuntu apt95%
apgdiff 2.7.0-1
Another PostgreSQL Diff Tool
sudo apt install apgdiff- Section: universe/misc
- Architecture: all
- 2 Dépendances
- normalized package name match
- Correspondance par : Apgdiff
MacPorts95%
apgdiff
sudo port install apgdiff- normalized package name match
- Correspondance par : Apgdiff
piste source
Généré depuis les données du dépôt
Cette page est servie par av-web depuis l'artéfact SQLite privé des paquets généré par scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Sources utilisées
- Geiger risk classifier
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment