Love the site design. Excited to try it out.
1,042 karma · joined May 13, 2008
* Creator of pgcli and mycli.
amjith.r at gmail.com
@amjithr
Are you part of club fish? I bet the folks in the discord channel would love this.
Imports data from strava and lets me search and compare multiple rides.
The trail name detection only works in SantaCruz (CA) area.
> Typesense was relatively strict with matches compared to other engines.
Perhaps an example to clarify the statement?
So rewarding to hear this. Cheers!
https://github.com/dbcli/pgcli/blob/master/changelog.rst
What feature are you waiting for? I can talk to the project lead to see if we can push out a new release if needed.
We have a large set of tests, but the coverage is no where close to the level that SQLite has.
LiteCLI is part of that org. So you can think of it as a clone of mycli that happens to work with SQLite.
The code base is largely similar between mycli and litecli. The changes are to support the SQLite backend and to support the dot commands (like .tables, .mode etc).
So the feature set should be same.
The DBCLI tools are not created by a single individual (anymore). We have a team of core devs and the lead maintainer for pgcli, mycli and litecli are all different people.
We use `less -XRF` by default. You can change this to whatever you want via the config file `~/.config/litecli/config`. Just uncomment the line that says `# pager = "less -SXRF".
Adding the `-S` to the list of options will make it much better. It will not wrap long lines but instead it will enable horizontal scrolling (using arrow keys). Check for pager section on this page for some details: https://litecli.com/output/
The other option is to set the `auto_vertical_output = True` in the config file.
This option will cause results to be displayed vertically if they are too wide for the current window.
Code: https://github.com/dbcli/litecli
It is based on the pgcli/mycli tools for Postgres and MySQL. It is the newest addition to the https://www.dbcli.com suite of tools.
usql is a great tool if you're familiar with Postgres' psql client and wish you could use it for other databases like MySQL, Cassandra etc.
dbcli tools are designed to preserve the usage semantics of the existing tools but improve on them by providing auto-completion. For instance you can use `\d` in pgcli and `SHOW TABLES` in mycli. This was a conscious decision to make pgcli and mycli drop in replacements for of MySQL and psql. I was also working under the assumption that people rarely use multiple databases, you're either a postgres shop or a MySQL shop. If you have a mix of both, there is a good chance that not a single person is interacting with both of them on a daily basis. You have different teams using different databases. But my reasoning there could be flawed.
There is nothing stopping someone from adding an adapter to the usql tool to make it behave like MySQL (because they like the mysql client better) based on a command line argument, for instance.
I didn't find your writing insufferable. I've written tongue in cheek (or over the top) posts about my projects in the past. If they can't see the humor and the usefulness of the project, their loss.
Thank you for creating Glom and thank you for posting it on HN. Count me in as one of your users.
blog: http://blog.amjith.com/fuzzyfinder-in-10-lines-of-python
library: https://github.com/amjith/fuzzyfinder
I haven't done any benchmarking to check the performance. Feedback welcome.
Can you please elaborate?
Thank you for leading the charge on modern command line design.
So naturally he was a big proponent of Django and his stack was written completely in Django.
But you bring up a good point. I'm not mired by maintaining legacy, so I could take this as an opportunity to educate users about the \x auto by enabling it as default.