HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept
{
"count": 49374,
"next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=created_at&page=28",
"previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=created_at&page=26",
"results": [
{
"name": "mysql57-server",
"portdir": "databases/mysql57",
"version": "5.7.44",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.mysql.com/",
"description": "Run mysql57 as server",
"long_description": "Run mysql57 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"mysql57"
]
}
],
"depends_on": []
},
{
"name": "mysql8",
"portdir": "databases/mysql8",
"version": "8.4.6",
"license": "(GPL-2 or OpenSSLException)",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://dev.mysql.com",
"description": "Multithreaded SQL database server",
"long_description": "MySQL is an open-source, multi-threaded SQL database.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "herby.gillot",
"github": "herbygillot",
"ports_count": 1008
}
],
"variants": [
"debug",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-20",
"bison",
"cmake",
"pkgconfig"
]
},
{
"type": "lib",
"ports": [
"libedit",
"libevent",
"protobuf3-cpp",
"curl",
"zlib",
"openssl3",
"cyrus-sasl2",
"libfido2",
"zstd",
"openldap",
"icu"
]
},
{
"type": "run",
"ports": [
"mysql_select"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"p5.28-dbd-mysql",
"p5.30-dbd-mysql",
"p5.32-dbd-mysql",
"p5.34-dbd-mysql"
]
},
{
"type": "run",
"ports": [
"postfixadmin",
"mysql8-server"
]
}
]
},
{
"name": "mysql8-server",
"portdir": "databases/mysql8",
"version": "8.4.6",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://dev.mysql.com",
"description": "Run mysql8 as server",
"long_description": "Run mysql8 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "herby.gillot",
"github": "herbygillot",
"ports_count": 1008
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"mysql8"
]
}
],
"depends_on": []
},
{
"name": "mysql_select",
"portdir": "databases/mysql_select",
"version": "0.1.2",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "",
"description": "common files for selecting default MySQL version",
"long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of MySQL.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-14"
]
}
],
"depends_on": [
{
"type": "run",
"ports": [
"mariadb-10.10",
"mariadb-10.11",
"mariadb-10.3",
"mariadb-10.4",
"mariadb-10.5",
"mariadb-10.6",
"mariadb-10.7",
"mariadb-10.8",
"mariadb-10.9",
"mariadb",
"mysql57",
"percona",
"mysql51",
"mysql56",
"mysql55",
"mariadb-11.4",
"mysql8"
]
}
]
},
{
"name": "mysqltcl",
"portdir": "databases/mysqltcl",
"version": "3.02",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://www.xdobry.de/mysqltcl/",
"description": "Simple API for Mysql-Database and Tcl scripting language.",
"long_description": "MySQLTcl is a collection of Tcl commands and a Tcl global array that provide access to one or more mysql database servers.",
"active": false,
"categories": [
"devel",
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"mysql5",
"tcl",
"tk"
]
}
],
"depends_on": []
},
{
"name": "mysqlxx",
"portdir": "databases/mysqlxx",
"version": "3.0.8",
"license": "unknown",
"platforms": "darwin freebsd",
"epoch": 0,
"replaced_by": null,
"homepage": "http://tangentsoft.net/mysql++/",
"description": "C++ wrapper for MySQL's C API",
"long_description": "MySQL++ is a C++ wrapper for MySQL's C API. It is built around STL principles, to make dealing with the database as easy as dealing with an STL container.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"mysql5",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"zlib",
"mysql5",
"gettext"
]
}
],
"depends_on": []
},
{
"name": "ocaml-mysql",
"portdir": "databases/ocaml-mysql",
"version": "1.0.4",
"license": "LGPL-2.1",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://raevnos.pennmush.org/code/ocaml-mysql/",
"description": "Mysql5 bindings for OCaml",
"long_description": "Mysql5 bindings for OCaml",
"active": true,
"categories": [
"devel",
"databases",
"ocaml"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0",
"ocaml-findlib"
]
},
{
"type": "lib",
"ports": [
"mysql5",
"ocaml"
]
}
],
"depends_on": []
},
{
"name": "ocilib",
"portdir": "databases/ocilib",
"version": "3.12.1",
"license": "LGPL",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://orclib.sourceforge.net/",
"description": "Oracle OCI C wrapper",
"long_description": "OCILIB is an open source and cross platform Oracle Driver that delivers efficient access to Oracle databases.",
"active": true,
"categories": [
"devel",
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"oracle-instantclient"
]
}
],
"depends_on": []
},
{
"name": "octosql",
"portdir": "databases/octosql",
"version": "0.13.0",
"license": "MIT",
"platforms": "darwin freebsd linux",
"epoch": 0,
"replaced_by": null,
"homepage": "https://github.com/cube2222/octosql",
"description": "OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.",
"long_description": "OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. OctoSQL is a SQL query engine which allows you to write standard SQL queries on data stored in multiple SQL databases, NoSQL databases, streaming sources and files in various formats trying to push down as much of the work as possible to the source databases, not transferring unnecessary data. OctoSQL does that by creating an internal representation of your query and later translating parts of it into the query languages or APIs of the source databases. Whenever a datasource doesn't support a given operation, OctoSQL will execute it in memory, so you don't have to worry about the specifics of the underlying datasources. OctoSQL supports JSON, CSV, Excel, Parquet, PostgreSQL, MySQL, Redis & Kafka.",
"active": true,
"categories": [
"databases",
"textproc"
],
"maintainers": [
{
"name": "herby.gillot",
"github": "herbygillot",
"ports_count": 1008
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"go",
"clang-17"
]
}
],
"depends_on": []
},
{
"name": "openldap",
"portdir": "databases/openldap",
"version": "2.6.10",
"license": "openldap",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.openldap.org/",
"description": "OpenLDAP Software",
"long_description": "OpenLDAP Software is an open source implementation of the Lightweight Directory Access Protocol.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "mascguy",
"github": "mascguy",
"ports_count": 347
}
],
"variants": [
"aci",
"overlays",
"backends",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17"
]
},
{
"type": "lib",
"ports": [
"openssl",
"perl5",
"libfetch",
"tcp_wrappers",
"cyrus-sasl2",
"db48"
]
},
{
"type": "test",
"ports": [
"coreutils"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"netatalk",
"echoping",
"gq",
"pwlib",
"xymon-client",
"xymon-server",
"evolution-data-server-gtk4",
"seahorse",
"php84-ldap",
"php83-ldap",
"samba4",
"php82-ldap",
"php81-ldap",
"php80-ldap",
"php74-ldap",
"php73-ldap",
"py37-ldap",
"php72-ldap",
"php71-ldap",
"php70-ldap",
"php56-ldap",
"php55-ldap",
"php54-ldap",
"php53-ldap",
"php52-ldap",
"qore-openldap-module",
"rb-ldap",
"freeradius",
"py36-ldap",
"py38-ldap",
"gnupg1",
"evolution-data-server",
"ldapvi",
"virtuoso-6",
"virtuoso-7",
"alpine",
"virtuoso-5",
"kdepimlibs4",
"kdepimlibs4-kioslaves",
"py27-ldap",
"py39-ldap",
"py310-ldap",
"py311-ldap",
"py312-ldap",
"gnupg2",
"mysql8"
]
}
]
},
{
"name": "oracle-instantclient",
"portdir": "databases/oracle-instantclient",
"version": "11.2.0.4.0",
"license": "Restrictive and Nomirror",
"platforms": "macosx",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.oracle.com/database/technologies/instant-client.html",
"description": "Oracle database connection libraries",
"long_description": "Oracle Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME.",
"active": true,
"categories": [
"databases"
],
"maintainers": [
{
"name": "ryandesign",
"github": "ryandesign",
"ports_count": 1826
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "extract",
"ports": [
"unzip"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"TOra",
"ocilib",
"libzdb-oracle",
"php83-oracle",
"php82-oracle",
"php81-oracle",
"php80-oracle",
"php74-oracle",
"php73-oracle",
"php72-oracle",
"php71-oracle",
"php70-oracle",
"php56-oracle",
"php55-oracle",
"php54-oracle",
"php53-oracle",
"php52-oracle",
"qore-oracle-module"
]
}
]
},
{
"name": "pazpar2",
"portdir": "databases/pazpar2",
"version": "1.14.1",
"license": "GPL-2+",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.indexdata.com/pazpar2",
"description": "metasearch daemon and server",
"long_description": "Pazpar2 is a high-performance, user interface-independent, data model-independent metasearching middleware webservice featuring merging, relevance ranking, record sorting, and faceted results.",
"active": true,
"categories": [
"devel",
"net",
"databases",
"www"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17"
]
},
{
"type": "lib",
"ports": [
"icu",
"yaz"
]
}
],
"depends_on": []
},
{
"name": "percona",
"portdir": "databases/percona",
"version": "8.0.16-7",
"license": "GPL-2",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.percona.com/",
"description": "Multithreaded SQL database server",
"long_description": "Percona is a fork of the MySQL server, a multi-threaded SQL database.",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"debug",
"openssl",
"system_readline",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17",
"cmake"
]
},
{
"type": "lib",
"ports": [
"icu",
"libevent",
"openssl",
"protobuf3-cpp",
"lz4",
"tcp_wrappers",
"cyrus-sasl2",
"re2",
"zlib"
]
},
{
"type": "run",
"ports": [
"mysql_select"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"percona-lib_mysqludf_preg",
"percona-lib_mysqludf_json",
"percona-lib_mysqludf_xql",
"libzdb-percona",
"qt4-mac-percona-plugin",
"percona-connector-cpp",
"percona-lib_mysqludf_fPROJ4"
]
},
{
"type": "run",
"ports": [
"percona-server"
]
}
]
},
{
"name": "percona-server",
"portdir": "databases/percona",
"version": "8.0.16-7",
"license": "BSD",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.percona.com/",
"description": "Run percona as server",
"long_description": "Run percona as server",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17"
]
},
{
"type": "run",
"ports": [
"percona"
]
}
],
"depends_on": []
},
{
"name": "percona-toolkit",
"portdir": "databases/percona-toolkit",
"version": "3.3.1",
"license": "(GPL-2 or Artistic-1)",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.percona.com/software/database-tools/percona-toolkit",
"description": "Collection of essential command-line utilities for MySQL",
"long_description": "Collection of essential command-line utilities for MySQL",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"perl5_28",
"perl5_30",
"perl5_32",
"perl5_34"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-16"
]
},
{
"type": "lib",
"ports": [
"perl5.34",
"p5.34-dbd-mysql",
"p5.34-dbi",
"p5.34-term-readkey",
"p5.34-time-hires"
]
}
],
"depends_on": []
},
{
"name": "pg2xbase",
"portdir": "databases/pg2xbase",
"version": "2.4.1",
"license": "unknown",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://web.archive.org/web/20080504010314/http://www.klaban.torun.pl/prog/pg2xbase/",
"description": "Convert data between PostgreSQL and DBF files",
"long_description": "pg2xbase provides utilities for converting between PostgreSQL databases and DBF files.",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-15"
]
},
{
"type": "lib",
"ports": [
"postgresql81",
"xbase"
]
}
],
"depends_on": []
},
{
"name": "pgbadger",
"portdir": "databases/pgbadger",
"version": "13.0",
"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_34",
"perl5_28",
"perl5_30",
"perl5_32"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17"
]
},
{
"type": "lib",
"ports": [
"perl5.34",
"p5.34-json-xs",
"p5.34-text-csv_xs"
]
}
],
"depends_on": []
},
{
"name": "pgbouncer",
"portdir": "databases/pgbouncer",
"version": "1.23.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": 1008
}
],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"gmake",
"pkgconfig",
"clang-16"
]
},
{
"type": "lib",
"ports": [
"libevent",
"openssl",
"c-ares"
]
}
],
"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": [
"python39",
"python310",
"python311",
"python312",
"python313"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17",
"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-9.0"
]
},
{
"type": "run",
"ports": [
"tcl"
]
}
],
"depends_on": []
},
{
"name": "pgmodeler",
"portdir": "databases/pgmodeler",
"version": "1.1.6",
"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": 96
},
{
"name": "herby.gillot",
"github": "herbygillot",
"ports_count": 1008
}
],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-17"
]
},
{
"type": "lib",
"ports": [
"libxml2",
"postgresql15",
"qt64-qtbase",
"qt64-qtsvg"
]
}
],
"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-9.0"
]
}
],
"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": [
"clang-16",
"postgresql16"
]
}
],
"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-9.0"
]
},
{
"type": "extract",
"ports": [
"unzip"
]
},
{
"type": "lib",
"ports": [
"mono"
]
}
],
"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-17"
]
},
{
"type": "lib",
"ports": [
"tcl",
"postgresql16",
"sqlite3"
]
}
],
"depends_on": []
},
{
"name": "postgis",
"portdir": "databases/postgis",
"version": "1.5.8",
"license": "GPL-2",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://postgis.refractions.net/",
"description": "PostGIS adds support for geographic objects to the PostgreSQL database",
"long_description": "PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS \"spatially enables\" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS Simple Features Specification for SQL and will be submitted for conformance testing at version 1.0.",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"postgresql82",
"postgresql83",
"postgresql84",
"postgresql90",
"postgresql91",
"postgresql92",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"ImageMagick",
"docbook-xsl-nons",
"libxslt",
"clang-13"
]
},
{
"type": "lib",
"ports": [
"postgresql92",
"libxml2",
"proj4",
"geos",
"libiconv"
]
}
],
"depends_on": []
},
{
"name": "postgis2",
"portdir": "databases/postgis2",
"version": "2.5.5",
"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": 62
}
],
"variants": [
"postgresql12",
"postgresql11",
"postgresql10",
"postgresql93",
"postgresql94",
"postgresql95",
"postgresql96",
"raster",
"topology",
"sfcgal",
"gui",
"proj7",
"comments",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"autoconf",
"automake",
"libtool",
"libxslt",
"clang-17"
]
},
{
"type": "lib",
"ports": [
"libiconv",
"postgresql12",
"libxml2",
"gdal",
"proj6",
"geos",
"json-c"
]
}
],
"depends_on": []
},
{
"name": "postgis3",
"portdir": "databases/postgis3",
"version": "3.6.0",
"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": 97
},
{
"name": "vince",
"github": "Veence",
"ports_count": 62
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "lib",
"ports": [
"protobuf-c",
"gdal",
"geos",
"json-c",
"icu",
"libxml2",
"proj9",
"postgresql15",
"libiconv"
]
}
],
"depends_on": []
},
{
"name": "postgresql-unaccent",
"portdir": "databases/postgresql-unaccent",
"version": "0.1",
"license": "unknown",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "http://launchpad.net/postgresql-unaccent/",
"description": "PostgreSQL extension that provides a function to remove accents from characters",
"long_description": "postgresql-unaccent is a PostgreSQL extension that provides a function to remove accents from characters (not compatible with the version bundled in postgresql90)",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"postgresql82",
"postgresql83",
"postgresql84",
"postgresql90",
"postgresql91"
],
"dependencies": [
{
"type": "build",
"ports": [
"postgresql90",
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"unac"
]
}
],
"depends_on": []
},
{
"name": "postgresql10",
"portdir": "databases/postgresql10",
"version": "10.19",
"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": 37
}
],
"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": "postgresql10-doc",
"portdir": "databases/postgresql10-doc",
"version": "10.19",
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-16"
]
}
],
"depends_on": []
},
{
"name": "postgresql10-server",
"portdir": "databases/postgresql10-server",
"version": "10.19",
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql10"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"amber"
]
}
]
},
{
"name": "postgresql11",
"portdir": "databases/postgresql11",
"version": "11.14",
"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": 37
}
],
"variants": [
"clang13",
"clang14",
"clang15",
"clang16",
"clang17",
"clang18",
"clang19",
"clang20",
"clang21",
"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": "postgresql11-doc",
"portdir": "databases/postgresql11-doc",
"version": "11.14",
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-16"
]
}
],
"depends_on": []
},
{
"name": "postgresql11-server",
"portdir": "databases/postgresql11-server",
"version": "11.14",
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql11"
]
}
],
"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",
"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"
]
},
{
"type": "lib",
"ports": [
"timescaledb1",
"pg12-pgpointcloud",
"pg12-postgis3",
"pg12-timescaledb",
"pg12-pgrouting",
"p5.26-dbd-pg",
"postgis2"
]
},
{
"type": "run",
"ports": [
"postgresql12-server"
]
}
]
},
{
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"docbook-xml-4.5",
"docbook-xsl-nons",
"clang-17"
]
}
],
"depends_on": []
},
{
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql12"
]
}
],
"depends_on": []
},
{
"name": "postgresql13",
"portdir": "databases/postgresql13",
"version": "13.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": "davidgilman1",
"github": "dgilman",
"ports_count": 135
},
{
"name": "vital.had",
"github": "barracuda156",
"ports_count": 2563
}
],
"variants": [
"clang13",
"clang14",
"clang15",
"clang16",
"clang17",
"clang18",
"clang19",
"clang20",
"clang21",
"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-postgis3-doc"
]
},
{
"type": "lib",
"ports": [
"pg13-pgpointcloud",
"pg13-postgis3",
"pg13-timescaledb",
"pg13-pgrouting"
]
},
{
"type": "run",
"ports": [
"postgresql13-server"
]
}
]
},
{
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"docbook-xml-4.5",
"docbook-xsl-nons",
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql13-server",
"portdir": "databases/postgresql13-server",
"version": "13.22",
"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": 37
}
],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql13"
]
}
],
"depends_on": []
},
{
"name": "postgresql80",
"portdir": "databases/postgresql80",
"version": "8.0.26",
"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": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"krb5",
"perl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"zlib",
"openssl",
"readline"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"qt4-mac-postgresql80-plugin",
"libzdb-postgresql80"
]
},
{
"type": "run",
"ports": [
"postgresql80-server"
]
}
]
},
{
"name": "postgresql80-doc",
"portdir": "databases/postgresql80-doc",
"version": "8.0.26",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the postgresql database",
"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": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
}
],
"depends_on": []
},
{
"name": "postgresql80-server",
"portdir": "databases/postgresql80-server",
"version": "8.0.26",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql80 as server",
"long_description": "run postgresql80 as server",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "run",
"ports": [
"postgresql80"
]
}
],
"depends_on": []
},
{
"name": "postgresql81",
"portdir": "databases/postgresql81",
"version": "8.1.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": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"python",
"krb5",
"perl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"clang-9.0"
]
},
{
"type": "lib",
"ports": [
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"pg2xbase",
"qt4-mac-postgresql81-plugin",
"libzdb-postgresql81"
]
},
{
"type": "run",
"ports": [
"postgresql81-server"
]
}
]
},
{
"name": "postgresql81-doc",
"portdir": "databases/postgresql81-doc",
"version": "8.1.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the postgresql database",
"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": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
}
],
"depends_on": []
},
{
"name": "postgresql81-server",
"portdir": "databases/postgresql81-server",
"version": "8.1.23",
"license": "Permissive",
"platforms": "darwin",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql81 as server",
"long_description": "run postgresql81 as server",
"active": false,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-9.0"
]
},
{
"type": "run",
"ports": [
"postgresql81"
]
}
],
"depends_on": []
},
{
"name": "postgresql82",
"portdir": "databases/postgresql82",
"version": "8.2.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": [],
"variants": [
"python",
"krb5",
"perl",
"tcl",
"universal"
],
"dependencies": [
{
"type": "build",
"ports": [
"bison",
"clang-18"
]
},
{
"type": "lib",
"ports": [
"readline",
"zlib",
"libxslt",
"libxml2",
"openssl10"
]
}
],
"depends_on": [
{
"type": "lib",
"ports": [
"qt4-mac-postgresql82-plugin",
"libzdb-postgresql82"
]
},
{
"type": "run",
"ports": [
"postgresql82-server"
]
}
]
},
{
"name": "postgresql82-doc",
"portdir": "databases/postgresql82-doc",
"version": "8.2.23",
"license": "Permissive",
"platforms": "any",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "Documentation for the PostgreSQL database version 8.2",
"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": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
}
],
"depends_on": []
},
{
"name": "postgresql82-server",
"portdir": "databases/postgresql82-server",
"version": "8.2.23",
"license": "Permissive",
"platforms": "{darwin any}",
"epoch": 0,
"replaced_by": null,
"homepage": "https://www.postgresql.org/",
"description": "run postgresql82 as server",
"long_description": "run postgresql82 as server",
"active": true,
"categories": [
"databases"
],
"maintainers": [],
"variants": [],
"dependencies": [
{
"type": "build",
"ports": [
"clang-18"
]
},
{
"type": "run",
"ports": [
"postgresql82"
]
}
],
"depends_on": []
}
]
}