pgcli
jq
pgcli | jq | |
---|---|---|
9 | 306 | |
11,729 | 25,063 | |
0.8% | - | |
7.1 | 0.0 | |
3 days ago | 11 months ago | |
Python | C | |
BSD 3-clause "New" or "Revised" License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgcli
-
Postgres: ERROR: column d.adsrc does not exist
Home: http://pgcli.com
- 5 Useful Database Command Line Tools
-
Visualize explain results from postgresql in pgcli
pip install git+https://github.com/dbcli/pgcli@main
-
14 Awesome CLI Tools for Modern Software Developers
pgcli is like DataGrip on your terminal.
-
Pipx: A python package consumption tool for CLI packages
If you want to know more about pgcli tool/package in Python, you can it's documentation webpage or the GitHub repository.
- Pgcli – Postgres CLI with autocompletion and syntax highlighting
- Advanced PostgreSQL/MySQL terminal clients
-
Commandline Database Clients with Autocompletion and Syntax Highlighting
In what way did it blow up? You must have hit a bug, using .pg_service should work. Would you care to open an issue on https://github.com/dbcli/pgcli/issues or just dump the error message here so we can investigate?
jq
-
GNU Parallel, where have you been all my life?
That should recursively list directories, counting only the files within each, and output² jsonl that can be further mangled within the shell². You could just as easily populate an associative array for further work, or $whatever. Unlike bash, zsh has reasonable behaviour around quoting and whitespace too.
¹ https://zsh.sourceforge.io/Doc/Release/User-Contributions.ht...
² https://github.com/jpmens/jo
³ https://github.com/stedolan/jq
- How do i edit reputation?
-
Jj: JSON Stream Editor
What I miss from jq and what is implemented but unreleased is platform independent line delimiters.
jq on Windows produces \r\n terminated lines which can be annoying when used with Cygwin / MSYS2 / WSL. The '--binary' option to not convert line delimiters is one of those pending improvements.
https://github.com/stedolan/jq/commit/0dab2b18d73e561f511801...
-
Building and deploying a web API powered by ChatGPT
If you have jq installed you can use it to make the output look nicer.
-
Search in your Jupyter notebooks from the CLI, fast.
It requires jq for JSON processing and GNU parallel for concurrent searches in the notebooks.
- Check the jq manual!
- mkv vs mp4 metadata
-
Amazon Begs Employees Not to Leak Corporate Secrets to ChatGPT
jq is your friend.
- Memes are all cool and all. But this is your daily remaining that 10000! =
-
How to export/import/externally-edit/whatever WI entries?
The jq command (https://stedolan.github.io/jq/) is useful pulling that information out.
What are some alternatives?
httpie - 🥧 HTTPie CLI — modern, user-friendly command-line HTTP client for the API era. JSON support, colors, sessions, downloads, plugins & more.
yq - Command-line YAML, XML, TOML processor - jq wrapper for YAML/XML/TOML documents
cookiecutter - A cross-platform command-line utility that creates projects from cookiecutters (project templates), e.g. Python package projects, C projects.
dasel - Select, put and delete data from JSON, TOML, YAML, XML and CSV files with a single tool. Supports conversion between formats and can be used as a Go package.
aws-cli - Universal Command Line Interface for Amazon Web Services
gojq - Pure Go implementation of jq
HTTP Prompt - An interactive command-line HTTP and API testing client built on top of HTTPie featuring autocomplete, syntax highlighting, and more. https://twitter.com/httpie
json5 - JSON5 — JSON for Humans
percol - adds flavor of interactive filtering to the traditional pipe concept of UNIX shell
jp - Validate and transform JSON with Bash
autopexpect - autoexpect for pexpect
nushell - A new type of shell