How to create index on array element in indexeddb

Question

I have an object,

var _data = {
        teacher : {
            name : "Mack",
            subject : "Maths"
        },
        Student : [{
            name : "Alex",
            stud_id : 1
        },{
            name : "Jack",
            stud_id : 2
        },{
            name : "Mark",
            stud_id : 3
        }]

}

I want to create index on stud_id, how can I create?

Aaron Powell · Accepted Answer · 2014-01-15 00:09:42Z

4

What I would do that is to have two separate object stores inside of your database, one which represents teachers and one which represents students.

Then I'd store a teacher object like:

{
    name: 'John Smith',
    subject: 'Maths',
    students: [1,2,3,4,5]
}

Then I'd have a store for students like:

{
    id: 1,
    name: 'Jane Doe'
}

I'd then have an id key path in both stores (autogenerated or not, depending on whether it syncs somewhere) so you have a unique identifier of what the data is.

Finally you can create an index on the students property of a teacher and set the multiEntry flag to true so that it is known to be an array and you can query the object store on it as an array, see here for more info on multiEntry indexes.

Note: At time of writing IE10 & IE11 do not support multiEntry indexes in IndexedDB.

answered Jan 15, 2014 at 0:09

Aaron Powell

25.1k18 gold badges102 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kyaw Tun · Accepted Answer · 2014-01-03 09:50:50Z

0

Currently it is not possible. Element of keyPath must be string.

answered Jan 3, 2014 at 9:50

Kyaw Tun

13.3k15 gold badges59 silver badges84 bronze badges

1 Comment

User 780611 Over a year ago

If I want to apply the index on array element which is string. In the object above Student array has name property, can I apply index on name, and how?

Collectives™ on Stack Overflow

How to create index on array element in indexeddb

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related