I'm the author of this project. I'll be happy to answer any questions.<p>Brief Intro:
This is a command line tool that is intended as a replacement for MySQL client.<p>It works with MySQL, MariaDB and Percona.<p>It is written in Python and it works in Python 2.6 to Python 3.4.<p>This is a counter part to <a href="http://pgcli.com" rel="nofollow">http://pgcli.com</a>.<p>MyCli was funded through Kickstarter (<a href="https://www.kickstarter.com/projects/1839007321/mysql-cli" rel="nofollow">https://www.kickstarter.com/projects/1839007321/mysql-cli</a>)
This is really cool. I wanted to write an interactive input module for sqlite and I really struggled with GNU readline. It looks like I should try it again using python-prompt-toolkit. My use case would be something different than writing SQL statements, my module would let you create interactive, autocompleting input forms. I usually struggle inputting student exam scores into large spreadsheets and I want to replace that with sqlite.<p>And thanks for this one:
<a href="https://github.com/jonathanslenders/python-prompt-toolkit/tree/master/examples/tutorial" rel="nofollow">https://github.com/jonathanslenders/python-prompt-toolkit/tr...</a>
I gave it a spin. Seems pretty useful. Is there a way to view the last result again without re-running the query?<p>Also the keybindings are missing from the docs. For example on <a href="http://mycli.net/multi-line" rel="nofollow">http://mycli.net/multi-line</a> it says "You can enable multi-line mode by pressing key" but doesn't say which key to press. And on <a href="http://mycli.net/history" rel="nofollow">http://mycli.net/history</a> it says "So press and then start typing your search term to see the queries", again doesn't say what to press.
Looks really great! I think you should highlight better that it support fuzzy search, as I had to dig deep into Docs->Auto completion to find it (was about to suggest it to you).<p>Good luck with it!
Looks nice. Will give it a proper test drive soon.<p>Am currently using:
<a href="http://ewaters.github.io/altsql-shell/" rel="nofollow">http://ewaters.github.io/altsql-shell/</a><p>Software that few people know about.Worth others trying out too.<p>The data world really does need these more sane solutions.