sql-studio icon indicating copy to clipboard operation
sql-studio copied to clipboard

Feature request: Add paging to the tables and GeoData helpers

Open YohannesTz opened this issue 5 months ago • 1 comments

Thank you for this wonderful tool! I've been using it lately to analyze some humongous (at least by my standards 😅) SQLite files, and it has been holding up quite well. I've seen no performance degradation, but I have run into a rendering issue. Specifically, I was working on a ~25MB file with two tables—one for metadata and another for tiles, which has thousands of rows.

What I'd love to see:

  • The ability to page through items so it doesn’t try to render everything at once and hog the browser.
  • A few utilities/helpers for geo data exploration (especially for MBTiles and PBF files since they're raw SQLite files).

Helpful resources:

MBTiles schema: https://github.com/mapbox/mbtiles-spec/blob/master/1.3/spec.md Sample MBTiles: https://data.maptiler.com/downloads/tileset/osm/

Thanks! 🙏

YohannesTz avatar Sep 06 '24 19:09 YohannesTz