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

{
    "count": 49655,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=name&page=955",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=name&page=953",
    "results": [
        {
            "name": "spinner",
            "portdir": "sysutils/spinner",
            "version": "1.2.4",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.laffeycomputer.com/spinner.html",
            "description": "Keep ssh and telnet connections from dropping due to inactivity",
            "long_description": "Spinner is a small program that displays a little spinning ASCII character in the top left corner of your terminal. To make this effect it cycles through punctuation marks like this  -  | / -  | / ...  (try it to see). By default the character is drawn in inverse video (or your terminal`s equivalent). But you can turn this off with the -i switch. It supports any terminal capable of handling VT100 style escape codes. Spinner is useful for keeping telnet and ssh links from dropping due to inactivity. Many firewalls, and some ISPs drop connections when they are perceived as idle. By having spinner running the server is constantly sending a tiny amount of data over the link, preserving the connection. Thus Spinner is an anti-dle, timeout preventing, background daemon process.",
            "active": true,
            "categories": [
                "sysutils"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spirv-cross",
            "portdir": "graphics/spirv-cross",
            "version": "0.48.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/KhronosGroup/SPIRV-Cross",
            "description": "tool for parsing and converting SPIR-V to and from other shader languages",
            "long_description": "SPIRV-Cross is a tool and library for performing reflection on SPIR-V and disassembling SPIR-V back to high-level languages.",
            "active": true,
            "categories": [
                "graphics"
            ],
            "maintainers": [
                {
                    "name": "",
                    "github": "jasonliu--",
                    "ports_count": 37
                }
            ],
            "variants": [
                "debug",
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spirv-headers",
            "portdir": "graphics/spirv-headers",
            "version": "1.4.321.0",
            "license": "Apache-2",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://vulkan.lunarg.com",
            "description": "SPIR-V Headers",
            "long_description": "SPIR-V Headers",
            "active": true,
            "categories": [
                "devel",
                "graphics"
            ],
            "maintainers": [
                {
                    "name": "judaew",
                    "github": "judaew",
                    "ports_count": 610
                }
            ],
            "variants": [
                "debug"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-17"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "vulkan-validationlayers",
                        "shaderc"
                    ]
                }
            ]
        },
        {
            "name": "spirv-tools",
            "portdir": "graphics/spirv-tools",
            "version": "1.4.321.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://vulkan.lunarg.com",
            "description": "various SPIR-V tools",
            "long_description": "SPIR-V assembler, binary module parser, disassembler, validator, and optimizer",
            "active": true,
            "categories": [
                "graphics"
            ],
            "maintainers": [
                {
                    "name": "judaew",
                    "github": "judaew",
                    "ports_count": 610
                }
            ],
            "variants": [
                "debug",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-17",
                        "python313"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "glslang",
                        "vulkan-validationlayers",
                        "shaderc"
                    ]
                }
            ]
        },
        {
            "name": "splash",
            "portdir": "science/splash",
            "version": "3.11.5",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://users.monash.edu.au/~dprice/splash",
            "description": "Smoothed Particle Hydrodynamics visualisation tool",
            "long_description": "SPLASH is a tool for visualisation of (mainly astrophysical) Smoothed Particle Hydrodynamics simulations",
            "active": true,
            "categories": [
                "graphics",
                "science"
            ],
            "maintainers": [
                {
                    "name": "daniel.price",
                    "github": "danieljprice",
                    "ports_count": 2
                }
            ],
            "variants": [
                "gcc10",
                "gcc11",
                "gcc12",
                "gcc13",
                "gcc14",
                "gcc15",
                "gccdevel",
                "gfortran",
                "giza",
                "pgplot",
                "hdf5",
                "h5part",
                "read_extraformats1",
                "read_extraformats2"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "gcc15"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libgcc",
                        "giza"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "splat",
            "portdir": "net/splat",
            "version": "1.2",
            "license": "none",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "splatd",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by splatd",
            "long_description": "This port has been replaced by splatd.",
            "active": false,
            "categories": [
                "net"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "splatd",
            "portdir": "net/splatd",
            "version": "1.2",
            "license": "BSD",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/threerings/splatd",
            "description": "Splat: Scalable Periodic LDAP Attribute Transmogrifier",
            "long_description": "Splat is a daemon designed to help keep information in an LDAP directory in sync with information outside of an LDAP directory. This information can be any set of attributes on any object in the LDAP directory.",
            "active": true,
            "categories": [
                "net"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "python27",
                        "py27-ldap",
                        "py27-twisted",
                        "py27-zconfig"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "splint",
            "portdir": "devel/splint",
            "version": "3.1.2",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://splint.org/",
            "description": "Secure Programming Lint",
            "long_description": "Splint is a tool for statically checking C programs for security vulnerabilities and coding mistakes. With minimal effort, Splint can be used as a better lint. If additional effort is invested adding annotations to programs, Splint can perform stronger checking than can be done by any standard lint.",
            "active": true,
            "categories": [
                "devel"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "flex",
                        "clang-9.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "splpak",
            "portdir": "fortran/splpak",
            "version": "2.0.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/jacobwilliams/splpak",
            "description": "Modernized SPLPAK library for multidimensional least-squares cubic spline fitting",
            "long_description": "This library contains routines for fitting (least squares) a multidimensional cubic spline to arbitrarily located data. It also contains routines for evaluating this spline (or its partial derivatives) at any point. This is a modernization of the double precision SPLPAK files from NCL.",
            "active": true,
            "categories": [
                "math",
                "fortran"
            ],
            "maintainers": [
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "gcc10",
                "gcc11",
                "gcc12",
                "gccdevel"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14",
                        "gcc12",
                        "fpm"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libgcc"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spoof",
            "portdir": "net/spoof",
            "version": "2.0.4",
            "license": "MIT",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://feross.org/spoofmac/",
            "description": "Easily spoof your MAC address",
            "long_description": "spoof is a Node.js port of the popular SpoofMAC Python utility that allows you to easily spoof your MAC address.",
            "active": true,
            "categories": [
                "net",
                "security"
            ],
            "maintainers": [
                {
                    "name": "i0ntempest",
                    "github": "i0ntempest",
                    "ports_count": 224
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "npm9",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "nodejs18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spot",
            "portdir": "science/spot",
            "version": "2.11.6",
            "license": "GPL-3",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://spot.lrde.epita.fr/index.html",
            "description": "Spot is an object-oriented model checking library written in C++.",
            "long_description": "Spot is an object-oriented model checking library written in C++.",
            "active": true,
            "categories": [
                "science",
                "math"
            ],
            "maintainers": [],
            "variants": [
                "python310",
                "python311",
                "python312",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "python311"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spotify-dl",
            "portdir": "multimedia/spotify-dl",
            "version": "8.8.2",
            "license": "GPL-2",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/SathyaBhat/spotify-dl",
            "description": "Downloads songs from any Spotify playlist, album or track.",
            "long_description": "Downloads songs from any Spotify playlist, album or track.",
            "active": true,
            "categories": [
                "multimedia",
                "python"
            ],
            "maintainers": [
                {
                    "name": "judaew",
                    "github": "judaew",
                    "ports_count": 610
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "py311-build",
                        "py311-installer",
                        "py311-setuptools",
                        "py311-wheel",
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "py311-mutagen",
                        "yt-dlp",
                        "py311-rich",
                        "python311",
                        "py311-urllib3",
                        "py311-sentry-sdk",
                        "py311-spotipy"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spral",
            "portdir": "math/spral",
            "version": "2024.05.08",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.numerical.rl.ac.uk/spral",
            "description": "Sparse Parallel Robust Algorithms Library",
            "long_description": "An open-source (BSD) library for sparse linear algebra and associated algorithms. It is primarily developed by the Numerical Analysis group at STFC Rutherford Appleton Laboratory.",
            "active": true,
            "categories": [
                "science",
                "math"
            ],
            "maintainers": [
                {
                    "name": "vital.had",
                    "github": "barracuda156",
                    "ports_count": 2571
                }
            ],
            "variants": [
                "clang10",
                "clang11",
                "clang12",
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang19",
                "clang50",
                "clang60",
                "clang70",
                "clang80",
                "clang90",
                "clangdevel",
                "g95",
                "gcc10",
                "gcc11",
                "gcc12",
                "gcc13",
                "gcc14",
                "gccdevel",
                "gfortran",
                "openmp",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "gcc14",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libgcc",
                        "libomp",
                        "OpenBLAS",
                        "metis",
                        "hwloc"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spread-sheet-widget",
            "portdir": "office/spread-sheet-widget",
            "version": "0.10",
            "license": "GPL-3+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.gnu.org/software/ssw/",
            "description": "GTK+ widget for working with 2D tabular data.",
            "long_description": "GNU Spread Sheet Widget is a library for Gtk+ which provides a widget for viewing and manipulating 2 dimensional tabular data in a manner similar to many popular spread sheet programs.",
            "active": true,
            "categories": [
                "office"
            ],
            "maintainers": [
                {
                    "name": "snc",
                    "github": "nerdling",
                    "ports_count": 156
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "pkgconfig",
                        "coreutils",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "gtk3"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pspp",
                        "pspp-devel"
                    ]
                }
            ]
        },
        {
            "name": "spring-boot-cli",
            "portdir": "java/spring-boot-cli",
            "version": "3.5.7",
            "license": "Apache-2",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://projects.spring.io/spring-boot/",
            "description": "Spring Boot CLI -- An opinionated view of building production-ready Spring applications.",
            "long_description": "The Spring Boot CLI is a command line tool that can be used if you want to quickly prototype with Spring. It allows you to run Groovy scripts, which means that you have a familiar Java-like syntax, without much boilerplate code. You don't need to use the CLI to work with Spring Boot but it's definitely the quickest way to get a Spring application off the ground.",
            "active": true,
            "categories": [
                "java"
            ],
            "maintainers": [
                {
                    "name": "breun",
                    "github": "breun",
                    "ports_count": 95
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "openjdk21"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spring-framework25",
            "portdir": "java/spring-framework25",
            "version": "2.5.6.SEC01",
            "license": "Apache-2",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.springframework.org/",
            "description": "Spring application framework for Java",
            "long_description": "Spring is a layered Java/J2EE application framework.",
            "active": true,
            "categories": [
                "java"
            ],
            "maintainers": [],
            "variants": [
                "with_libs"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kaffe"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "spring-javaconfig"
                    ]
                }
            ]
        },
        {
            "name": "spring-framework30",
            "portdir": "java/spring-framework30",
            "version": "3.0.7",
            "license": "Apache-2",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.springsource.org/about",
            "description": "Spring application framework for Java",
            "long_description": "Spring is a layered Java/J2EE application framework.",
            "active": true,
            "categories": [
                "java"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kaffe"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spring-framework31",
            "portdir": "java/spring-framework31",
            "version": "3.1.2",
            "license": "(Apache-2 or BSD)",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.springsource.org/about",
            "description": "Spring application framework for Java",
            "long_description": "Spring is a layered Java/J2EE application framework.",
            "active": true,
            "categories": [
                "java"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kaffe"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spring-javaconfig",
            "portdir": "java/spring-javaconfig",
            "version": "0.2.1.0.0.M4",
            "license": "Apache-2",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.springframework.org/javaconfig",
            "description": "Type-safe, pure-Java way to configure applications",
            "long_description": "The Spring JavaConfig project provides a type-safe, pure-Java option for configuring Spring Application Contexts. While most people currently use XML to configure bean definitions in their Application Contexts, Spring's versatility and metadata based internal handling of bean definitions means alternatives to XML config are easy to implement.",
            "active": true,
            "categories": [
                "java"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "unzip"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "cglib",
                        "spring-framework25"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sprng",
            "portdir": "math/sprng",
            "version": "1.0",
            "license": "CC-BY-SA-4",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.sprng.org",
            "description": "Scalable Parallel Random Number Generators",
            "long_description": "Scalable Parallel Random Number Generators",
            "active": true,
            "categories": [
                "math"
            ],
            "maintainers": [],
            "variants": [
                "clang10",
                "clang11",
                "clang12",
                "clang13",
                "clang14",
                "clang15",
                "clang16",
                "clang17",
                "clang18",
                "clang90",
                "g95",
                "gcc10",
                "gcc11",
                "gcc12",
                "gcc13",
                "gfortran",
                "mpich",
                "openmpi"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "mpich-clang16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sptk",
            "portdir": "audio/sptk",
            "version": "3.11",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://sp-tk.sourceforge.net",
            "description": "The Speech Signal Processing Toolkit",
            "long_description": "The Speech Signal Processing Toolkit (SPTK) is a suite of speech signal processing tools for UNIX environments, e.g., LPC analysis, PARCOR analysis, LSP analysis, PARCOR synthesis filter, LSP synthesis filter, vector quantization techniques, and other extended versions of them.",
            "active": true,
            "categories": [
                "audio"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "xorg-libX11"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spu-binutils",
            "portdir": "cross/spu-binutils",
            "version": "2.34",
            "license": "GPL-3+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.gnu.org/software/binutils/binutils.html",
            "description": "FSF Binutils for spu cross development",
            "long_description": "Free Software Foundation development toolchain (\"binutils\") for spu cross development.",
            "active": true,
            "categories": [
                "devel",
                "cross"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        "xz"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "gettext"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "spuce",
            "portdir": "audio/spuce",
            "version": "0.4.3",
            "license": "Boost-1",
            "platforms": "darwin macosx",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/audiofilter/spuce",
            "description": "A DSP digital filtering library - IIR/FIR filtering",
            "long_description": "A DSP digital filtering library - IIR/FIR filtering",
            "active": true,
            "categories": [
                "audio"
            ],
            "maintainers": [
                {
                    "name": "ra1nb0w",
                    "github": "ra1nb0w",
                    "ports_count": 148
                }
            ],
            "variants": [
                "debug",
                "qtgui",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-17"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "PothosPlotters",
                        "PothosComms"
                    ]
                }
            ]
        },
        {
            "name": "spyder_select",
            "portdir": "python/spyder_select",
            "version": "0.1",
            "license": "Permissive",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "",
            "description": "common files for selecting default spyder version",
            "long_description": "This port installs files that allow 'port select' to be used to create links to the preferred default version of spyder.",
            "active": true,
            "categories": [
                "python"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "py36-spyder",
                        "py36-spyder-devel",
                        "py37-spyder",
                        "py37-spyder-devel",
                        "py38-spyder-devel",
                        "py39-spyder-devel",
                        "py310-spyder-devel",
                        "py310-spyder",
                        "py311-spyder",
                        "py312-spyder",
                        "py313-spyder",
                        "py38-spyder",
                        "py39-spyder"
                    ]
                }
            ]
        },
        {
            "name": "spymemcached",
            "portdir": "java/spymemcached",
            "version": "2.8.4",
            "license": "MIT",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://code.google.com/p/spymemcached/",
            "description": "A high performance, distributed object caching system.",
            "long_description": "Memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load. This Port provides a native Java client written by Dustin Sallings.",
            "active": true,
            "categories": [
                "java"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "kaffe"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sq",
            "portdir": "databases/sq",
            "version": "0.48.5",
            "license": "MIT",
            "platforms": "darwin freebsd linux",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://sq.io",
            "description": "sq data wrangler",
            "long_description": "sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. It is the lovechild of sql+jq.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1013
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "go",
                        "clang-17"
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        "git"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "icu"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlc",
            "portdir": "devel/sqlc",
            "version": "1.29.0",
            "license": "MIT",
            "platforms": "darwin freebsd linux",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://sqlc.dev/",
            "description": "Generate type-safe Golang code from SQL",
            "long_description": "Generate type-safe Golang code from SQL",
            "active": true,
            "categories": [
                "devel",
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1013
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "go",
                        "clang-17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlcheck",
            "portdir": "databases/sqlcheck",
            "version": "1.3",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/jarulraj/sqlcheck",
            "description": "Automatically identify anti-patterns in SQL queries",
            "long_description": "sqlcheck automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries. sqlcheck targets all major SQL dialects.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1013
                }
            ],
            "variants": [
                "debug",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-14"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "gflags",
                        "gtest"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlcipher",
            "portdir": "databases/sqlcipher",
            "version": "4.6.1",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.zetetic.net/sqlcipher/",
            "description": "An security extesion to the embedded SQL database engine",
            "long_description": "SQLCipher extends the SQLite database library to add security enhancements that make it more suitable for encrypted local data storage like: * on-the-fly encryption * tamper detection * memory sanitization * strong key derivation. 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": "ybzhao1989",
                    "github": "z7z8th",
                    "ports_count": 2
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "libedit",
                        "ncurses",
                        "openssl3"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "libretroshare"
                    ]
                }
            ]
        },
        {
            "name": "sqlcipher-tools",
            "portdir": "databases/sqlcipher",
            "version": "4.6.1",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.zetetic.net/sqlcipher/",
            "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": "ybzhao1989",
                    "github": "z7z8th",
                    "ports_count": 2
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "tcl",
                        "openssl3"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "SQLClient",
            "portdir": "gnustep/SQLClient",
            "version": "1.2.0",
            "license": "LGPL",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.gnustep.org/",
            "description": "Simple OO Interface to SQL databases",
            "long_description": "Simple OO Interface to SQL databases",
            "active": true,
            "categories": [
                "gnustep"
            ],
            "maintainers": [],
            "variants": [
                "with_docs"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "sqlite3",
                        "Performance"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "Etoile",
                        "Etoile-devel"
                    ]
                }
            ]
        },
        {
            "name": "sqlean",
            "portdir": "databases/sqlean",
            "version": "0.27.1",
            "license": "MIT",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/nalgeon/sqlean",
            "description": "The ultimate set of SQLite extensions",
            "long_description": "SQLite has few functions compared to other database management systems. SQLite authors see this as a feature rather than a problem, because SQLite has an extension mechanism in place. There are a lot of SQLite extensions out there, but they are incomplete, inconsistent and scattered across the internet. sqlean brings them together, neatly packaged into domain modules, documented, tested, and built for Linux, Windows and macOS.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1013
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        "git"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "sqlite3"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlgrey",
            "portdir": "mail/sqlgrey",
            "version": "1.8.0",
            "license": "GPL-2",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://sqlgrey.sourceforge.net/",
            "description": "SQLgrey is a postfix policy service implementing a grey-listing policy",
            "long_description": "SQLgrey is a postfix policy service implementing a grey-listing policy",
            "active": true,
            "categories": [
                "mail"
            ],
            "maintainers": [],
            "variants": [
                "perl5_28",
                "perl5_30",
                "perl5_32",
                "perl5_34",
                "mysql",
                "sqlite",
                "postgresql",
                "table_names"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "p5.34-dbd-mysql",
                        "p5.34-dbi",
                        "p5.34-io-multiplex",
                        "perl5.34",
                        "p5.34-net-server",
                        "p5.34-net-dns"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "postfix"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "run",
                    "ports": [
                        "sgwi"
                    ]
                }
            ]
        },
        {
            "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.51.0",
            "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": 1098
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "libedit",
                        "ncurses"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "build",
                    "ports": [
                        "sqlitewrapped",
                        "emacs-mac-app-devel",
                        "emacs-mac-app"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "py35-apsw",
                        "py36-apsw",
                        "qt6-sqlite-plugin",
                        "sequoia-pgp",
                        "telepathy-logger",
                        "sleuthkit",
                        "logjam",
                        "nanomq",
                        "wire",
                        "monotone",
                        "monotone-devel",
                        "wired-server",
                        "botan",
                        "freeciv",
                        "freeciv-x11",
                        "hyperscan",
                        "seed",
                        "SQLClient",
                        "abaddon",
                        "javasqlite",
                        "fortran-sqlite3",
                        "gst",
                        "Chatty",
                        "pypy",
                        "pypy36",
                        "pypy37",
                        "pypy38",
                        "pypy39",
                        "qore-sqlite3-module",
                        "snobol4",
                        "ReadyMedia",
                        "mediatomb",
                        "libcmatrix",
                        "xeus-sqlite",
                        "gramps",
                        "evolution-data-server-gtk4",
                        "libchamplain",
                        "tracker3",
                        "webkit-gtk",
                        "webkit-gtk3",
                        "epiphany",
                        "tippecanoe",
                        "bibledit",
                        "bzrtp",
                        "py37-dlib",
                        "py38-dlib",
                        "softhsm",
                        "libzdb-sqlite3",
                        "apr-util",
                        "neko",
                        "pure-sql3",
                        "php84-sqlite",
                        "php83-sqlite",
                        "php82-sqlite",
                        "rb-sqlite3",
                        "libsoup",
                        "libsoup-devel",
                        "php81-sqlite",
                        "liferea",
                        "tracker",
                        "php80-sqlite",
                        "gearmand",
                        "emacs",
                        "emacs-devel",
                        "emacs-app",
                        "emacs-app-devel",
                        "php74-sqlite",
                        "php73-sqlite",
                        "php72-sqlite",
                        "limesuite",
                        "limesuite-devel",
                        "python26",
                        "python27",
                        "php71-sqlite",
                        "darktable",
                        "darktable-devel",
                        "php70-sqlite",
                        "zathura-docs",
                        "moodss",
                        "py27-apsw",
                        "gnupg2",
                        "zathura",
                        "subversion-perlbindings-5.26",
                        "php56-sqlite",
                        "php55-sqlite",
                        "php54-sqlite",
                        "php53-sqlite",
                        "subversion-pythonbindings-3.9",
                        "supertuxkart",
                        "py27-sqlite",
                        "bulk_extractor",
                        "ncdc",
                        "rb19-sqlite3",
                        "audacity-devel",
                        "wview",
                        "qt511-qtwebkit",
                        "gnomint",
                        "dupd",
                        "macports.sqlext",
                        "rpm",
                        "rpm54",
                        "ocropus",
                        "qt4-mac-sqlite3-plugin",
                        "mongrel2",
                        "phantomjs-qt-qtwebkit",
                        "phantomjs-qt-sqlite-plugin",
                        "qt511-sqlite-plugin",
                        "py310-apsw",
                        "py311-apsw",
                        "kopete",
                        "xlsx2csv",
                        "pounce",
                        "tenacity",
                        "subversion-python27bindings",
                        "subversion-pythonbindings-2.7",
                        "subversion-pythonbindings-3.5",
                        "subversion-pythonbindings-3.6",
                        "subversion-pythonbindings-3.7",
                        "audacity-legacy",
                        "hugin-app",
                        "R-lwgeom",
                        "qt69-sqlite-plugin",
                        "sqlite3-pcre2",
                        "gom",
                        "qt53-sqlite-plugin",
                        "qt53-qtwebkit",
                        "ocaml-sqlite3",
                        "qt56-qtwebkit",
                        "spatialite",
                        "zeal",
                        "qt55-qtwebkit",
                        "link-grammar",
                        "zorba",
                        "p5.28-alien-sqlite",
                        "p5.30-alien-sqlite",
                        "p5.32-alien-sqlite",
                        "p5.34-alien-sqlite",
                        "qt56-sqlite-plugin",
                        "qt55-sqlite-plugin",
                        "proj6",
                        "proj7",
                        "proj8",
                        "proj9",
                        "qt57-sqlite-plugin",
                        "grilo-plugins",
                        "qt57-qtwebkit",
                        "qt58-sqlite-plugin",
                        "qt58-qtwebkit",
                        "qt59-qtwebkit",
                        "py37-apsw",
                        "qt59-sqlite-plugin",
                        "avidemux",
                        "py38-apsw",
                        "evolution-data-server",
                        "lnav",
                        "lnav-devel",
                        "xmoto",
                        "aircrack-ng",
                        "fluent-bit",
                        "Deriv",
                        "FileZilla",
                        "python313",
                        "python313-freethreading",
                        "python315-devel",
                        "python315-freethreading-devel",
                        "webkit2-gtk",
                        "webkit2-gtk-devel",
                        "python39",
                        "subversion",
                        "subversion-javahlbindings",
                        "subversion-perlbindings-5.28",
                        "subversion-perlbindings-5.30",
                        "subversion-perlbindings-5.32",
                        "subversion-perlbindings-5.34",
                        "subversion-pythonbindings-3.8",
                        "subversion-rubybindings",
                        "python32",
                        "python33",
                        "kget",
                        "textmate2",
                        "py27-yum-metadata-parser",
                        "fdupes",
                        "warzone2100",
                        "bogofilter",
                        "qt5-qtwebkit",
                        "retroshare-qt4",
                        "sqlitecpp",
                        "qt5-sqlite-plugin",
                        "openslide",
                        "mame",
                        "lastfm-desktop",
                        "python310",
                        "rspamd",
                        "python311",
                        "python34",
                        "python35",
                        "python36",
                        "python37",
                        "kyua",
                        "R-adbcsqlite",
                        "python312",
                        "vectorscan",
                        "dino",
                        "gnubg",
                        "fastfetch",
                        "R-gdalraster",
                        "R-sf",
                        "R-terra",
                        "grass",
                        "nmail",
                        "qgis3",
                        "qgis3-ltr",
                        "cherrytree",
                        "qt64-sqlite-plugin",
                        "qt67-sqlite-plugin",
                        "qt68-sqlite-plugin",
                        "Akumuli",
                        "sqlitebrowser",
                        "newsraft",
                        "py39-dlib",
                        "sqlean",
                        "pgtcl",
                        "eiskaltdcpp",
                        "wt",
                        "midori",
                        "exim",
                        "tagtool",
                        "gnu-apl",
                        "newsboat",
                        "python38",
                        "libwired",
                        "poco",
                        "libdbi-drivers",
                        "subversion-pythonbindings-3.10",
                        "subversion-pythonbindings-3.11",
                        "subversion-pythonbindings-3.12",
                        "grass7",
                        "librasterlite2",
                        "py310-dlib",
                        "py311-dlib",
                        "py312-dlib",
                        "radlib",
                        "scamper",
                        "balsa",
                        "libshumate",
                        "sequoia-sq",
                        "py39-apsw",
                        "font-manager",
                        "tilemaker",
                        "yelp",
                        "qt513-qtwebkit",
                        "libsoup-2.4",
                        "qt513-sqlite-plugin",
                        "bitcoin",
                        "cadabra2",
                        "gdal",
                        "gdal-hdf5",
                        "gdal-kea",
                        "gdal-netcdf",
                        "luanti",
                        "nextcloud-client",
                        "webkit-gtk-2.0",
                        "webkit-gtk3-2.0",
                        "darwinbuild",
                        "darwinbuild-legacy",
                        "gdb-apple",
                        "octave-sqlite",
                        "lporg",
                        "sequoia-chameleon-gnupg",
                        "rawstudio",
                        "janet-sqlite3",
                        "Io",
                        "cl-sqlite",
                        "apophenia",
                        "fossil",
                        "python314",
                        "python314-freethreading",
                        "xmltv",
                        "libpreludedb",
                        "nss",
                        "muchsync"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "sqliteman",
                        "auto-multiple-choice",
                        "auto-multiple-choice-devel"
                    ]
                }
            ]
        },
        {
            "name": "sqlite3-pcre2",
            "portdir": "databases/sqlite3-pcre2",
            "version": "0.1",
            "license": "public-domain",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://git.altlinux.org/people/at/packages/?p=sqlite3-pcre.git",
            "description": "Perl-compatible regular expression support for SQLite",
            "long_description": "Perl-compatible regular expression support for SQLite.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 98
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "pkgconfig",
                        "clang-16"
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        "git"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "sqlite3",
                        "pcre2"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlite3-tcl",
            "portdir": "databases/sqlite3",
            "version": "3.51.0",
            "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": 1098
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "zlib",
                        "tcl"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlite3-tools",
            "portdir": "databases/sqlite3",
            "version": "3.51.0",
            "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": 1098
                }
            ],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "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": []
        },
        {
            "name": "sqlitecpp",
            "portdir": "databases/sqlitecpp",
            "version": "3.3.3",
            "license": "MIT",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/SRombauts/SQLiteCpp",
            "description": "SQLiteC++ (SQLiteCpp) is a smart and easy to use C++ SQLite3 wrapper.",
            "long_description": "SQLiteC++ (SQLiteCpp) is a smart and easy to use C++ SQLite3 wrapper.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "mps",
                    "github": "Schamschula",
                    "ports_count": 1098
                }
            ],
            "variants": [
                "debug",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "sqlite3"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "xeus-sqlite",
                        "warzone2100"
                    ]
                }
            ]
        },
        {
            "name": "sqlitedbrowser",
            "portdir": "databases/sqlitedbrowser",
            "version": "0",
            "license": "public-domain",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://sourceforge.net/projects/sqlitedbrowser",
            "description": "A graphical SQLite3 Viewer - new Version (aka SqliteStudio)",
            "long_description": "A graphical SQLite3 Viewer - new Version (aka SqliteStudio)",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal",
                "debug"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "pkgconfig",
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac",
                        "qt4-mac-sqlite3-plugin"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqliteman",
            "portdir": "databases/sqliteman",
            "version": "1.2.2",
            "license": "GPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://sourceforge.net/p/sqliteman/wiki/Home/",
            "description": "GUI tool for Sqlite3",
            "long_description": "The best developer's and/or admin's GUI tool for Sqlite3 in the world. No joking here (or just a bit only) - it contains the most complete feature set of all tools available.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "debug"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0",
                        "cmake",
                        "pkgconfig",
                        "makeicns"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "qt4-mac",
                        "qscintilla-qt4"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "qt4-mac-sqlite3-plugin",
                        "sqlite3"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlitewrapped",
            "portdir": "databases/sqlitewrapped",
            "version": "1.3.1",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.alhem.net/project/sqlite/index.html",
            "description": "a C++ wrapper for the Sqlite database C API",
            "long_description": "This is a C++ wrapper for the Sqlite database C application programming interface. The code works for linux/unix, as well as win32. This library supports version 3 of the sqlite database. From version 1.2 the connection pool can be made threadsafe.",
            "active": true,
            "categories": [
                "devel",
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "sqlite3",
                        "clang-9.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlmap",
            "portdir": "security/sqlmap",
            "version": "1.9.10",
            "license": "GPL-2+",
            "platforms": "{darwin any}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://sqlmap.org/",
            "description": "Automatic SQL injection and database takeover tool",
            "long_description": "sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester, and a broad range of switches including database fingerprinting, over data fetching from the database, accessing the underlying file system, and executing commands on the operating system via out-of-band connections.",
            "active": true,
            "categories": [
                "databases",
                "security",
                "python"
            ],
            "maintainers": [
                {
                    "name": "judaew",
                    "github": "judaew",
                    "ports_count": 610
                }
            ],
            "variants": [
                "python310",
                "python311",
                "python312",
                "python313",
                "python27"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18",
                        "py313-build",
                        "py313-installer",
                        "py313-setuptools",
                        "py313-wheel"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "python313"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlninja",
            "portdir": "security/sqlninja",
            "version": "0.2.6-r1",
            "license": "GPL-3+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://sqlninja.sourceforge.net/",
            "description": "Microsoft SQL Server SQL Injection vulnerability tester",
            "long_description": "Sqlninja is a tool targeted to exploit SQL Injection vulnerabilities on a web application that uses Microsoft SQL Server as its back-end.",
            "active": true,
            "categories": [
                "net",
                "security"
            ],
            "maintainers": [],
            "variants": [
                "perl5_28",
                "perl5_30",
                "perl5_32",
                "perl5_34"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "p5.34-io-socket-ssl",
                        "p5.34-net-dns",
                        "p5.34-net-pcap",
                        "p5.34-net-rawip",
                        "p5.34-netpacket"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlninja-devel",
            "portdir": "security/sqlninja",
            "version": "0.2.999-alpha1",
            "license": "GPL-3+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://sqlninja.sourceforge.net/",
            "description": "Microsoft SQL Server SQL Injection vulnerability tester",
            "long_description": "Sqlninja is a tool targeted to exploit SQL Injection vulnerabilities on a web application that uses Microsoft SQL Server as its back-end.",
            "active": true,
            "categories": [
                "net",
                "security"
            ],
            "maintainers": [],
            "variants": [
                "perl5_34",
                "perl5_28",
                "perl5_30",
                "perl5_32"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-16"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "p5.34-dbi",
                        "p5.34-io-socket-ssl",
                        "p5.34-net-dns",
                        "p5.34-dbd-sqlite",
                        "p5.34-net-rawip",
                        "p5.34-netpacket",
                        "p5.34-net-pcap"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqlpkg-cli",
            "portdir": "devel/sqlpkg-cli",
            "version": "0.2.3",
            "license": "MIT",
            "platforms": "darwin freebsd linux",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://sqlpkg.org/",
            "description": "SQLite Package Manager",
            "long_description": "sqlpkg-cli manages SQLite extensions, just like pip does with Python packages or brew does with macOS programs. It works primarily with the SQLite package registry, but is not limited to it. You can install SQLite extensions from GitHub repositories or other websites. All you need is a package spec file (more on that later).",
            "active": true,
            "categories": [
                "devel",
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1013
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "go",
                        "clang-17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "sqsh",
            "portdir": "sysutils/sqsh",
            "version": "2.4",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://sqsh.sourceforge.net/",
            "description": "A Sybase Shell",
            "long_description": "Sqsh (pronounced skwish) is short for SQshelL (pronounced s-q-shell), a replacement for the venerable 'isql' program supplied by Sybase.",
            "active": true,
            "categories": [
                "sysutils",
                "databases"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "freetds",
                        "readline"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "squashfs-tools",
            "portdir": "sysutils/squashfs-tools",
            "version": "4.5",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/plougher/squashfs-tools",
            "description": "Tools to create and extract Squashfs filesystems",
            "long_description": "Squashfs is a highly compressed read-only filesystem for Linux. It uses zlib compression to compress both files, inodes and directories. Inodes in the system are very small and all blocks are packed to minimise data overhead. Block sizes greater than 4K are supported up to a maximum of 64K. Squashfs is intended for general read-only filesystem use, for archival use (i.e. in cases where a .tar.gz file may be used), and in constrained block device/memory systems (e.g. embedded systems) where low overhead is needed.",
            "active": true,
            "categories": [
                "sysutils"
            ],
            "maintainers": [
                {
                    "name": "quentin",
                    "github": "quentinmit",
                    "ports_count": 8
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "lz4",
                        "lzo2",
                        "xz",
                        "zlib",
                        "zstd"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "squeak",
            "portdir": "lang/squeak",
            "version": "3.9",
            "license": "MIT",
            "platforms": "{darwin < 12}",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.squeak.org",
            "description": "Full, portable, Smalltalk-80 system",
            "long_description": "Squeak is a full-featured implementation of the Smalltalk programming language and environment based on (and largely compatible with) the original Smalltalk-80 system. Squeak has very powerful 2- and 3-D graphics, sound, video, MIDI, animation and other multimedia capabilities -- and one of the most impressive development environments ever created. It also includes a customisable framework for creating dynamic HTTP servers and interactively extensible Web sites. The entire Squeak system is open source software, distributed freely with a liberal license.",
            "active": true,
            "categories": [
                "lang"
            ],
            "maintainers": [],
            "variants": [
                "quartz",
                "x11",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "mesa",
                        "xorg-libsm"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}