Hacker News Reader

Hacker News

Comment by amjith | Hacker News Reader

Full thread

amjith

I'm the author of this project. I'll be happy to answer any questions.

Brief Intro: This is a command line tool that is intended as a replacement for MySQL client.

It works with MySQL, MariaDB and Percona.

It is written in Python and it works in Python 2.6 to Python 3.4.

This is a counter part to http://pgcli.com.

MyCli was funded through Kickstarter (https://www.kickstarter.com/projects/1839007321/mysql-cli)

View on HN

I tried installing it via pip on CentOS 6.6, and I get:

Traceback (most recent call last): File "/usr/bin/mycli", line 5, in <module> from pkg_resources import load_entry_point File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 2655, in <module> working_set.require(__requires__) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 648, in require needed = self.resolve(parse_requirements(requirements)) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 546, in resolve raise DistributionNotFound(req) pkg_resources.DistributionNotFound: six>=1.8

Am I missing something obvious?

I've heard it from someone else as well. I couldn't reproduce it myself.

The suggested solution was to uninstall mycli and reinstall directly from github.

pip uninstall mycli six; pip install https://github.com/dbcli/mycli/archive/master.zip

Yep, getting the same issue:

[foo@chef-solo ~]$ mycli Traceback (most recent call last): File "/usr/bin/mycli", line 5, in <module> from pkg_resources import load_entry_point File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 2655, in <module> working_set.require(__requires__) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 648, in require needed = self.resolve(parse_requirements(requirements)) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 546, in resolve raise DistributionNotFound(req) pkg_resources.DistributionNotFound: six>=1.8

Running sudo python install did the trick. I'm not sure I can really recommending anyone check this out without a working install from a package manager though.

Is there a way to have it bundled into a single file which I can scp to remote systems and need not worry about dependencies?

You could use pex which bundles up python requirements into an executable zip. I ran

    $ virtualenv PEX
    (PEX) $ pip install pex
    (PEX) $ pex mycli -e mycli.main:cli -o mycli.pex
    (PEX) $ deactivate
    $ chmod +x mycli.pex    
    $ ./mycli.pex
    Version: 1.0.1
    Chat: https://gitter.im/dbcli/mycli
    Mail: https://groups.google.com/forum/#!forum/mycli-users
    Home: http://mycli.net
    Thanks to the contributor - jweiland.net
    mysql user@localhost:(none)>

You could scp the .pex to another host that also has python installed and it should run. You can also unzip it to inspect its contents...

Very cool! Thanks!

Did you try it with memsql? Just curious... I don't see any reason why it shouldn't work.

I don't fully understand your question. If you're asking whether this client will work with memsql, then the answer is No. Unless, memsql uses mysql protocol to talk to clients.

Mycli uses MySQL adapter called PyMySQL to connect to MySQL instances. I don't think it'll work with memsql.

If you're talking about writing a similar client for memsql, then yes it is possible to do that as long as there is a Python adapter for it.

MemSQL does use MySQL protocol to talk to clients.

You're right. I didn't know that.

http://docs.memsql.com/latest/faq/#is-memsql-a-storage-engin...

I haven't personally tried it with memsql.

Reply on news.ycombinator.com