diff options
| author | Jimmy Olgeni <olgeni@FreeBSD.org> | 2025-07-09 07:00:31 +0000 |
|---|---|---|
| committer | Jimmy Olgeni <olgeni@FreeBSD.org> | 2025-07-09 07:25:19 +0000 |
| commit | dede8a40cffc3fea8ec06def0583fa2e04907072 (patch) | |
| tree | 1400eaced5e6deafe45dc248a5c046a34e7ce05f | |
| parent | f166c8bb1ffa5cac48850520cb09668f0d079a1d (diff) | |
databases/sq: Add new port
sq is a command-line tool that provides jq-style access to structured
data sources including SQL databases and document formats. It supports
cross-source joins, multiple output formats, and unified querying across
various data sources.
WWW: https://sq.io/
| -rw-r--r-- | databases/Makefile | 1 | ||||
| -rw-r--r-- | databases/sq/Makefile | 22 | ||||
| -rw-r--r-- | databases/sq/distinfo | 7 | ||||
| -rw-r--r-- | databases/sq/pkg-descr | 14 |
4 files changed, 44 insertions, 0 deletions
diff --git a/databases/Makefile b/databases/Makefile index ce29492a0960..c076df5d6f2d 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -1076,6 +1076,7 @@ SUBDIR += spatialite-tools SUBDIR += spatialite_gui SUBDIR += speedtables + SUBDIR += sq SUBDIR += sql-workbench SUBDIR += sqlcached SUBDIR += sqlcipher diff --git a/databases/sq/Makefile b/databases/sq/Makefile new file mode 100644 index 000000000000..d3079f072817 --- /dev/null +++ b/databases/sq/Makefile @@ -0,0 +1,22 @@ +PORTNAME= sq +DISTVERSIONPREFIX= v +DISTVERSION= 0.48.5 +CATEGORIES= databases + +MAINTAINER= olgeni@FreeBSD.org +COMMENT= CLI tool for querying multiple databases and data formats +WWW= https://sq.io/ + +LICENSE= MIT +LICENSE_FILE= ${WRKSRC}/LICENSE + +USES= go:modules + +USE_GITHUB= yes +GH_ACCOUNT= neilotoole + +GO_MODULE= github.com/neilotoole/sq + +PLIST_FILES= bin/sq + +.include <bsd.port.mk> diff --git a/databases/sq/distinfo b/databases/sq/distinfo new file mode 100644 index 000000000000..7e7470620471 --- /dev/null +++ b/databases/sq/distinfo @@ -0,0 +1,7 @@ +TIMESTAMP = 1752020539 +SHA256 (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.mod) = 438cd2aa3b98e2401dfab7e002b37c6f9d3bb861cfe43a87ac9c77da97abfed3 +SIZE (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.mod) = 4051 +SHA256 (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.zip) = 1ba7cf722a5678b789dff9d6f22ffc47435b1c328c5dd7d91ef049ed6b66136f +SIZE (go/databases_sq/neilotoole-sq-v0.48.5_GH0/v0.48.5.zip) = 63203565 +SHA256 (go/databases_sq/neilotoole-sq-v0.48.5_GH0/neilotoole-sq-v0.48.5_GH0.tar.gz) = 4ed9cef836e66174b6e01c8d410cd393aeae7f7069a428a7ab2adcd1e282cf68 +SIZE (go/databases_sq/neilotoole-sq-v0.48.5_GH0/neilotoole-sq-v0.48.5_GH0.tar.gz) = 62450246 diff --git a/databases/sq/pkg-descr b/databases/sq/pkg-descr new file mode 100644 index 000000000000..7871ea0d080e --- /dev/null +++ b/databases/sq/pkg-descr @@ -0,0 +1,14 @@ +sq is a command-line tool that provides jq-style access to structured data +sources including SQL databases and document formats like CSV, Excel, and JSON. + +Key features: + +- Query multiple database types (PostgreSQL, MySQL, SQLite, SQL Server, etc.) +- Cross-source joins between different databases and file formats +- Multiple output formats (JSON, CSV, Excel, HTML, XML, Markdown) +- Database inspection and schema comparison +- SQL execution with syntax highlighting +- Data import/export between sources + +sq simplifies working with structured data by providing a unified interface +for querying and transforming data across various sources. |