3 ms·

I have been looking for a faster alternative to pgcli [1] ( with features like auto-complete for table names and columns) and was getting excited. Sadly this

I have been looking for a faster alternative to pgcli [1] ( with features like auto-complete for table names and columns) and was getting excited. Sadly this is "just" a plain old CLI. Also: had to install with `go get -tags "no_sqlite3" -u github.com/xo/usql` since the sqlite3 package did not build. [1] https://www.pgcli.com/ https://www.pgcli.com/

kbd 7y ago
It’s at a disadvantage vs pgcli and mycli because they’re in Python and have access to the excellent Prompt Toolkit (which also powers ipython), while usql is in Go. I started using mycli recently and it actually made me joyful about how good it was. DBeaver is really good but for most things I’d prefer a cli, and the autocomplete actually makes it faster to use for many things.
- brigandish 7y ago
  I've not used Prompt Toolkit (or usql) but am very interested in making better cli, what makes Prompt Toolkit so good?
  - kbd 7y ago
    Here's a presentation at PyCon 2017 by the author of pgcli and mycli that's a great answer to your question: https://www.youtube.com/watch?v=hJhZhLg3obk https://www.youtube.com/watch?v=hJhZhLg3obk
    - brigandish 7y ago
      That was really interesting and fired my imagination! Thanks.