Make table of tables sortable

[artfulrobot]

The list of tables is not sortable; click a header and it just selects all rows (surprise!).

My use case: I wish to sort tables by their number of rows.

But feasibly it's useful to be able to sort most tabled results by any column. I always found this a very useful feature in phpmyadmin.

Bonus: filterable is another great feature I use in phpmyadmin on dbs with many tables.

Screenshot below shows a table of tables, sorted by row count, and filtered by "civicrm" so showing just those tables.

(haha, so phpmyadmin's implementation seems to fail on sort and filter; I'm sure adminer can do better!)

[hjsleijster]

For filtering, you can use this plugin: tables-filter

Or: use Ctrl-F to search and then hit Ctrl-enter to follow the focused link. In Chrome that is, in Firefox hit Esc and then Enter.

[artfulrobot]

I did not know about plugins for adminer, thanks, I'll take a look. I was aware how to use my browser's find function ;-)

I think the issue still stands - useful to be able to sort to find things like biggest/empty tables etc.

[hjsleijster]

It was the "Ctrl-enter"-part I thought it might be useful :)

I agree about your idea! I specifically like to sort on table size and index size.

[vrana]

This is a reasonable feature request. The only issue is that getting all the numbers can take a long time and thus Adminer retrieves it asynchronously. So the table is first printed without the numbers and thus couldn't be sorted. Sorting it only after the data arrives would make the rows jump around which I absolutely hate.

The only solution I see is that the sorting would be done only client-side and page refresh would reset it. Please let me know if you have other ideas.

@hjsleijster, wow, even after decades of using browsers, I learn something new!

[artfulrobot]

@vrana client side sort works for my use case because there doesn't seem to be any pagination on the list of tables - pagination would make client side sort misleading.

[vrana]

The code now takes the slow path if there's sorting and the fast path without it.