Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
amjith
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
11 ms
·
61.
▲
by
amjith
11y ago
I'm the author of the tool. I had posted this yesterday linking to the home page. http://mycli.net I guess a few people didn't see it. :) Discussion Thread: https://news.ycombinator.com/item?id=9975022
62.
▲
by
amjith
11y ago
It still does auto-complete the DROP TABLE and DROP DATABASE, but it will ask for confirmation before running it.
63.
▲
by
amjith
11y ago
If you have 'less' on your system then it should work because I'm manipulating the options that are passed into less. I'm setting the less options here: https://github.com/dbcli/mycli/blob/
64.
▲
by
amjith
11y ago
Can you tell me which OS you're using? In Linux and OS X the less command should keep the output in the screen after you press 'q'.
65.
▲
by
amjith
11y ago
Thank you for reporting the missing keys. I had them as <C-r> and <F3> but it was misinterpreted as html tags. It is fixed now. I'm not sure what you mean by view the results without re-running the query. Does scrolling not
66.
▲
by
amjith
11y ago
Yes! Python-prompt-toolkit has made it tremendously easy to write programs like mycli and pgcli. The author has done an excellent job of keeping the APIs simple and intuitive. It also helps that he's a good OSS maintainer (responsive a
67.
▲
by
amjith
11y ago
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.
68.
▲
by
amjith
11y ago
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 t
69.
▲
by
amjith
11y ago
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/dbc
70.
▲
by
amjith
11y ago
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
71.
▲
Show HN: Mycli – A CLI for MySQL with auto-completion and syntax highlighting
(mycli.net)
106 points
by
amjith
11y ago
|
29 comments
72.
▲
Hask: Haskell language features and standard libraries in pure Python
(github.com)
11 points
by
amjith
11y ago
|
0 comments
73.
▲
by
amjith
11y ago
Redshift is not officially supported since I'm targeting Postgres 9.x. But there is some work underway to add support for Redshift. https://github.com/dbcli/pgcli/issues/18
74.
▲
by
amjith
11y ago
There is no native support for ssh port forwarding. But I do support connecting via a socket.
75.
▲
by
amjith
11y ago
I'm planning to add confirmation for those commands to make sure people don't accidentally drop something they don't intend to.
76.
▲
by
amjith
11y ago
I don't think Vim's autocompletion can suggest table names and column names from the current database. I think the advantage of this tool is in using the metadata from the database to suggest relevant completions instead of mere k
77.
▲
by
amjith
11y ago
I used licecap ( http://www.cockos.com/licecap/ ) to create that gif.
78.
▲
by
amjith
11y ago
That's the keybindings to use. For example when emacs mode is selected, you can use C-a to jump to home or C-e to jump to the end of the line. If it is changed to Vi mode then you can hit escape to go to normal mode and then use '
79.
▲
by
amjith
11y ago
Done! :)
80.
▲
by
amjith
11y ago
Yes. You can toggle the multi-line mode by pressing F3. You can also make that permanent by editing the config file in ~/.myclirc In the multi-line mode a semi-colon signifies the end of a query.
81.
▲
by
amjith
11y ago
That is a bug. I've filed an issue on your behalf. https://github.com/dbcli/pgcli/issues/283 Thank you for catching that.
82.
▲
by
amjith
11y ago
I was following the design philosophy of fish shell http://fishshell.com/docs/current/design.html#design-overvie... Especially these two: * Configurability is the root of all evil * The law of discoverability
83.
▲
by
amjith
11y ago
Can you tell me which version of pgcli you're running? Can you try upgrading? \x is implemented and available in the latest version. The ';' enter bug is also fixed in the latest version. We're still slowly adding more o
84.
▲
by
amjith
11y ago
I'm the author. I'm hoping to go public with the MySQL version before the end of this month. So a week or so. :)
85.
▲
Colorful docker management tool written in Python (with auto-completion)
(dockercli.com)
5 points
by
amjith
11y ago
|
0 comments
86.
▲
by
amjith
11y ago
I'd love to, but unfortunately I don't have Windows or Excel. :( I was curious because I wrote pgcli ( http://pgcli.com ) which does context-sensitive auto-completion. So I was wondering if there was a better way to do i
87.
▲
by
amjith
11y ago
How does the autocompletion work? Is is context sensitive to suggest only column names after the 'WHERE' clause or will it suggest 'tables and columns'?
88.
▲
Show HN: FuzzyFinder – in 10 lines of Python
(blog.amjith.com)
10 points
by
amjith
11y ago
|
0 comments
89.
▲
Excited about Pycast – Weekly Python Screencasts
(blog.amjith.com)
3 points
by
amjith
11y ago
|
0 comments
90.
▲
by
amjith
11y ago
Zoom/Unzoom is now part of default tmux. <bind>z So you can remove this line from your config: https://github.com/jbnicolai/tmux/blob/master/.tmux.conf#L98
More ›