How do I store JSON objects in indexedDB?

Question

my return json file looks like this:

var data = [{"col1":"value1","col2":"value1","col3":"value1"},{"col1":"value2","col2":"value2","col3":"value2"},{"col1":"value3","col2":"value3","col3":"value3"}];

without JSON.stringify data looks like this:

[object Object],[object Object],[object Object]

but with it the result.length is not 5 but the total number of characters of the string and that way I cant do the loop

var result = JSON.stringify(data);
for(i=0; i<result.length; i++){
var transaction = db.transaction([STORE], IDBTransaction.READ_WRITE);
var put = transaction.objectStore(STORE).put(result);
};

Don't stringify and In line 4 put(result[i])

G Herbowicz
– G Herbowicz

2022-02-04 06:09:44 +00:00
Commented Feb 4, 2022 at 6:09 — G Herbowicz
– G Herbowicz, Commented Feb 4, 2022 at 6:09

Mark Pieszak - Trilon.io · Accepted Answer · 2012-09-27 14:16:19Z

5

var data = [{"col1":"value1","col2":"value1","col3":"value1"},{"col1":"value2","col2":"value2","col3":"value2"},{"col1":"value3","col2":"value3","col3":"value3"}];

If you are trying to store each OBJECT, then don't stringify it or anything, it is already in perfect form. Change your for() loop to loop through the data objects.

Kristof Degrave had a good point to put these outside of the actual for loop for performance reasons.

    var transaction = db.transaction([STORE], IDBTransaction.READ_WRITE); 
    var objstore = transaction.objectStore(STORE); 

    for (i = 0; i < data.length; i++) { 
        objstore.put(data[i]);
    }

edited Sep 27, 2012 at 14:16

answered Sep 26, 2012 at 17:37

Mark Pieszak - Trilon.io

68.3k15 gold badges84 silver badges96 bronze badges

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

8 Comments

Ruben Teixeira Over a year ago

Yes, working!!! (I forgot to write the "[i]" in here) I was trying everything like: eval(), JSON.stringify() and JSON.parse() and didn't try it direct and with the loop... Thanks a lot mcpDESIGNS! Cheers.

Kristof Degrave Over a year ago

I would pull the transaction and the object store part outside the for loop, this will increase the performance.

Ruben Teixeira Over a year ago

hum... what do you mean Kristof? like calling an external function inside the loop to add each object? wouldn't that be even more circular?

Mark Pieszak - Trilon.io Over a year ago

Yeah it sounds like it needs each object inserted one at a time right?

Kristof Degrave Over a year ago

Now you are creating a transaction and an objectstore object for every object you want to store. If you do this outside the for loop you will create it once and do the puts all in one transaction. Do it like this: var transaction = db.transaction([STORE], IDBTransaction.READ_WRITE); var objstore = transaction.objectStore(STORE); for(i = 0; i < data.length; i++){ objstore.put(data[i]); }

|

Yuliam Chandra · Accepted Answer · 2014-09-19 07:28:47Z

5

For new visitors, suggesting a tad of modification: IDBTransaction.READ_WRITE has been deprecated so use "readwrite" instead.

Resource: https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API/Using_IndexedDB Reference:

Older experimental implementations use the deprecated constant IDBTransaction.READ_WRITE instead of "readwrite".

Also, to reduce the loc (which I mostly prefer), use:

var objstore = db.transaction([STORE], "readwrite").objectStore(STORE); 
for (i = 0; i < data.length; i++) { 
    objstore.put(data[i]);
}

edited Sep 19, 2014 at 7:28

Yuliam Chandra

14.7k12 gold badges56 silver badges70 bronze badges

answered Sep 19, 2014 at 7:08

sandiejat

3,2711 gold badge22 silver badges31 bronze badges

Collectives™ on Stack Overflow

How do I store JSON objects in indexedDB?

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related