Forum ‹ BigDB ‹ Sorting and browsing in the Big DB interface

[actionsprite]

Are there any options to sort and browse the Big DB rows?

Seeming as we can potentially store numerous entries (it is 'BIG' db after all) I'm finding it limiting to only see a handful of entries per page with only next/previous options to browse.

Is it possible to add any sort of sorting (via date, name etc?) or at least some pagination to allow us to jump straight to the end of a set of rows, or anywhere in between.

This would make Big DB much more usable as a viable database, especially when it comes to testing/investigating any anomalies - apologies if this functionality is already available and I've missed it.

[Benjaminsen]

Creating indexes allows you to sort sort and search in your data.

[actionsprite]

Hi, thanks for replying, does this work in the online interface? How many results does it show per page and is there pagination to easily browse?

[Benjaminsen]

Hi, thanks for replying, does this work in the online interface? How many results does it show per page and is there pagination to easily browse?

Yep it does work in the online interface. The pageination works as it currently does with 5 results per page.

[actionsprite]

Would it be possible to add pagination to jump to a certain page of results? For instance if you're wanting to see the 100th result, you'd have to currrently hit "next" 20 times...

[Henrik]

Heya,

The BigDB admin interface can only do the same things that are possible in the BigDB API, so paging is out, since that requires knowledge of how many objects there are in total or in an index, and this is not something that we have.

This is also why you need to create and index if you want to sort your table in a certain way, since that is the only way to get data in that way.

However, what we can do is make an option to change the pagesize, that should make it a bit easier to use the interface when going over large amounts of objects.

[actionsprite]

Hi Henrik, That would definately be helpful.

[batiali]

+1 to what actionsprite offered, please
5 is a reaaaaly small integer.

[Henrik]

There we go, you can now choose the pagesize when browsing your BigDB tables.

[actionsprite]

Thanks Henrik