I’ve been developing pgcli for a few months now.
It is now finally live http://pgcli.com.
It all started when Jonathan Slenders sent me a link to his side-project called python-prompt-toolkit.
I started playing around with it to write some toy programs. Then I wrote a tutorial for how to get started with prompt_toolkit https://github.com/jonathanslenders/python-prompt-toolkit/tree/master/examples/tutorial.
Finally I started writing something more substantial to scratch my own itch. I was dealing with Postgres databases a lot at that time. The default postgres client ‘psql’ is a great tool, but it lacked auto-completion as I type and it was quite bland (no syntax highlighting). So I decided to take this as my opportunity to write an alternate.
Thus the creatively named project ‘pgcli’ was born.
Details about pgcli.com:
It is built using pelican a static site generator written in Python.
It is hosted by Github pages.
The content is written using RestructuredText.
Inspiration:
The design inspiration for the tool comes from my favorite python interpreter bpython.