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

{
    "count": 49383,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=created_at&page=29",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=created_at&page=27",
    "results": [
        {
            "name": "postgresql83",
            "portdir": "databases/postgresql83",
            "version": "8.3.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",
                "python27",
                "krb5",
                "perl",
                "tcl"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "bison",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "BigSQL",
                        "libpqxx26",
                        "qt4-mac-postgresql83-plugin",
                        "libzdb-postgresql83",
                        "rb-postgres"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql83-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql83-doc",
            "portdir": "databases/postgresql83-doc",
            "version": "8.3.23",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 8.3",
            "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": "postgresql83-server",
            "portdir": "databases/postgresql83-server",
            "version": "8.3.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql83 as server",
            "long_description": "run postgresql83 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql83"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql84",
            "portdir": "databases/postgresql84",
            "version": "8.4.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": [
                "python",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "earthdistance",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-84"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "BiggerSQL",
                        "py27-pgsql",
                        "qt4-mac-postgresql84-plugin",
                        "libzdb-postgresql84"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql84-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql84-doc",
            "portdir": "databases/postgresql84-doc",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 8.4",
            "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": "postgresql84-server",
            "portdir": "databases/postgresql84-server",
            "version": "8.4.22",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql84 as server",
            "long_description": "run postgresql84 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql84"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql90",
            "portdir": "databases/postgresql90",
            "version": "9.0.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",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-90"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql-unaccent"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql90-plugin",
                        "libzdb-postgresql90"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql90-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql90-doc",
            "portdir": "databases/postgresql90-doc",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.0",
            "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": "postgresql90-server",
            "portdir": "databases/postgresql90-server",
            "version": "9.0.23",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql90 as server",
            "long_description": "run postgresql90 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql90"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "iplike"
                    ]
                }
            ]
        },
        {
            "name": "postgresql91",
            "portdir": "databases/postgresql91",
            "version": "9.1.24",
            "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",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ossp-uuid",
                        "readline",
                        "zlib",
                        "libxslt",
                        "libxml2",
                        "openssl10"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-91"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-postgresql91-plugin",
                        "libzdb-postgresql91"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql91-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql91-doc",
            "portdir": "databases/postgresql91-doc",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.1",
            "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": "postgresql91-server",
            "portdir": "databases/postgresql91-server",
            "version": "9.1.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql91 as server",
            "long_description": "run postgresql91 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql91"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql92",
            "portdir": "databases/postgresql92",
            "version": "9.2.24",
            "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",
                "python27",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "ossp-uuid"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-92"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "py27-pygresql",
                        "postgis",
                        "py37-pygresql",
                        "qt4-mac-postgresql92-plugin",
                        "libzdb-postgresql92"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql92-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql92-doc",
            "portdir": "databases/postgresql92-doc",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.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": "postgresql92-server",
            "portdir": "databases/postgresql92-server",
            "version": "9.2.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql92 as server",
            "long_description": "run postgresql92 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql92"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql93",
            "portdir": "databases/postgresql93",
            "version": "9.3.25",
            "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",
                "krb5",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline",
                        "libxml2",
                        "zlib",
                        "openssl11",
                        "libxslt",
                        "ossp-uuid"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-93"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql93-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql93-doc",
            "portdir": "databases/postgresql93-doc",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.3",
            "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": "postgresql93-server",
            "portdir": "databases/postgresql93-server",
            "version": "9.3.25",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql93 as server",
            "long_description": "run postgresql93 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql93"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql94",
            "portdir": "databases/postgresql94",
            "version": "9.4.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": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [
                "python",
                "python27",
                "perl",
                "tcl",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "bison"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "libxslt",
                        "zlib",
                        "openssl11",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-94"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql94-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql94-doc",
            "portdir": "databases/postgresql94-doc",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.4",
            "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": "postgresql94-server",
            "portdir": "databases/postgresql94-server",
            "version": "9.4.26",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql94 as server",
            "long_description": "run postgresql94 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql94"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql95",
            "portdir": "databases/postgresql95",
            "version": "9.5.25",
            "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": [
                        "libxml2",
                        "libxslt",
                        "zlib",
                        "openssl3",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-95"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql95-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql95-doc",
            "portdir": "databases/postgresql95-doc",
            "version": "9.5.25",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.5",
            "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": "postgresql95-server",
            "portdir": "databases/postgresql95-server",
            "version": "9.5.25",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql95 as server",
            "long_description": "run postgresql95 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql95"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql96",
            "portdir": "databases/postgresql96",
            "version": "9.6.24",
            "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",
                        "openssl3",
                        "libxslt",
                        "readline"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-96"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "slony1",
                        "pgAdmin3"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql96-server"
                    ]
                }
            ]
        },
        {
            "name": "postgresql96-doc",
            "portdir": "databases/postgresql96-doc",
            "version": "9.6.24",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "Documentation for the PostgreSQL database version 9.6",
            "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": "postgresql96-server",
            "portdir": "databases/postgresql96-server",
            "version": "9.6.24",
            "license": "Permissive",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "run postgresql96 as server",
            "long_description": "run postgresql96 as server",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "jwa",
                    "github": "jyrkiwahlstedt",
                    "ports_count": 37
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postgresql96"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql_autodoc",
            "portdir": "databases/postgresql_autodoc",
            "version": "1.41",
            "license": "BSD",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.rbt.ca/autodoc/",
            "description": "Automatic documentation generator for postgresql databases",
            "long_description": "Automatic documentation generator for postgresql databases. It supports output in HTML, GraphViz, SGML DocBook and DIA formats.",
            "active": true,
            "categories": [
                "databases",
                "textproc"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "perl5.34"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "p5.34-dbd-pg",
                        "p5.34-dbi",
                        "p5.34-html-template",
                        "p5.34-term-readkey"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "postgresql_select",
            "portdir": "databases/postgresql_select",
            "version": "0.8",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.postgresql.org/",
            "description": "common files for selecting default PostgreSQL version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of PostgreSQL.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "davidgilman1",
                    "github": "dgilman",
                    "ports_count": 135
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "postgresql_select-84",
                        "postgresql_select-90",
                        "postgresql_select-91",
                        "postgresql_select-92",
                        "postgresql_select-93",
                        "postgresql_select-94",
                        "postgresql_select-95",
                        "postgresql_select-96",
                        "postgresql_select-10",
                        "postgresql_select-11",
                        "postgresql_select-12",
                        "postgresql_select-13",
                        "postgresql_select-14",
                        "postgresql_select-15",
                        "postgresql_select-16",
                        "postgresql_select-17",
                        "postgresql_select-18",
                        "calendar-contacts-server"
                    ]
                }
            ]
        },
        {
            "name": "pqa",
            "portdir": "databases/pqa",
            "version": "1.6",
            "license": "Permissive and GPLConflict",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://pqa.projects.postgresql.org/",
            "description": "pqa is a PostgreSQL SQL analysis tool",
            "long_description": "PostgreSQL Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type select/insert/update/delete), and more.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ruby"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "psiconv",
            "portdir": "databases/psiconv",
            "version": "0.9.9",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://frodo.looijaard.name/project/psiconv",
            "description": "A utility for converting Psion files.",
            "long_description": "A utility for converting Psion files.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ImageMagick"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "abiword-x11",
                        "gnumeric"
                    ]
                }
            ]
        },
        {
            "name": "pspg",
            "portdir": "databases/pspg",
            "version": "5.8.7",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/okbob/pspg",
            "description": "pspg is a Unix pager optimized for table browsing",
            "long_description": "pspg is a Unix pager optimized for table browsing",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ncurses",
                        "readline"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "psqlODBC",
            "portdir": "databases/psqlODBC",
            "version": "16.00.0000",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://odbc.postgresql.org",
            "description": "Official ODBC driver for the PostgreSQL database.",
            "long_description": "psqlODBC allows ODBC-compliant applications to connect to PostgreSQL database servers.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "macports",
                    "github": "",
                    "ports_count": 2
                }
            ],
            "variants": [
                "iodbc",
                "unixodbc",
                "postgresql82",
                "postgresql83",
                "postgresql84",
                "postgresql90",
                "postgresql91",
                "postgresql92",
                "postgresql93",
                "postgresql94",
                "postgresql95",
                "postgresql96",
                "postgresql10",
                "postgresql11",
                "postgresql12",
                "postgresql13",
                "postgresql14",
                "postgresql15",
                "postgresql16",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "unixODBC",
                        "libtool",
                        "postgresql16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pxlib",
            "portdir": "databases/pxlib",
            "version": "0.6.8",
            "license": "GPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pxlib.sourceforge.net",
            "description": "A utility for reading and writing Paradox DB files.",
            "long_description": "A utility for reading and writing Paradox DB files.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16",
                        "pkgconfig",
                        "intltool",
                        "autoconf",
                        "automake",
                        "gettext",
                        "libtool"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libiconv",
                        "libgsf"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "gnumeric"
                    ]
                }
            ]
        },
        {
            "name": "qdbm",
            "portdir": "databases/qdbm",
            "version": "1.8.78",
            "license": "LGPL-2.1+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://fallabs.com/qdbm/index.html",
            "description": "QDBM is a library of routines for managing a database.",
            "long_description": "QDBM is a library of routines for managing a database. The database is a simple data file containing records, each is a pair of a key and a value. Every key and value is serial bytes with variable length. Both binary data and character string can be used as a key and a value. There is neither concept of data tables nor data types. Records are organized in hash table or B+ tree.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal",
                "debug",
                "bzip2",
                "lzo"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "libiconv"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "hyperestraier"
                    ]
                }
            ]
        },
        {
            "name": "qof",
            "portdir": "databases/qof",
            "version": "0.8.8",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://web.archive.org/web/20180413005909/https://alioth.debian.org/projects/qof/",
            "description": "Query Object Framework (QOF)",
            "long_description": "Query Object Framework (QOF) is a framework to allow the execution of SQL-type queries using collections of in-memory objects as 'tables'.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "automake",
                        "pkgconfig",
                        "clang-13",
                        "autoconf",
                        "libtool"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "glib2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "gnotime"
                    ]
                }
            ]
        },
        {
            "name": "redis",
            "portdir": "databases/redis",
            "version": "7.4.2",
            "license": "SSPL",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://redis.io",
            "description": "Redis is an open source, advanced key-value store.",
            "long_description": "Redis is an open source, advanced key-value store.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "openssl"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "p5.26-redis",
                        "p5.28-redis",
                        "p5.30-redis",
                        "p5.32-redis",
                        "p5.34-redis"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "amber"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "rspamd"
                    ]
                }
            ]
        },
        {
            "name": "rocksdb",
            "portdir": "databases/rocksdb",
            "version": "10.1.3",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://rocksdb.org",
            "description": "Embedded key-value store for fast storage",
            "long_description": "Embedded key-value store for fast storage",
            "active": true,
            "categories": [
                "devel",
                "databases"
            ],
            "maintainers": [
                {
                    "name": "stromnov",
                    "github": "stromnov",
                    "ports_count": 2738
                }
            ],
            "variants": [
                "debug",
                "jemalloc",
                "tbb",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "snappy",
                        "zlib",
                        "bzip2",
                        "gflags",
                        "zstd",
                        "lz4"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "shsql",
            "portdir": "databases/shsql",
            "version": "1.28",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://quisp.sourceforge.net/sqlman/html/shsql_home.html",
            "description": "standalone SQL database that stores data in ascii text files",
            "long_description": "SHSQL is a standalone SQL database that stores data in ascii text files. It has a small memory footprint and code size and can be embedded directly into applications - there is no server process. SHSQL is a pared-down SQL implementation but retains useful features such as timeout record locking and search engine comparison operators. A shsql database can be updated via SQL, or by editing data files with a text editor. Applications link to the supplied C language API. There is also a command-line SQL utility.",
            "active": true,
            "categories": [
                "databases",
                "textproc"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "simplevoc-open",
            "portdir": "databases/simplevoc-open",
            "version": "1.8.0",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.worldofvoc.com/",
            "description": "Versatile object cache",
            "long_description": "SimpleVoc-OPEN is an open source version of a key/value based in memory object cache software. (See the WWW page for details.)",
            "active": false,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "f.celler",
                    "github": "",
                    "ports_count": 1
                },
                {
                    "name": "k.salewski",
                    "github": "",
                    "ports_count": 1
                },
                {
                    "name": "w.helisch",
                    "github": "",
                    "ports_count": 1
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "boost",
                        "libev",
                        "clang-9.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "slony1",
            "portdir": "databases/slony1",
            "version": "2.2.5",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://main.slony.info/",
            "description": "A replication system for PostgreSQL",
            "long_description": "Slony-I is a trigger-based master to multiple slaves replication system for PostgreSQL being developed by Jan Wieck.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "wreese",
                    "github": "",
                    "ports_count": 1
                }
            ],
            "variants": [
                "postgresql92",
                "postgresql93",
                "postgresql94",
                "postgresql95",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql96"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "soci",
            "portdir": "databases/soci",
            "version": "4.0.3",
            "license": "Boost-1",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://soci.sourceforge.net/",
            "description": "SOCI - The C++ Database Access Library",
            "long_description": "SOCI is a database access library for C++ that makes the illusion of embedding SQL queries in the regular C++ code, staying entirely within the Standard C++. The idea is to provide C++ programmers a way to access SQL databases in the most natural and intuitive way. If you find existing libraries too difficult for your needs or just distracting, SOCI can be a good alternative.",
            "active": true,
            "categories": [
                "devel",
                "databases"
            ],
            "maintainers": [
                {
                    "name": "g.lorenz",
                    "github": "",
                    "ports_count": 1
                }
            ],
            "variants": [
                "debug",
                "boost",
                "mysql5",
                "odbc",
                "oracle",
                "postgresql16",
                "sqlite3",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-14"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sparkey",
            "portdir": "databases/sparkey",
            "version": "0.2.99",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/spotify/sparkey",
            "description": "Simple constant key/value storage library, for read-heavy systems with infrequent large bulk inserts.",
            "long_description": "Simple constant key/value storage library, for read-heavy systems with infrequent large bulk inserts.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "snappy"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spatialite",
            "portdir": "databases/spatialite",
            "version": "5.1.0",
            "license": "(MPL-1.1 or GPL-2+ or LGPL-2.1+)",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.gaia-gis.it/fossil/libspatialite/index",
            "description": "Spatial extensions for SQLite 3",
            "long_description": "SpatiaLite is a library for geographic information systems (GIS) that implements the core OpenGIS specification. It provides SQLite with basic support for spatial data is intended for lightweight GIS projects.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 97
                }
            ],
            "variants": [
                "debug",
                "debugoptimized",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "pkgconfig",
                        "clang-15"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "sqlite3",
                        "librttopo",
                        "geos",
                        "zlib",
                        "proj9",
                        "freexl",
                        "libxml2",
                        "minizip"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "gdal",
                        "qgis3",
                        "gdal-hdf5",
                        "gdal-kea",
                        "qgis3-ltr",
                        "py27-spatialite",
                        "spatialite-tools",
                        "librasterlite2"
                    ]
                }
            ]
        },
        {
            "name": "spatialite-tools",
            "portdir": "databases/spatialite-tools",
            "version": "5.1.0",
            "license": "GPL-3",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.gaia-gis.it/fossil/spatialite-tools/index",
            "description": "Variety of CLI tools for SpatiaLite DB",
            "long_description": "These CLI tools allow to interact with a SpatiaLite DB, import a variety of files (SHP, OSM, GML) and prepare a virtual network for routing.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 97
                }
            ],
            "variants": [
                "readline",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "pkgconfig",
                        "clang-15"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "geos",
                        "expat",
                        "spatialite",
                        "proj9",
                        "freexl",
                        "libiconv",
                        "readosm"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlite2",
            "portdir": "databases/sqlite2",
            "version": "2.8.17",
            "license": "public-domain",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.sqlite.org/",
            "description": "an embedded SQL database engine",
            "long_description": "SQLite is an SQL database engine in a C library. Programs that link the SQLite library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "automake",
                        "clang-15"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "readline"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "tclsqlite2",
                        "javasqlite",
                        "rb-sqlite",
                        "qt4-mac-sqlite2-plugin"
                    ]
                }
            ]
        },
        {
            "name": "sqlite3",
            "portdir": "databases/sqlite3",
            "version": "3.50.4",
            "license": "public-domain",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.sqlite.org",
            "description": "an embedded SQL database engine",
            "long_description": "SQLite3 is an SQL database engine in a C library. Programs that link the SQLite3 library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite3) that can be used to administer an SQLite3 database and which serves as an example of how to use the SQLite3 library.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "mps",
                    "github": "Schamschula",
                    "ports_count": 1093
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "libedit",
                        "ncurses"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "sqlitewrapped",
                        "emacs-mac-app-devel",
                        "emacs-mac-app"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac-sqlite3-plugin",
                        "qt5-qtwebkit",
                        "qt5-sqlite-plugin",
                        "qt511-qtwebkit",
                        "qt511-sqlite-plugin",
                        "qt513-qtwebkit",
                        "qt513-sqlite-plugin",
                        "qt53-qtwebkit",
                        "qt53-sqlite-plugin",
                        "qt55-qtwebkit",
                        "qt55-sqlite-plugin",
                        "qt56-qtwebkit",
                        "qt56-sqlite-plugin",
                        "qt57-qtwebkit",
                        "qt57-sqlite-plugin",
                        "qt58-qtwebkit",
                        "qt58-sqlite-plugin",
                        "qt59-qtwebkit",
                        "qt59-sqlite-plugin",
                        "audacity-devel",
                        "tagtool",
                        "telepathy-logger",
                        "Akumuli",
                        "libdbi-drivers",
                        "libzdb-sqlite3",
                        "pgtcl",
                        "spatialite",
                        "sqlitebrowser",
                        "sqlitecpp",
                        "xeus-sqlite",
                        "apr-util",
                        "darwinbuild",
                        "darwinbuild-legacy",
                        "fossil",
                        "gdb-apple",
                        "kyua",
                        "monotone",
                        "monotone-devel",
                        "poco",
                        "radlib",
                        "subversion",
                        "subversion-javahlbindings",
                        "subversion-perlbindings-5.26",
                        "subversion-perlbindings-5.28",
                        "subversion-perlbindings-5.30",
                        "subversion-python27bindings",
                        "subversion-rubybindings",
                        "cherrytree",
                        "emacs",
                        "emacs-devel",
                        "emacs-app",
                        "emacs-app-devel",
                        "textmate2",
                        "mame",
                        "bitcoin",
                        "freeciv",
                        "freeciv-x11",
                        "gnubg",
                        "supertuxkart",
                        "xmoto",
                        "gramps",
                        "gdal",
                        "grass",
                        "grass7",
                        "proj6",
                        "proj7",
                        "proj8",
                        "qgis3",
                        "balsa",
                        "epiphany",
                        "evolution-data-server",
                        "grilo-plugins",
                        "libchamplain",
                        "libsoup",
                        "liferea",
                        "seed",
                        "tracker",
                        "yelp",
                        "SQLClient",
                        "darktable",
                        "hugin-app",
                        "openslide",
                        "rawstudio",
                        "javasqlite",
                        "kget",
                        "kopete",
                        "Io",
                        "gnu-apl",
                        "gst",
                        "neko",
                        "php80-sqlite",
                        "php74-sqlite",
                        "php73-sqlite",
                        "php72-sqlite",
                        "php71-sqlite",
                        "php70-sqlite",
                        "php56-sqlite",
                        "php55-sqlite",
                        "php54-sqlite",
                        "php53-sqlite",
                        "pypy",
                        "pypy36",
                        "pypy37",
                        "python26",
                        "python27",
                        "python32",
                        "python33",
                        "python34",
                        "python35",
                        "python36",
                        "python37",
                        "python38",
                        "python39",
                        "qore-sqlite3-module",
                        "bogofilter",
                        "exim",
                        "gnupg2",
                        "muchsync",
                        "rspamd",
                        "apophenia",
                        "cadabra2",
                        "py37-dlib",
                        "py38-dlib",
                        "py39-dlib",
                        "avidemux",
                        "xmltv",
                        "logjam",
                        "mediatomb",
                        "moodss",
                        "ncdc",
                        "newsboat",
                        "nss",
                        "ocaml-sqlite3",
                        "zathura",
                        "zathura-docs",
                        "pure-sql3",
                        "py27-apsw",
                        "py35-apsw",
                        "py36-apsw",
                        "py37-apsw",
                        "py38-apsw",
                        "py27-sqlite",
                        "py27-yum-metadata-parser",
                        "rb-sqlite3",
                        "rb19-sqlite3",
                        "limesuite",
                        "limesuite-devel",
                        "wview",
                        "aircrack-ng",
                        "botan",
                        "bulk_extractor",
                        "gnomint",
                        "libpreludedb",
                        "sequoia-pgp",
                        "softhsm",
                        "fdupes",
                        "fluent-bit",
                        "gearmand",
                        "lnav",
                        "macports.sqlext",
                        "rpm",
                        "rpm54",
                        "sleuthkit",
                        "bibledit",
                        "hyperscan",
                        "ocropus",
                        "xlsx2csv",
                        "zorba",
                        "FileZilla",
                        "midori",
                        "mongrel2",
                        "nextcloud-client",
                        "webkit-gtk",
                        "webkit-gtk3",
                        "webkit-gtk-2.0",
                        "webkit-gtk3-2.0",
                        "webkit2-gtk",
                        "webkit2-gtk-devel",
                        "python315-freethreading-devel",
                        "phantomjs-qt-qtwebkit",
                        "phantomjs-qt-sqlite-plugin",
                        "python314-freethreading",
                        "qt69-sqlite-plugin",
                        "python315-devel",
                        "janet-sqlite3",
                        "php81-sqlite",
                        "subversion-perlbindings-5.32",
                        "tippecanoe",
                        "subversion-pythonbindings-2.7",
                        "subversion-pythonbindings-3.5",
                        "subversion-pythonbindings-3.6",
                        "subversion-pythonbindings-3.7",
                        "subversion-pythonbindings-3.8",
                        "subversion-pythonbindings-3.9",
                        "dupd",
                        "bzrtp",
                        "python310",
                        "pypy38",
                        "audacity-legacy",
                        "darktable-devel",
                        "qt6-sqlite-plugin",
                        "lporg",
                        "ReadyMedia",
                        "subversion-perlbindings-5.34",
                        "warzone2100",
                        "py39-apsw",
                        "py310-apsw",
                        "proj9",
                        "p5.28-alien-sqlite",
                        "p5.30-alien-sqlite",
                        "p5.32-alien-sqlite",
                        "p5.34-alien-sqlite",
                        "snobol4",
                        "libsoup-devel",
                        "tilemaker",
                        "php82-sqlite",
                        "gom",
                        "pypy39",
                        "py310-dlib",
                        "python311",
                        "octave-sqlite",
                        "pounce",
                        "nanomq",
                        "zeal",
                        "fortran-sqlite3",
                        "R-terra",
                        "libsoup-2.4",
                        "R-sf",
                        "R-lwgeom",
                        "eiskaltdcpp",
                        "php83-sqlite",
                        "libwired",
                        "wire",
                        "wired-server",
                        "Deriv",
                        "R-gdalraster",
                        "qgis3-ltr",
                        "cl-sqlite",
                        "librasterlite2",
                        "py311-dlib",
                        "python312",
                        "font-manager",
                        "sqlite3-pcre2",
                        "R-adbcsqlite",
                        "py311-apsw",
                        "subversion-pythonbindings-3.10",
                        "subversion-pythonbindings-3.11",
                        "subversion-pythonbindings-3.12",
                        "newsraft",
                        "lnav-devel",
                        "fastfetch",
                        "nmail",
                        "tenacity",
                        "py312-dlib",
                        "link-grammar",
                        "abaddon",
                        "lastfm-desktop",
                        "retroshare-qt4",
                        "sqlean",
                        "tracker3",
                        "vectorscan",
                        "libshumate",
                        "dino",
                        "php84-sqlite",
                        "wt",
                        "qt64-sqlite-plugin",
                        "python313",
                        "sequoia-sq",
                        "libcmatrix",
                        "Chatty",
                        "evolution-data-server-gtk4",
                        "scamper",
                        "qt67-sqlite-plugin",
                        "python313-freethreading",
                        "gdal-hdf5",
                        "gdal-kea",
                        "sequoia-chameleon-gnupg",
                        "qt68-sqlite-plugin",
                        "luanti",
                        "python314"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "auto-multiple-choice",
                        "auto-multiple-choice-devel",
                        "sqliteman"
                    ]
                }
            ]
        },
        {
            "name": "sqlite3-tcl",
            "portdir": "databases/sqlite3",
            "version": "3.50.4",
            "license": "public-domain",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.sqlite.org",
            "description": "an embedded SQL database engine",
            "long_description": "SQLite3 is an SQL database engine in a C library. Programs that link the SQLite3 library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite3) that can be used to administer an SQLite3 database and which serves as an example of how to use the SQLite3 library.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "mps",
                    "github": "Schamschula",
                    "ports_count": 1093
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "tcl"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlite3-tools",
            "portdir": "databases/sqlite3",
            "version": "3.50.4",
            "license": "public-domain",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.sqlite.org",
            "description": "A bundle of command-line tools for managing SQLite database files",
            "long_description": "A bundle of command-line tools for managing SQLite database files, including the sqldiff program and the sqlite3_analyzer program.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "mps",
                    "github": "Schamschula",
                    "ports_count": 1093
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "tcl"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlitebrowser",
            "portdir": "databases/sqlitebrowser",
            "version": "3.13.1",
            "license": "GPL-3",
            "platforms": "darwin linux",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://sqlitebrowser.org",
            "description": "GUI editor for SQLite databases",
            "long_description": "SQLite Database Browser is a visual tool used to create, design and edit database files compatible with SQLite. Its interface is based on Qt, and is meant to be used by users and developers who want to create databases or edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to: * Create and compact database files * Create, define, modify and delete tables * Create, define and delete indexes * Browse, edit, add and delete records * Search records * Import and export records as text * Import and export tables from/to CSV files * Import and export databases from/to SQL dump files * Issue SQL queries and inspect the results * Examine a log of all SQL commands issued by the application. SQLite Database Browser is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "i0ntempest",
                    "github": "i0ntempest",
                    "ports_count": 224
                }
            ],
            "variants": [
                "debug",
                "sqlite3",
                "sqlcipher"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "qt5-qttools",
                        "cmake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "sqlite3",
                        "qscintilla-qt5",
                        "qt5-qtbase"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}