postgresql@16

{
  "aliases": [],
  "alternatives": [
    "MySQL",
    "MariaDB",
    "SQLite",
    "Oracle Database"
  ],
  "build_dependencies": [
    "gettext",
    "pkgconf"
  ],
  "categories": [
    "database",
    "language-runtime"
  ],
  "caveats": "This formula has created a default database cluster with:\n  initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@16\n",
  "conflicts_with": [],
  "dependencies": [
    "icu4c@78",
    "krb5",
    "lz4",
    "openssl@3",
    "readline",
    "zstd",
    "gettext"
  ],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Object-relational database system",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:40:46+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "postgresql@16",
  "github_default_branch": null,
  "github_last_commit_at": null,
  "github_readme_excerpt": null,
  "github_repo": null,
  "github_stars": null,
  "github_topics": [],
  "homepage": "https://www.postgresql.org/",
  "homepage_og_description": "The world\u0027s most advanced open source database.",
  "homepage_og_image": "https://www.postgresql.org/media/img/about/press/elephant.png",
  "homepage_title": "PostgreSQL: The world\u0027s most advanced open source database",
  "installs_30d": 16608,
  "installs_365d": 137985,
  "installs_90d": 51286,
  "keg_only": 1,
  "keg_only_reason": ":versioned_formula",
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "PostgreSQL",
  "llm_generated_at": "2026-06-20T23:43:47+00:00",
  "llm_model": "claude-haiku-4-5",
  "name": "postgresql@16",
  "oldnames": [],
  "one_liner": "PostgreSQL 16: object-relational SQL database server with JSON, full-text search, and advanced indexing.",
  "optional_dependencies": [],
  "rank_30d": 265,
  "rank_365d": 350,
  "rank_90d": 271,
  "raw_hash": "0300c7dcbe61bbb9",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/p/postgresql@16.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [
    "libxml2",
    "libxslt",
    "openldap",
    "perl"
  ],
  "version_head": null,
  "version_stable": "16.14",
  "versioned_formulae": [
    "postgresql@18",
    "postgresql@17",
    "postgresql@15",
    "postgresql@14",
    "postgresql@13",
    "postgresql@12"
  ],
  "why_use_this": "PostgreSQL 16 is a mature, production-grade SQL database widely used in web apps, data pipelines, and microservices. Install this keg-only version alongside other PostgreSQL versions for testing or migration workflows. It includes native JSON support, window functions, and superior query optimization compared to SQLite for complex schemas."
}