Feature Request: Keep tables Alphabetical after Search

[nawlbergs]

MySql - TablePluss 2.11.2

Im coming over from Sequel Pro because its no longer maintained.. They have a great UI...

That said, one thing that is super annoying coming from Sequel Pro is that when I do a search for a table in TablePlus... the result ordering is all scrambled... I understand its trying to return them in a google-like smart fashion of what matched the most... but when I type user into the search... it actually makes finding the table I want much harder if I have 10 tables with the word user in it...

Im requesting the search act more like a filter - which just returns the results in alphabetical order (or a setting to allow it to return that way.)

[lfolco]

Please please fix this. The current sort order makes no sense.

[keithslater]

I brought this up a long time ago and he made a build for us to test that did this, which is obviously outdated now. Perhaps this could be added as an option? It's the only thing that really drives me crazy about TablePlus.

From what I can tell, the results aren't scrambled, they're in order by the length of the table name then alphabetical (which is strange). You can see it better if you have a lot of tables that start the same:

I do think beyond starting with the same word, it does try to return results in order of some scoring system, not sure. But what I would like is if it all starts with the same characters, it should at least sort alpha instead of the length of the table name.

[huyphams]

Hey @keithslater please try to input the ^project TablePlus does support regex so there are a lot of hidden options:

• Default: fuzzy
• "keyword" : search with contains (double quote the keyword)
• ^prefix
• suffix$
• A|B : A or B

[huyphams]

I think we can close this issue because the ^prefix solved it! Thanks all.

[nawlbergs]

Yea.. I don't know that having users type regex is a good fix for what, in my mind, should be a default. Also, most users probably don't know that regex is an option... then will have to to google search or come to this issue to find a solution.

[huyphams]

Sure thanks, we should make an in-app tutorial here (for the first time user click on the search field, TablePlus will show that popup). and maybe an option to change the default search behavior.

[nawlbergs]

is the regex mac only? - i just tried on the windows build with no luck.

[huyphams]

We will support it in the next update (if you want, we can send you the hotpatch).