Harlequin: SQL IDE for Your Terminal

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • harlequin

    The SQL IDE for Your Terminal.

  • pipper

    Pipper makes working with pip and virtual environments easier. (by jzombie)

  • I made a simple CLI wrapper that automates this, like Poetry does, except my wrapper uses pip.

    https://github.com/jzombie/pipper

  • 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.

    WorkOS logo
  • 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.

  • 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

  • httpx

    A next generation HTTP client for Python. 🦋

  • 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 ~

  • 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.

  • spectre.console

    A .NET library that makes it easier to create beautiful console applications.

  • 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.

  • awesome-cli-frameworks

    Collection of tools to build beautiful command line interface in different languages

  • 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.

  • 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.

    InfluxDB logo
  • dbnet

    dbNet is a web-based database client using Go as a backend, and React as front-end

  • 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

  • k9s

    🐶 Kubernetes CLI To Manage Your Clusters In Style!

  • 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/

  • vagrant-projects

    Vagrant projects for Oracle products and other examples

  • > 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:

  • bubbletea

    A powerful little TUI framework 🏗

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts