Apologies if this comes across as a troll post but I'm trying to navigate the map db page on mobile, and its hopeless. Tantalising help comments at the top hint at great things, but none of them materialise. All I want is to be able to sort the table by user rating. Which column is that, anyway? I see a circle with a line through it, ‘M’, ‘#’, alpha and heart symbol but nothing to explain what these mysterious runes refer to. Could there be some sort of ‘lite' version of this page which is more compatible? It doesn't need a Turing complete filtering engine but some basic sorting capability would be nice. Peace and prosperity, mush love to all.
You can hold your mouse on any of the icons to know what they mean. I guess it wouldn’t really be possible to do this on mobile. Their meanings are:
⌀ - Average rating
M - Median rating
# - Number of ratings
α - Weighted order
- Your rating
It looks like ordering is indeed broken though. You used to be able to click any of the cells in the top row, to order the table contents in ascending / descending order.
Edit: Nevermind, it’s been changed and is mentioned on the page itself. You need to access the page through this URL instead: https://www.quaddicted.com/db/v2/?loadjstablefilter=true
1 Like
Thanks @Rotfish!
Any help on making a responsive mobile design, CPU-friendly client-side table sorting and CPU-friendly client-side table filtering would be highly welcome!
I get and share the frustration.
Thanks. The updated URL does indeed re-enable sorting. But the first time I tried it (before posting) it didn't work potentially because I copy pasted it wrong. Can’t you add a hyperlink instead of asking people to manually edit the URL?
It isnt immediately obvious that clicking on the column header applies the sort, there are no visible up and down arrows indicating this.
Table rendering is still janky and weird like the right-most columns are still hidden when I scroll sideways, I have to rotate the phone 90deg to see them.
Can you add some text at the top to tell people what the abbreviations mean?
Sadly I dont have any web development expertise but most of the above are simple UI changes that although useless to me now (because you've already explained it to me) would certainly help anyone coming here for the first time.
i'm not sure we can fix janky table rendering because its simply a lot of data. its just a lot for the browser engine. i have a decent workstation and my cpu still struggles if i resize the window or scroll too fast.
maybe there could be a simpler page (separate to the db dump) focused on browsing, which removes some information, like no tags at all, no sha256 checksums and maybe even remove the filename. that would certainly remove a lot of markup and clean up some horizontal space.
also, all of the table headers already have title tags which show a popup on mouse hover, so it might just be that the page is not made with phones in mind.
where can i download a copy of the information in the big map page? as far as i can tell, the api doesn't have average or median rating, number of ratings, weighted order and no release groups. if i had this info i could whip up something quickly, but i don't want to scrape.
I’m not sure it’s a performance issue, in my case at least because it is still responsive and smooth. Its a compatibility issue.
what does this even mean