BSD Ports

databases/sabiql 3.0.2 FreeBSD

PostgreSQL, MySQL and SQLite TUI to browse, query, and edit databases

System
FreeBSD
Repository
FreeBSD ports
Maintainer
[email protected]
Last update
Commit
b19b337bd8
License
APACHE20, BSD0CLAUSE, BSD2CLAUSE, BSD3CLAUSE, BSL, CDLA20, ISCL, MIT, MPL20, UNICODE, UNLICENSE, WTFPL, ZLIB
Categories
databases
Package size
1856.0 KiB, 5764.1 KiB installed

Description

A fast, driver-less TUI for browsing, querying, and editing PostgreSQL, MySQL, and SQLite databases from the terminal. It works with the database CLI you already use: psql, mysql, or sqlite3.

Sabiql wraps your existing psql, mysql or sqlite3 CLI - no Rust database drivers, no connection pools, no extra dependencies. Point it at your database and get a full-featured TUI with vim-like keybindings.

Features:

  • SQL Modal: ad-hoc queries with auto-completion for tables, columns, and keywords
  • ER Diagram: generate relationship diagrams via Graphviz, opened instantly in your browser
  • Inspector Pane: column details, types, constraints, and indexes for any table
  • Inline Cell Editing: edit cells in-place with a guarded UPDATE preview before committing
  • Row Deletion: DELETE with mandatory preview; risk level color-coded (yellow/orange/red)
  • Yank: copy any cell value to clipboard
  • and more...

Install

Binary package:

pkg install sabiql

From the ports tree:

cd /usr/ports/databases/sabiql/ && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	sabiql>0:databases/sabiql

Packages

The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.

Repositoryaarch64amd64armv6armv7i386
FreeBSD:14:latest3.0.1_13.0.1_2--3.0.1_2
FreeBSD:14:quarterly3.0.1_13.0.1_1n/a-3.0.1_1
FreeBSD:15:latest3.0.1_23.0.1_2n/a--
FreeBSD:15:quarterly3.0.1_13.0.1_1n/an/an/a
FreeBSD:16:latest3.0.1_13.0.1_2n/an/an/a
FreeBSD:16:quarterlyn/an/an/an/an/a

Dependencies

As this port's Makefile names them.

Runtime 1

The full lists below include those, and their dependencies in turn.

Build dependencies 19
Run dependencies 56

No port depends on this one.

Configuration

Options name: databases_sabiql

OptionDefaultDescription
ER_DIAGRAMSonEnable support for E-R diagrams
USES
cargo
Service scripts
none

Files

distinfo 450
FileSizeSHA256
rust/crates/addr2line-0.25.1.crate431341b5d307320b3181d6d7954e663bd7c774a838b8220fe0593c86d9fb09f498b4b
rust/crates/adler2-2.0.1.crate13366320119579fcad9c21884f5c4861d16174d0e06250625266f50fe6898340abefa
rust/crates/aho-corasick-1.1.5.crate184315c982642fa9e8606056828ee9a8505737230110bb1099153c79efe865c59d12ba
rust/crates/allocator-api2-0.2.21.crate63622683d7910e743518b0e34f1186f92494becacb047c7b6bf616c96772180fef923
rust/crates/anstream-1.0.0.crate28916824a212faf96e9acacdbd09febd34438f8f711fb84e09a8916013cd7815ca28d
rust/crates/anstyle-1.0.14.crate17787940b3a0ca603d1eade50a4846a2afffd5ef57a9feac2c0e2ec2e14f9ead76000
rust/crates/anstyle-parse-1.0.0.crate2204252ce7f38b242319f7cabaa6813055467063ecdc9d355bbb4ce0c68908cd8130e
rust/crates/anstyle-query-1.1.5.crate1026440c48f72fd53cd289104fc64099abca73db4166ad86ea0b4341abe65af83dadc
rust/crates/anstyle-wincon-3.0.11.crate12638291e6a250ff86cd4a820112fb8898808a366d8f9f58ce16d1f538353ad55747d
rust/crates/anyhow-1.0.104.crate48819330a5ed07fa54e4702c9d6c4174f74427fc0ef6e214bbd677ae50a5099946470
rust/crates/approx-0.5.1.crate15100cab112f0a86d568ea0e627cc1d6be74a1e9cd55214684db5561995f6dad897c6
rust/crates/arboard-3.7.0.crate54873aeb9553e62312c8756a5979254fc6d7da8bbeb5986a1e17037fab932f7037917
rust/crates/async-trait-0.1.92.crate3203982f6aeea286b8eb4dd3431a1be1b59d290ace00f5bfd8e2a159bc2a05e2c1667
rust/crates/atomic-0.6.1.crate15243a89cbf775b137e9b968e67227ef7f775587cde3fd31b0d8599dbd0f598a48340
rust/crates/atomic-waker-1.1.2.crate124221505bd5d3d116872e7271a6d4e16d81d0c8570876c8de68093a09ac269d8aac0
rust/crates/autocfg-1.5.1.crate18911f2032f911046de80f0a198e0901378627c33f59ea0ac00e363d481118bd70a53
rust/crates/aws-lc-rs-1.18.0.crate246295ce2b2dcc879c3bae0d371e77c99f2238400ef24ec001394befa67b6e543add9e
rust/crates/aws-lc-sys-0.44.0.crate9.67945e+06f09fae7be8bb3174e05c6afdb34199e6dc0c7c04ba9fa237b1967adfbde27483
rust/crates/backtrace-0.3.76.crate89458bb531853791a215d7c62a30daf0dde835f381ab5de4589cfe7c649d2cbe92bd6
rust/crates/base64-0.22.1.crate8159772b3254f16251a8381aa12e40e3c4d2f0199f8c6508fbecb9d91f575e0fbb8c6

Commit history 9

DateCommitCreditsLog message
b19b337bd8 Nicola Vitale databases/sabiql: Update to 3.0.2
- Add a patch to fix mio crate (fixed upstream in v. 1.2.4 [1]) ChangeLog: 1. https://github.com/riii111/sabiql/releases/tag/v3.0.2 Reported by: "github-actions[bot]" <[email protected]> [1] https://github.com/tokio-rs/mio/pull/2016
9c878207a1 Mikael Urankar lang/rust: Bump revisions after 1.99.0
PR: 299016
7316461925 Mikael Urankar lang/rust: Bump revisions after 1.98.1
PR: 298139
60281b957f Nicola Vitale databases/sabiql: Update to 3.0.1
- Pass argument --ignore-rust-version to cargo command, otherwise the port fails to build/install with the following error: error: rustc 1.97.1 is not supported by the following packages: [email protected] requires rustc 1.98 [email protected] requires rustc 1.98 [email protected] requires rustc 1.98 [email protected] requires rustc 1.98 [email protected] requires rustc 1.98 *** Error code 101 ChangeLog: 1. https://github.com/riii111/sabiql/releases/tag/v3.0.1 Reported by: riii111 <[email protected]>
95c8b69504 Nicola Vitale databases/sabiql: Update to 3.0.0
- Update COMMENT and pkg-descr to include the new feature of sabiql: MySQL support ChangeLog: 1. https://github.com/riii111/sabiql/releases/tag/v3.0.0 Reported by: riii111 <[email protected]>

The latest 5 of 9 in the history this site was built from.