escape a string in node js to insert it in a sqlite3 database

Question

I'm using the external module sqlite3 to write and read my db.

I want to store a very large description in my db which can contains some particular character.

How can I correctly escape the string?

Denys Séguret · Accepted Answer · 2015-05-06 15:04:57Z

16

As with any DB API in whatever language, the first rule is to never concatenate strings to build the queries by escaping the inputs but to let the driver do the escaping:

db.run("INSERT INTO mytable VALUES (?)", myBigUnescapedString);

answered May 6, 2015 at 15:04

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

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

Collectives™ on Stack Overflow

escape a string in node js to insert it in a sqlite3 database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related