dbcli / Vcli
Licence: other
Vertica CLI with auto-completion and syntax highlighting
Stars: ✭ 75
Programming Languages
python
139335 projects - #7 most used programming language
Projects that are alternatives of or similar to Vcli
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
Stars: ✭ 8,329 (+11005.33%)
Mutual labels: cli, syntax-highlighting, autocomplete
Influx Prompt
An interactive command-line InfluxDB cli with auto completion.
Stars: ✭ 42 (-44%)
Mutual labels: cli, syntax-highlighting, autocomplete
Diff2html Cli
Pretty diff to html javascript cli (diff2html-cli)
Stars: ✭ 287 (+282.67%)
Mutual labels: cli, syntax-highlighting
Caporal.js
A full-featured framework for building command line applications (cli) with node.js
Stars: ✭ 3,279 (+4272%)
Mutual labels: cli, autocomplete
Graphqurl
curl for GraphQL with autocomplete, subscriptions and GraphiQL. Also a dead-simple universal javascript GraphQL client.
Stars: ✭ 3,012 (+3916%)
Mutual labels: cli, autocomplete
Graphql For Vscode
GraphQL syntax highlighting, linting, auto-complete, and more!
Stars: ✭ 265 (+253.33%)
Mutual labels: syntax-highlighting, autocomplete
vim-stylus
A better vim plugin for stylus, including proper and up-to-date syntax highligting, indentation and autocomplete
Stars: ✭ 49 (-34.67%)
Mutual labels: syntax-highlighting, autocomplete
Crossline
A small, self-contained, zero-config, MIT licensed, cross-platform, readline and libedit replacement.
Stars: ✭ 53 (-29.33%)
Mutual labels: cli, autocomplete
Catage
Node package and CLI tool to convert code into an image with syntax highlighting
Stars: ✭ 44 (-41.33%)
Mutual labels: cli, syntax-highlighting
O
🌀 Text editor suitable for writing git commit messages and editing Markdown files. Can build executables and jump to errors at the press of `ctrl-space`, for several programming languages. Can format code with `ctrl-w`. Provides general syntax highlighting, rainbow parenthesis and cut/paste portals. o is intentionally limited to VT100.
Stars: ✭ 54 (-28%)
Mutual labels: syntax-highlighting, autocomplete
sublime-PICO-8
PICO-8 plugin for the Sublime Text 3 editor.
Stars: ✭ 42 (-44%)
Mutual labels: syntax-highlighting, autocomplete
CodeView
Android Library to make it easy to create an Code editor or IDE that support any languages and themes, with auto complete, auto indenting, snippets and more features
Stars: ✭ 254 (+238.67%)
Mutual labels: syntax-highlighting, autocomplete
Picocli
Picocli is a modern framework for building powerful, user-friendly, GraalVM-enabled command line apps with ease. It supports colors, autocompletion, subcommands, and more. In 1 source file so apps can include as source & avoid adding a dependency. Written in Java, usable from Groovy, Kotlin, Scala, etc.
Stars: ✭ 3,286 (+4281.33%)
Mutual labels: cli, autocomplete
sora-editor
A cool code editor library on Android with syntax-highlighting and auto-completion. (aka CodeEditor)
Stars: ✭ 580 (+673.33%)
Mutual labels: syntax-highlighting, autocomplete
Autocomplete
Autocomplete for terminals on MacOS
Stars: ✭ 569 (+658.67%)
Mutual labels: cli, autocomplete
Gql
Very simple CLI for many GraphQL schemas in the cloud. Provides autocompletion for GraphQL queries
Stars: ✭ 101 (+34.67%)
Mutual labels: cli, autocomplete
Athenacli
AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting.
Stars: ✭ 151 (+101.33%)
Mutual labels: cli, syntax-highlighting
Smart Area
📝 Textareas on Steroids - AngularJS directive
Stars: ✭ 65 (-13.33%)
Mutual labels: syntax-highlighting, autocomplete
vcli: A REPL for Vertica
|Build Status| |PyPI|
A Vertica_ client that does auto-completion and syntax highlighting, based on pgcli_.
.. image:: screenshots/vcli.gif
Installation
Just install it like a regular Python package::
$ pip install vcli
You'll probably see some permission errors if you're installing it on the
system-wide Python. If that's what you want to do, you need to sudo::
$ sudo pip install vcli
To upgrade vcli, do::
$ pip install -U vcli
Usage
Connecting to a Database
::
$ vcli --help
Usage: vcli [OPTIONS] [DATABASE]
Options:
-h, --host TEXT Database server host address [default: localhost]
-p, --port INTEGER Database server port [default: 5433]
-U, --user TEXT Database username [default: CURRENT_USER]
-W, --prompt-password Prompt for password [default: False]
-w, --password TEXT Database password [default: ]
-v, --version Print version and exit
--vclirc TEXT Location of .vclirc file [default: ~/.vclirc]
--help Show this message and exit.
**Examples**
Use URL to connect::
$ vcli vertica://dbadmin:[email protected]:5433/mydb
Prompt for password::
$ vcli -h localhost -U dbadmin -W -p 5433 mydb
Don't prompt for password::
$ vcli -h localhost -U dbadmin -w pass -p 5433 mydb
Use VERTICA_URL environment variable::
$ VERTICA_URL=vertica://dbadmin:[email protected]:5433/mydb vcli
Special Commands
~~~~~~~~~~~~~~~~
::
vcli_demo=> \h
+---------------------+--------------------------------------+
| Command | Description |
|---------------------+--------------------------------------|
| \# | Refresh auto-completions |
| \? | Show help |
| \a | Aligned or unaligned |
| \c[onnect] [DBNAME] | Connect to a new database |
| \d [PATTERN] | List or describe tables |
| \dS [PATTERN] | List system tables |
| \dT [PATTERN] | List data types |
| \df [PATTERN] | List functions |
| \dj [PATTERN] | List projections |
| \dn [PATTERN] | List schemas |
| \dp [PATTERN] | List access privileges |
| \ds [PATTERN] | List sequences |
| \dt [PATTERN] | List tables |
| \dtv [PATTERN] | List tables and views |
| \du [PATTERN] | List users |
| \dv [PATTERN] | List views |
| \e [FILE] | Edit the query with external editor |
| \h | Show help |
| \i FILE | Execute commands from file |
| \l | List databases |
| \n[+] [NAME] | List or execute named queries |
| \nd [NAME] | Delete a named query |
| \ns NAME QUERY | Save a named query |
| \o [FILE] | Output to file or stdout |
| \q | Quit vcli |
| \refresh | Refresh auto-completions |
| \t | Toggle header |
| \timing | Toggle timing of commands |
| \x | Toggle expanded output |
| \z [PATTERN] | List access privileges (same as \dp) |
+---------------------+--------------------------------------+
Thanks
------
Thanks to pgcli_. Most of the hard work, especially the auto-completion part,
were already done well by the pgcli core team. vcli wouldn't be possible if it
weren't for them.
.. |Build Status| image:: https://api.travis-ci.org/dbcli/vcli.svg?branch=master
:target: https://travis-ci.org/dbcli/vcli
.. |PyPI| image:: https://img.shields.io/pypi/v/vcli.svg
:target: https://pypi.python.org/pypi/vcli/
:alt: Latest Version
.. _pgcli: http://pgcli.com
.. _Vertica: http://www.vertica.com/
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].