[FEATURE] double click table to see a preview of the data (with ability to refresh)

[nktnet1]

Is your feature request related to a problem?

In Drizzle Studio, double clicking a table display the data as preview automatically. This is a nice UX - try here

• https://demo.drizzle.studio

Describe the solution you'd like

When double clicking a table, rather than just expanding and collapsing it, if we can see the table preview instead.

Additionally, it would be nice to have dedicated buttons to refresh schema and refresh rows in the preview like Drizzle Studio, since the data can become stale when developing/testing with other tools.

Describe alternatives you've considered

Click the 3 horizontal dots and "Select Top 50"

Use Case

When needing to visually check sample data in many tables quickly

[cevheri]

it a great idea, "When double clicking a table, we can open a new query editor and show 50 row" how does it sound?

[nktnet1]

Yes, sounds good. Drizzle Studio also supports pagination on their preview (in addition to schema reload and rows reload buttons) - might also be worth considering.

[cevheri]

https://github.com/orgs/libredb/discussions/778

[cevheri]

new scheme/object browser: #811 (comment)
also support single click top 50 rows

[cevheri]

Hi @nktnet1
I build a new schema and object browser.

The release won't be ready today (we publish releases only after conducting very detailed testing), but you can try the libredb/libredb-studio:main tag on your machine before the release.

docker pull libredb/libredb-studio:main
docker run -p 3000:3000 libredb/libredb-studio:main

The auto-generated initial password will appear in the logs.