Adding this feature is not an issue but it will be very slower since IndexedDb does not allow nested indexing which means for any nested query jsstore will have to loop through all the records & filter.
I haven't come to any decision yet, just trying to figure out if this should be added or not & if added can i do something for indexing or something like that.
there is no example, but its simple. Just fetch all data in a variable before updating & then update.
Check this out - https://jsstore.net/tutorial/change-table-design/
idbSorting. Check out the doc - https://jsstore.net/tutorial/order-by/
@wideweide there is no fixed practice - the query can take time based on amount of data & of course more filtering (where query) means more time.
keyPath helps when you have more data on that indexes otherwise waste of resources. So keep experimenting with diff query & take whatever suits you.
But it will take less time if first where column will have less data, so if less data it needs to filter for less data & thus faster. Hope i m making sense.
I will document these out. thx.