Our great sponsors
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
pspg
Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.
-
textual
The lean application framework for Python. Build sophisticated user interfaces with a simple Python API. Run your apps in the terminal and a web browser.
-
awesome-cli-frameworks
Collection of tools to build beautiful command line interface in different languages
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
I made a simple CLI wrapper that automates this, like Poetry does, except my wrapper uses pip.
https://github.com/jzombie/pipper
pspg is a pager intended to be used with SQL command line clients. It was originally created for Postgres (hence the name), but also works with MySQL and others
https://github.com/okbob/pspg
To access 10 different commands at the same time, that is tricky but definitely doable.
First thing that comes to mind, you can use aliases.
To keep it simple, lets use 3 examples instead of 10: harlequin (this project), pgcli (https://www.pgcli.com/) and httpx (https://www.python-httpx.org/)
Setup a main home for all your venvs:
cd ~
I like this one for .NET https://github.com/spectreconsole/spectre.console which I found in this list https://github.com/shadawck/awesome-cli-frameworks.
I like this one for .NET https://github.com/spectreconsole/spectre.console which I found in this list https://github.com/shadawck/awesome-cli-frameworks.
For those who prefer GUI apps, dbnet is an option to serve via HTTP. Run it remote side, access in the browser.
https://github.com/dbnet-io/dbnet
I would like to put in a vote for k9s, which is also on the list at Terminal Trove. [0] It's the most convenient tool I've ever found for Kubernetes management. Based on that experience I'll definitely be checking out Harlequin.
[0] https://k9scli.io/
> The hard part is honestly just having access to a DB server for testing.
Fwiw Microsoft SQL server is available as a Linux Docker build:
https://learn.microsoft.com/en-us/sql/linux/quickstart-insta...
Oracle is available as a container and vm:
https://container-registry.oracle.com/ords/f?p=113:4:1173021...
https://github.com/oracle/vagrant-projects
And via docker: