frectonz / sql-studio

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB]
https://sql-studio.frectonz.io/
MIT License
1.51k stars 26 forks source link

Visual clipping for tables with 10+ million rows #7

Closed charlie-collard closed 1 week ago

charlie-collard commented 2 weeks ago

Hi, thanks for the cool tool! I'm seeing clipping on the y axis of the "Rows per table" bar chart for a table with ~88 million rows.

charlie-collard commented 2 weeks ago

The database isn't sensitive at all, so if you'd like me to send it over I'd be happy to (it's about 30GB), it might also be useful for testing lazy-loading the UI on other areas of the tool

frectonz commented 2 weeks ago

I was trying to fix this but seems like the chart library i'm using recharts doesn't provide a good way to solve this issue. :(

charlie-collard commented 1 week ago

@frectonz I think the tickFormatter option can be used, just tested it and created a PR :)