Allow defining local indexes.

[n1k0]

Filtering and ordering being currently achieved in-memory, the performance penalty can be important in case of large datasets.

We should allow users to create indexes on fields and rely on native IDB queries to speed things up.

Suggested API:

const db = new Kinto();
const tasks = db.collection("tasks");
tasks.ensureIndexed("label", "done");

Or even:

const tasks = db.collection("tasks", {
  indexes: ["label", "done"]
});

Thoughts? @Natim @leplatrem

[Natim]

I like this idea because it helps speed up things for schemaless.

[n1k0]

Something to pay attention to, because we'll alter the store schemas by adding/altering indexes, we'll need to handle database version numbers.

[n1k0]

Note: since #315 and #318 has now landed, we should implement custom index definition so users can benefit from the performance improvement provided by leveraging idb indexes for filtering and sorting.

[leplatrem]

https://twitter.com/daleharvey/status/735062319126982658

[raevilman]

any plans for this..?

PS: Coming from DexieJS

[leplatrem]

Not really. But if someone contributes it, we would definitely provide support to ship it :)