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.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 3.0.1_1 | 3.0.1_2 | - | - | 3.0.1_2 |
| FreeBSD:14:quarterly | 3.0.1_1 | 3.0.1_1 | n/a | - | 3.0.1_1 |
| FreeBSD:15:latest | 3.0.1_2 | 3.0.1_2 | n/a | - | - |
| FreeBSD:15:quarterly | 3.0.1_1 | 3.0.1_1 | n/a | n/a | n/a |
| FreeBSD:16:latest | 3.0.1_1 | 3.0.1_2 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Runtime 1
xdg-open: devel/xdg-utils
The full lists below include those, and their dependencies in turn.
Build dependencies 19
Run dependencies 56
- archivers/brotli
- archivers/libdeflate
- archivers/liblz4
- archivers/lzo2
- archivers/zstd
- converters/fribidi
- converters/libiconv
- devel/gettext-runtime
- devel/glib20
- devel/libdatrie
- devel/libffi
- devel/libinotify
- devel/libltdl
- devel/libthai
- devel/pcre2
- devel/py-packaging
- devel/readline
- devel/xdg-utils
- graphics/cairo
- graphics/gd
- graphics/giflib
- graphics/graphite2
- graphics/graphviz
- graphics/jbigkit
- graphics/jpeg-turbo
- graphics/lerc
- graphics/png
- graphics/tiff
- graphics/webp
- lang/python312
- lang/python315
- math/mpdecimal
- misc/hicolor-icon-theme
- print/freetype2
- print/harfbuzz
- print/indexinfo
- textproc/expat2
- x11-fonts/fontconfig
- x11-fonts/libXft
- x11-toolkits/libXaw
- x11-toolkits/libXmu
- x11-toolkits/libXt
- x11-toolkits/pango
- x11/libICE
- x11/libSM
- x11/libX11
- x11/libXau
- x11/libXdmcp
- x11/libXext
- x11/libXpm
- x11/libXrender
- x11/libxcb
- x11/pixman
- x11/xorgproto
- x11/xprop
- x11/xset
No port depends on this one.
Configuration
Options name: databases_sabiql
| Option | Default | Description |
|---|---|---|
| ER_DIAGRAMS | on | Enable support for E-R diagrams |
- USES
- cargo
- Service scripts
- none
Files
distinfo 450
| File | Size | SHA256 |
|---|---|---|
| rust/crates/addr2line-0.25.1.crate | 43134 | 1b5d307320b3181d6d7954e663bd7c774a838b8220fe0593c86d9fb09f498b4b |
| rust/crates/adler2-2.0.1.crate | 13366 | 320119579fcad9c21884f5c4861d16174d0e06250625266f50fe6898340abefa |
| rust/crates/aho-corasick-1.1.5.crate | 184315 | c982642fa9e8606056828ee9a8505737230110bb1099153c79efe865c59d12ba |
| rust/crates/allocator-api2-0.2.21.crate | 63622 | 683d7910e743518b0e34f1186f92494becacb047c7b6bf616c96772180fef923 |
| rust/crates/anstream-1.0.0.crate | 28916 | 824a212faf96e9acacdbd09febd34438f8f711fb84e09a8916013cd7815ca28d |
| rust/crates/anstyle-1.0.14.crate | 17787 | 940b3a0ca603d1eade50a4846a2afffd5ef57a9feac2c0e2ec2e14f9ead76000 |
| rust/crates/anstyle-parse-1.0.0.crate | 22042 | 52ce7f38b242319f7cabaa6813055467063ecdc9d355bbb4ce0c68908cd8130e |
| rust/crates/anstyle-query-1.1.5.crate | 10264 | 40c48f72fd53cd289104fc64099abca73db4166ad86ea0b4341abe65af83dadc |
| rust/crates/anstyle-wincon-3.0.11.crate | 12638 | 291e6a250ff86cd4a820112fb8898808a366d8f9f58ce16d1f538353ad55747d |
| rust/crates/anyhow-1.0.104.crate | 48819 | 330a5ed07fa54e4702c9d6c4174f74427fc0ef6e214bbd677ae50a5099946470 |
| rust/crates/approx-0.5.1.crate | 15100 | cab112f0a86d568ea0e627cc1d6be74a1e9cd55214684db5561995f6dad897c6 |
| rust/crates/arboard-3.7.0.crate | 54873 | aeb9553e62312c8756a5979254fc6d7da8bbeb5986a1e17037fab932f7037917 |
| rust/crates/async-trait-0.1.92.crate | 32039 | 82f6aeea286b8eb4dd3431a1be1b59d290ace00f5bfd8e2a159bc2a05e2c1667 |
| rust/crates/atomic-0.6.1.crate | 15243 | a89cbf775b137e9b968e67227ef7f775587cde3fd31b0d8599dbd0f598a48340 |
| rust/crates/atomic-waker-1.1.2.crate | 12422 | 1505bd5d3d116872e7271a6d4e16d81d0c8570876c8de68093a09ac269d8aac0 |
| rust/crates/autocfg-1.5.1.crate | 18911 | f2032f911046de80f0a198e0901378627c33f59ea0ac00e363d481118bd70a53 |
| rust/crates/aws-lc-rs-1.18.0.crate | 246295 | ce2b2dcc879c3bae0d371e77c99f2238400ef24ec001394befa67b6e543add9e |
| rust/crates/aws-lc-sys-0.44.0.crate | 9.67945e+06 | f09fae7be8bb3174e05c6afdb34199e6dc0c7c04ba9fa237b1967adfbde27483 |
| rust/crates/backtrace-0.3.76.crate | 89458 | bb531853791a215d7c62a30daf0dde835f381ab5de4589cfe7c649d2cbe92bd6 |
| rust/crates/base64-0.22.1.crate | 81597 | 72b3254f16251a8381aa12e40e3c4d2f0199f8c6508fbecb9d91f575e0fbb8c6 |
Commit history 9
| Date | Commit | Credits | Log 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.