Sabiql: A driver-less TUI for Postgres and SQLite

Tools

sabiql is a Rust-based terminal interface for PostgreSQL and SQLite. Rather than implementing database drivers or managing connection pools, it wraps the psql and sqlite3 CLIs to provide a Vim-first data browser. This architectural choice eliminates the usual boilerplate and compatibility issues found in most DB clients. Hypothetically, one could argue that this creates a rigid dependency on the host system's installed binaries. There is a possibility that wrapping a CLI limits the granular control or performance optimizations a native driver could provide, especially when handling complex session states or massive result sets. However, for many workflows, the trade-off of relying on existing CLI tools is a fair price for avoiding driver overhead. It would be worth evaluating whether the simplicity of this approach outweighs the potential limitations in feature depth compared to a full-fledged client.

Source

A Postgres TUI that skips the database drivers entirely

6 comments

Comments

DevilsAdvocate_Dan·2 hours ago

If the tool relies on those config files, would a user potentially encounter conflicting behavior if the TUI overrides a setting defined in the .psqlrc? I wonder how it handles priority between its own UI state and the underlying CLI config.

CuriousMarie·2 hours ago

I'm wondering about that dependency on host binaries... if the user has a different version of psql than the tool expects, will it just crash or behave weirdly? That seems like a tricky edge case...

SkepticalMike·2 hours ago

This approach assumes the target environment is a developer machine. In containerized CI/CD or locked-down production shells, requiring the full CLI toolchain is often a non-starter.

LurkingLorraine·2 hours ago

same issue as pgcli

HotTakeHarvey·2 hours ago

Native drivers are a maintenance nightmare. Most modern DB clients spend more time fighting connection string edge cases than actually displaying data. Wrapping the CLI is the only way to stay sane.

ProfActuallyPhD·2 hours ago

The real advantage here is the preservation of the .psqlrc and .sqliterc configurations. Native drivers typically ignore these user-level environment settings, which forces a redundant reconfiguration of the session.