GET /api/v1/ports/?format=api&ordering=-updated_at&page=676
HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 51892,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-updated_at&page=677",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-updated_at&page=675",
    "results": [
        {
            "name": "postgresql13-server",
            "portdir": "databases/postgresql13-server",
            "version": "13.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql13 as server",
            "long_description": "run postgresql13 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql13"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql13-doc",
            "portdir": "databases/postgresql13-doc",
            "version": "13.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 13",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql13",
            "portdir": "databases/postgresql13",
            "version": "13.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 146
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison",
                        "pkgconfig"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl3",
                        "libxslt",
                        "icu",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-13"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg13-postgis-doc",
                        "pg13-postgis3-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "pg13-postgis",
                        "pg13-pgrouting",
                        "pg13-timescaledb",
                        "pg13-pgpointcloud"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql13-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql12-server",
            "portdir": "databases/postgresql12-server",
            "version": "12.22",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql12 as server",
            "long_description": "run postgresql12 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql12"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql12-doc",
            "portdir": "databases/postgresql12-doc",
            "version": "12.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 12",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "docbook-xml-4.5",
                        "docbook-xsl-nons",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql12",
            "portdir": "databases/postgresql12",
            "version": "12.22",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison",
                        "pkgconfig"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl3",
                        "libxslt",
                        "icu",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-12"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "pg12-postgis3-doc",
                        "pg12-postgis-doc"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgis2",
                        "pg12-postgis",
                        "pg12-pgrouting",
                        "pg12-pgpointcloud",
                        "p5.26-dbd-pg",
                        "timescaledb1",
                        "pg12-timescaledb"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql12-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql11-server",
            "portdir": "databases/postgresql11-server",
            "version": "11.22",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql11 as server",
            "long_description": "run postgresql11 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql11"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql11-doc",
            "portdir": "databases/postgresql11-doc",
            "version": "11.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 11",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql11",
            "portdir": "databases/postgresql11",
            "version": "11.22",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang20",
                "clang21",
                "clang22",
                "clangdevel",
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "llvm",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison",
                        "pkgconfig"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "icu",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-11"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql11-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql10-server",
            "portdir": "databases/postgresql10-server",
            "version": "10.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql10 as server",
            "long_description": "run postgresql10 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql10"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "amber"
                    ]
                }
            ]
        },
        {
            "name": "postgresql10-doc",
            "portdir": "databases/postgresql10-doc",
            "version": "10.23",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 10",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This is the documentation.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg17-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg17-postgis",
            "long_description": "This port has been replaced by pg17-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg16-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg16-postgis",
            "long_description": "This port has been replaced by pg16-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "osm2pgsql-lua"
                    ]
                }
            ]
        },
        {
            "name": "pg15-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg15-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg15-postgis",
            "long_description": "This port has been replaced by pg15-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg14-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg14-postgis",
            "long_description": "This port has been replaced by pg14-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg13-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg13-postgis",
            "long_description": "This port has been replaced by pg13-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg12-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg12-postgis",
            "long_description": "This port has been replaced by pg12-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql10",
            "portdir": "databases/postgresql10",
            "version": "10.23",
            "license": "Permissive",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "The most advanced open-source database available anywhere.",
            "long_description": "PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 44
                }
            ],
            "variants": [
                "python",
                "python27",
                "python3",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kerberos5",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-10"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql10-server"
                    ]
                }
            ]
        },
        {
            "name": "postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.macports.org",
            "description": "Obsolete port",
            "long_description": "This port is obsolete.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 17",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18",
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql17",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "mod_tile",
                        "osm2pgrouting",
                        "osm2pgsql",
                        "pg17-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg16-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 16",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql16",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql16",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg16-pgrouting",
                        "tinyows"
                    ]
                }
            ]
        },
        {
            "name": "pg15-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 15",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql15",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql15",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg15-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg14-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 14",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "postgresql14",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql14",
                        "protobuf-c",
                        "proj9",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg14-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg13-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 13",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql13",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql13",
                        "proj9",
                        "protobuf-c",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg13-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg12-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 12",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql12",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql12",
                        "proj9",
                        "protobuf-c",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg12-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "postgis2",
            "portdir": "databases/postgis2",
            "version": "2.5.11",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 1,
            "replaced_by": null,
            "homepage": "http://postgis.refractions.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS 2 adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. The 2.0 release also provides raster handling and basic 3D geometry capacities (TIN and polyhedra).",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "variants": [
                "postgresql10",
                "postgresql11",
                "postgresql12",
                "raster",
                "topology",
                "sfcgal",
                "gui",
                "comments",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libiconv",
                        "postgresql12",
                        "libxml2",
                        "gdal",
                        "proj7",
                        "geos",
                        "json-c"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgis",
            "portdir": "databases/postgis",
            "version": "3.6.2",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql92",
                        "proj4",
                        "geos",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgtcl",
            "portdir": "databases/pgtcl",
            "version": "3.1.1",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://flightaware.github.io/Pgtcl/",
            "description": "Tcl PostgreSQL interface",
            "long_description": "Tcl client interface to PostgreSQL",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "tcl",
                        "postgresql16",
                        "sqlite3"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgroll",
            "portdir": "databases/pgroll",
            "version": "0.14.3",
            "license": "Apache-2",
            "platforms": "darwin freebsd linux",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://xata.io/blog/pgroll-schema-migrations-postgres",
            "description": "Postgres zero-downtime migrations made easy",
            "long_description": "pgroll is an open source command-line tool that offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously. It takes care of the complex migration operations to ensure that client applications continue working while the database schema is being updated. This includes ensuring changes are applied without locking the database, and that both old and new schema versions work simultaneously (even when breaking changes are being made!). This removes risks related to schema migrations, and greatly simplifies client application rollout, also allowing for instant rollbacks.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1053
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "go",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgsqlclient",
            "portdir": "databases/pgsqlclient",
            "version": "1.0-Beta6",
            "license": "LGPL-2.1+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://pgsqlclient.sourceforge.net/",
            "description": "ADO.NET adapter for PostgreSQL",
            "long_description": "ADO.NET adapter for PostgreSQL",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "mono"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgpool-II",
            "portdir": "databases/pgpool-II",
            "version": "4.5.2",
            "license": "MIT",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.pgpool.net/",
            "description": "PostgreSQL connection pool server",
            "long_description": "pgpool is a connection server program for PostgreSQL. It runs between PostgreSQL's client(frontend) and server(backend). Any PostgreSQL clients can connect to pgpool as if it's a real PostgreSQL server. It supports connection pooling, failover and replication.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql16",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgpool",
            "portdir": "databases/pgpool",
            "version": "3.4.1",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgpool.net/",
            "description": "PostgreSQL connection pool server",
            "long_description": "pgpool is a connection server program for PostgreSQL. It runs between PostgreSQL's client(frontend) and server(backend). Any PostgreSQL clients can connect to pgpool as if it's a real PostgreSQL server. It supports connection pooling, failover and replication.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql17",
                        "zlib"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pdal-pgpointcloud"
                    ]
                }
            ]
        },
        {
            "name": "pg16-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql16",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql15",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql14",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql13",
                        "libxml2",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql12",
                        "libxml2",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgmodeler",
            "portdir": "databases/pgmodeler",
            "version": "1.2.3",
            "license": "GPL-3",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/pgmodeler/pgmodeler",
            "description": "PostgreSQL Database Modeler",
            "long_description": "pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "l2dy",
                    "github": "l2dy",
                    "ports_count": 97
                },
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1053
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "qt6-qtbase",
                        "qt6-qtsvg",
                        "postgresql15"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 107
                }
            ],
            "variants": [
                "tests"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgcli",
            "portdir": "databases/pgcli",
            "version": "4.3.0",
            "license": "BSD",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgcli.com",
            "description": "Postgres CLI with autocompletion and syntax highlighting",
            "long_description": "Postgres CLI with autocompletion and syntax highlighting",
            "active": true,
            "categories": [
                "databases",
                "python"
            ],
            "maintainers": [],
            "variants": [
                "python310",
                "python311",
                "python312",
                "python313"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "py313-build",
                        "py313-installer",
                        "py313-setuptools",
                        "py313-wheel"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "py313-keyring",
                        "py313-configobj",
                        "py313-setproctitle",
                        "python313",
                        "py313-cli-helpers",
                        "py313-pgspecial",
                        "py313-psycopg",
                        "py313-tzlocal",
                        "py313-prompt_toolkit",
                        "py313-pygments",
                        "py313-click",
                        "py313-sqlparse"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgintcl",
            "portdir": "databases/pgintcl",
            "version": "3.4.0",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://pgintcl.sourceforge.net/",
            "description": "Pure Tcl PostgreSQL interface",
            "long_description": "This is a Tcl interface to PostgreSQL, which is itself written entirely in Tcl, and does not rely on libpq. It is highly but not entirely compatible with other Tcl interfaces, although it is slower.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "tcl"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgbadger",
            "portdir": "databases/pgbadger",
            "version": "13.2",
            "license": "BSD",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgbadger.darold.net/",
            "description": "PostgreSQL log analyzer with fully detailed reports and graphs.",
            "long_description": "pgBadger is a PostgreSQL log analyzer built for speed with fully reports from your PostgreSQL log file. It's a single and small Perl script that outperforms any other PostgreSQL log analyzer.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "perl5_28",
                "perl5_30",
                "perl5_32",
                "perl5_34"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "perl5.34",
                        "p5.34-json-xs",
                        "p5.34-text-csv_xs"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgbouncer",
            "portdir": "databases/pgbouncer",
            "version": "1.25.1",
            "license": "ISC",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.pgbouncer.org",
            "description": "Lightweight connection pooler for PostgreSQL",
            "long_description": "pgbouncer is a PostgreSQL connection pooler. Any target application can be connected to pgbouncer as if it were a PostgreSQL server, and pgbouncer will manage to connect to the server, or to reuse one of its existing connections.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1053
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "gmake",
                        "pkgconfig",
                        "pandoc",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "openssl",
                        "c-ares",
                        "libevent"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}