Slide 1

Slide 1 text

MODERN COMMAND LINE

Slide 2

Slide 2 text

PGCLI HTTP://PGCLI.COM ! MYCLI HTTP://MYCLI.NET

Slide 3

Slide 3 text

DEMO

Slide 4

Slide 4 text

INSTALLATION • Python: • pip install pgcli • pip install mycli • Brew: • brew install pgcli • brew install mycli

Slide 5

Slide 5 text

AUTO COMPLETION

Slide 6

Slide 6 text

TABLES

Slide 7

Slide 7 text

COLUMNS

Slide 8

Slide 8 text

ALIAS

Slide 9

Slide 9 text

SYNTAX HIGHLIGHTING

Slide 10

Slide 10 text

MULTI-LINE

Slide 11

Slide 11 text

SPECIAL COMMANDS

Slide 12

Slide 12 text

MODERN CLI • ptpython: https://github.com/jonathanslenders/ptpython/ • pgcli: https://github.com/dbcli/pgcli/ • mycli: https://github.com/dbcli/mycli/ • wharfee: https://github.com/j-bennet/wharfee • saws: https://github.com/donnemartin/saws • pyvim: https://github.com/jonathanslenders/pyvim

Slide 13

Slide 13 text

PTPYTHON Awesome Python REPL

Slide 14

Slide 14 text

WHARFEE docker shell

Slide 15

Slide 15 text

SAWS Super charged AWS shell

Slide 16

Slide 16 text

PYVIM Vim clone in Python

Slide 17

Slide 17 text

LIBRARIES

Slide 18

Slide 18 text

PROMPT TOOLKIT • CLI toolkit with auto-completion. • Github: https://github.com/jonathanslenders/python-prompt-toolkit • Examples: https://github.com/jonathanslenders/python-prompt- toolkit/tree/master/examples • Tutorial: https://github.com/jonathanslenders/python-prompt- toolkit/tree/master/examples/tutorial • Docs: http://python-prompt-toolkit.readthedocs.org/en/latest/

Slide 19

Slide 19 text

PYGMENTS • Syntax highlighting • http://pygments.org/

Slide 20

Slide 20 text

FUZZY FINDER • Fuzzy find library. • https://github.com/amjith/fuzzyfinder • Blog: http://blog.amjith.com/fuzzyfinder-in-10-lines- of-python • Docs: http://fuzzyfinder.readthedocs.org/en/latest/

Slide 21

Slide 21 text

CLICK • Command line arguments builder. • CLI helper methods (colored output, pager etc). • http://click.pocoo.org/

Slide 22

Slide 22 text

CONTACT • Twitter: @amjithr • Email: [email protected] • Gitter: • https://gitter.im/dbcli/pgcli • https://gitter.im/dbcli/mycli