[FEATURE REQUEST] GUI improvements

[a2nt]

• Run SELECT * FROM Table LIMIT 1000 on table click
• Show/Hide SQL query field
• Inline table editor
• Sort tables on header click

[krolow]

@a2nt would you like to contribute for those improvements?

Run SELECT * FROM Table LIMIT 1000 on table click

I think is not the best default as some tables might contain a lot of rows, and react is not good in render a lot of items

Show/Hide SQL query field

Sounds good, we are glad to receive it as a PR

Inline table editor

I'm not sure if I understand this

Sort tables on header click

You mean sort only the elements that are visible in the current query, or actually change the query when click in one row?

[a2nt]

@krolow

I think is not the best default as some tables might contain a lot of rows, and react is not good in render a lot of items

Well, I mean run select query on click

Inline table editor

It will be nice to edit data fields on double-click. The same way as PhpMyAdmin and Sequel Pro does. So after editing UPDATE + SELECT query will be made.

You mean sort only the elements that are visible in the current query, or actually change the query when click in one row?

Query needs to be changed