usql
pgcli
Our great sponsors
usql | pgcli | |
---|---|---|
21 | 9 | |
8,589 | 11,687 | |
1.2% | 0.9% | |
9.0 | 7.1 | |
7 days ago | 4 days ago | |
Go | Python | |
MIT License | BSD 3-clause "New" or "Revised" License |
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.
usql
- xo/usql: Universal command-line interface for SQL databases
- Usql – Universal command-line interface for SQL databases
-
PRQL a simple, powerful, pipelined SQL replacement
Also all languages has an query-builder / ORM so the benefit of something like PRQL is possibly not big enough to merit it as an additional dependency.
My suggestion:
Make PRQL a cli tool that can be used by allowing users to connect to a database in a similar fashion as something like usql (https://github.com/xo/usql),
-
Is there a CLI interface to browse SQL databases?
take a look at: https://github.com/xo/usql
-
New Open source Go projects looking for contributors
https://github.com/xo/usql has some good first issues
-
usql 0.11.0
There's a new release of usql that adds even more autocomplete and fixes a bunch of issues: https://github.com/xo/usql/releases/tag/v0.11.0
- 5 Useful Database Command Line Tools
- usql
-
Literate programming is much more than just commenting code
I am not a big fan of the complex literate programming style involving code-generation which this article talks about.
But I recently discovered that Google's zx [1] scripting utility supports executing scripts in markdown documents and I combined it with httpie [2] and usql [3] for a bit of quick and dirty automation testing and api verification code and it worked out pretty well.
[1] https://github.com/google/zx#markdown-scripts
- usql v0.9.4
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?
What are some alternatives?
go-sitemap-generator - go-sitemap-generator is the easiest way to generate Sitemaps in Go
httpie - 🥧 HTTPie CLI — modern, user-friendly command-line HTTP client for the API era. JSON support, colors, sessions, downloads, plugins & more.
hystrix-go - Netflix's Hystrix latency and fault tolerance library, for Go
cookiecutter - A cross-platform command-line utility that creates projects from cookiecutters (project templates), e.g. Python package projects, C projects.
boilr - :zap: boilerplate template manager that generates files or directories from template repositories
aws-cli - Universal Command Line Interface for Amazon Web Services
Task - A task runner / simpler Make alternative written in Go
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
ngrok - Unified ingress for developers
percol - adds flavor of interactive filtering to the traditional pipe concept of UNIX shell
fzf - :cherry_blossom: A command-line fuzzy finder
autopexpect - autoexpect for pexpect