Feature Request: Sort tab completion by frequency

[simnim]

Not sure how easy this would be, but if sorting by frecency is possible then that'd really kick ass.

There are tab completion terms that always show up on top that I never use, and others that are in the middle that I always use. Having the tool remember what terms were most frecently used would improve user experience for databases with may schemas, tables, and columns. Off the top of my head, using an sqlite db in the users home dir could be a great way to store these terms. I haven't looked into any python frecency libraries, but a quick google search shows a few that look usable.

[j-bennet]

See also this PR that implements the feature in pgcli.

[zer09]

I vote for this.

[amjith]

After looking through the PR that implemented this feature in pgcli, it looks like it is possible but it'll take some elbow grease to get this done. Any volunteers to take this on? I'll be happy to pitch in if needed. 😄

/cc @johnksterling

[tsroten]

This sounds like a great idea. Here is another pgcli pull request that looks important for this: dbcli/pgcli#425

[j-bennet]

I'd like to give it a try.

[amjith]

Awesome! Go forth and assign the issue to yourself. 😄