Any easy way to create multi-field indexes, not just single field?

[mariusk]

No description provided.

[alekseykulikov]

Treo supports multi as a part of addIndex: https://github.com/alekseykulikov/treo#schemaaddindexname-field-opts

var treo = require('treo');
var schema = treo.schema()
.version(1)
  .addStore('magazines', { key: 'id' })
  .addIndex('byWords', 'words', { multi: true });

Is it what you need?

[mariusk]

I do not think so. I'm under the (possibly wrong) impression that indexeddb allows indexes based on multiple field values, not just a named array field.

[alekseykulikov]

Ah, probably you mean something like: http://stackoverflow.com/a/16503172

schema.addIndex('compoundIndex', ['field1', 'field2']);

Currently treo does not allow to do this, because it expects string as a key field: https://github.com/alekseykulikov/treo/blob/master/lib/schema.js#L90
Also probably ranges will not work too.

I will mark it as a feature for next release.

[mariusk]

Another thing to add to the feature list might be an easy way to call .all on an index or similar, to iterate by a certain index. Alternatively, add interfaces (or document) how to access the underlying cursors to do it.

[alekseykulikov]

Yes, support of ranges in store.all could be a good addition.
Internal store.cursor is also available, but has weak docs. So far as example you can check: https://github.com/alekseykulikov/treo/blob/master/examples/find-in-plugin.js

[robertfall]

We've just run into this issue. Is there a way to drop down to raw indexeddb to add the index with multiple fields until it's been added to treo? 😕

[alekseykulikov]

treo@0.5.0 adds support for this functionality.

[lukerandall]

Thanks for the quick response. Much appreciated!

[robertfall]

Indeed! Didn't expect this to land so soon. Thanks for your work! 👍

[alekseykulikov]

You're welcome, guys!