Here's another implementation of a table that can handle a large amount of rows: http://jarwol.com/aTable. I created it a few years ago as a need for another side project I was doing.
Show HN: Smart-table-scroll – Browser-based tables with 1M rows
11–19 of 19 posts
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#12What would be your use case? Apart from this being a nice feat of technology and the possibility of loading the data asynchronously, in what scenario would it be practical to present 1K+ rows of data to a user? It's infeasible or at least very impractical to examine them by hand - some sorting/filtering possibility is necessary for large datasets and if your filters still return 1K+ rows you could have filtered on so…
Online spreadsheets. The end users are conditioned already on how to navigate with find, home, end, etc. Edit: Seems like it might break on-page find though, right?
Most users don't use on-page find though. Facebook use this "lazy-load, eager-unload" for their news feed. It's a bit annoying, but obviously the alternative is your browser screeching to a halt.
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#13What would be your use case? Apart from this being a nice feat of technology and the possibility of loading the data asynchronously, in what scenario would it be practical to present 1K+ rows of data to a user? It's infeasible or at least very impractical to examine them by hand - some sorting/filtering possibility is necessary for large datasets and if your filters still return 1K+ rows you could have filtered on so…
Financial trading applications often need big grids of data - take a look at openfin...
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#14What would be your use case? Apart from this being a nice feat of technology and the possibility of loading the data asynchronously, in what scenario would it be practical to present 1K+ rows of data to a user? It's infeasible or at least very impractical to examine them by hand - some sorting/filtering possibility is necessary for large datasets and if your filters still return 1K+ rows you could have filtered on so…
There was just a post on django.reddit.com asking how to display over 18k rows. Of course the developer knew this was not practical but business demanded it.
https://www.reddit.com/r/django/comments/3hlhgq/best_way_to_... asking for a
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#15Have a look at:
https://github.com/iljamaas/vanilla-js-smartscroll
No jQuery needed, with eventing and keyboard navigation
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#16One thing a lot of fixed header plugins dont do well is make sure that the header cells properly line up with body cells. Things usually break down as soon as you start resizing the window, adding your own custom styles, hiding columns... etc.
How well does this plugin handle that? I noticed you didnt use a table, so perhaps you dont really care about styling it like one either.
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#17Something similar from Airbnb http://airbnb.io/infinity/
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#18Nice, reminds me on the table views in iOS.
Yep, table views, collection views, stack views, etc under both iOS and OS X have been doing this for ages now. A bonus of this setup is that it forces you to separate your data source from your view, doing sorts and filters and whatnot independent of the table view. It keeps things neat and clean.
I’m not a web guy but most sorting table implementations on the web I’ve seen do the opposite, instead treating the table contents as the data to be manipulated. While this works it’ll cause you trouble in the long run and if nothing else will negatively impact performance. With the cell reuse model, you instead perform your transformations on the original data (free of markup gunk) and ask the table view to update itself to match the data source. Under iOS, this is done through UITableView’s reloadData method. You never directly interact with the table view’s recycling functions.
Re: Show HN: Smart-table-scroll – Browser-based tables with 1M rows
#19What would be your use case? Apart from this being a nice feat of technology and the possibility of loading the data asynchronously, in what scenario would it be practical to present 1K+ rows of data to a user? It's infeasible or at least very impractical to examine them by hand - some sorting/filtering possibility is necessary for large datasets and if your filters still return 1K+ rows you could have filtered on so…
If you are working with unfamiliar data it is very useful to be able to view a huge number of rows in one go. It is the kind of tool that coders all have and use but is unavailable to the general public. Of course excel should be able to quickly scroll through millions of rows if that is what the user wants. Filtering maybe the next step but you need to feel out the data first to know what to filter.
Also, it makes a certain sense to over-engineer this kind of technology to give other elements of the stack some leeway. Lazy loading is great but so is pre-emptively loading data in case latency rises.