git: dede8a40cffc - main - databases/sq: Add new port
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Wed, 09 Jul 2025 07:25:46 UTC
The branch main has been updated by olgeni:
URL: https://cgit.FreeBSD.org/ports/commit/?id=dede8a40cffc3fea8ec06def0583fa2e04907072
commit dede8a40cffc3fea8ec06def0583fa2e04907072
Author: Jimmy Olgeni <olgeni@FreeBSD.org>
AuthorDate: 2025-07-09 07:00:31 +0000
Commit: Jimmy Olgeni <olgeni@FreeBSD.org>
CommitDate: 2025-07-09 07:25:19 +0000
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/
---
databases/Makefile | 1 +
databases/sq/Makefile | 22 ++++++++++++++++++++++
databases/sq/distinfo | 7 +++++++
databases/sq/pkg-descr | 14 ++++++++++++++
4 files changed, 44 insertions(+)
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.