9 ms·
DBCLI – Modern Suite of Database CLIs
- em500 9y agoAny plans for a sqlite version?
- amjith 9y agoOne of the core devs have expressed interest in creating an sqlite version. But work hasn't started. If you would like to chip in we would be happy to support you in every which way.
- aviv 9y agoInteresting niche and approach. Thanks for pgcli btw. Good luck!
- amjith 9y agoThank you!
- git-pull 9y agoThanks Jonathan Slenders for the solid library backing these: https://github.com/jonathanslenders/python-prompt-toolkit https://github.com/jonathanslenders/python-prompt-toolkit See also: https://github.com/jonathanslenders/ptpython https://github.com/jonathanslenders/ptpython, https://github.com/jonathanslenders/pymux https://github.com/jonathanslenders/pymux, https://github.com/jonathanslenders/pyvim https://github.com/jonathanslenders/pyvim
- amjith 9y agoIndeed. Prompt-toolkit was instrumental in the design of all these tools. :)
- AtlasLion 9y agoBeen using pgcli for a while. Fantastic tool. Thanks for the numerous hours working on this!
- herewulf 9y agoInteresting. If I were still working with Oracle, I'd love to see a sqlplus replacement. It has to be one of the most braindead CLIs ever, yet is too often instrumental to getting some actual work done with the shell et al.
- oblio 9y agoI doubt that it's going to happen. People working with Oracle are generally not the kind that would start Open Source projects. If they are, also generally, they won't work with Oracle for long.
- Annatar 9y agoThankfully there are exceptions. Not everyone is trying to be hip. When one needs to build seriously bullet proof, robust systems which must handle extreme amounts of data and do it very fast, Oracle database in RAC configuration is the way to go, and a CLI SQL client is the tool to get there.
- oblio 9y agoIs there a good Oracle CLI client available somewhere, then?
- Annatar 9y agoPossibly, but I’m still stuck automating using SQL*Plus. If it just had libreadline [CURSOR UP] history functionality, it would be really powerful (the official documentation on it is 600+ pages). pgsql and Vertica databases don’t need any more client enhancements, but the one database which does doesn’t get one. Talk about a missed market opportunity!
- barrkel 9y agoUse rlwrap as another commenter mentioned.
- 9y ago
- Annatar 9y agoAnd the one database whose client needs [CURSOR UP] history and autocompletion, Oracle, isn't listed. Vertica doesn't need an added value client: her client is already pretty good out of the box.
- fiddlerwoaroof 9y agoRlwrap can be used to give history to arbitrary cli apps
- kenshaw 9y agoOr just use usql. go get -u github.com/xo/usql Autocompletion is the only feature it doesn't have compared to these, and it's significantly easier to work with, and works with more databases. Autocompletion will be done early next year.
- jacques_chester 9y agoIt appears that you are the author of this project.
- _Chief 9y agoHow about syntax highlighting? Keep up the great work on usql
- kenshaw 9y agoYes it's had syntax highlighting for about 2 months now. I haven't finished the 0.6.0 release, but if you install from source you can use it from there.
- amjith 9y ago> it's significantly easier to work with Can you please elaborate?
- kenshaw 9y agoSame command syntax as psql, so no need to learn a new tool. A single command line client that works with every database, so there's no need to have multiple binaries installed. It's a single static binary, so it can be copied and used from anywhere -- no need for endless pip dependencies.