How to insert multiple rows in Web SQL Database?

Question

I have a JavaScript object with multiple rows of data and I want to insert it into web sql database. Here is how my code looks like.

for(i in rows)
{
    (function(row){
        db.transaction(function(tx) {
            tx.executeSql("INSERT INTO my_table (id, name, parent_id) VALUES (?, ?, ?)",
                [ row.id, row.name, row.parent_id ], onSuccess, onError
            );
        });
    })(rows[i]);
}

My questions about this are:

This can be done by moving outer loop inside db.transaction. Will it be better and why?
Is it possible to add multiple rows in single query like multiple values in single MySQL INSERT? Or I should not worry about this.

possible duplicate of Web SQL insert data into multiple rows — Chepech
– Chepech, Commented Apr 24, 2014 at 22:16

Kyaw Tun · Accepted Answer · 2012-11-15 01:59:25Z

3

This can be done by moving outer loop inside db.transaction. Will it be better and why?

yes. much better. 1) creating a transaction is not cheap. 2) looping async is generally bad .

Is it possible to add multiple rows in single query like multiple values in single MySQL INSERT? Or I should not worry about this.

don't worry. Multiple rows workaround are syntactic sugar. No performance benefit. Better loop it under one transaction.

Again do not loop executeSql, it is async.

answered Nov 15, 2012 at 1:59

Kyaw Tun

13.3k15 gold badges59 silver badges84 bronze badges

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

1 Comment

Saurabh Android Over a year ago

I am facing problem in this that when i insert multiple rows in db.transaction function than it only inserting last row multiple times. I agree with you that due to async it is performing this king of behavior,can you please let me know what would be the solution and if you can give any sample than it will help me out in better way.

Collectives™ on Stack Overflow

How to insert multiple rows in Web SQL Database?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related