Node-sqlite3: best practice use node-sqlite3 in express app
Hi,
what is a good practice to use node-sqlite3 in an Express App? do we have to open and close db for every insert? thanks,
Angelo
angelochen960
>All comments
No, you open the db when you start the server, then you execute statements whenver you need to. When the app shuts down (e.g. by intercepting SIGINT or SIGKILL), you close the DB handle.
kkaefer
on 29 Apr 2014
👍4
Was this page helpful?
0 / 5 - 0 ratings
Related issues
kevinmannn
路
40Comments
milu2003
路
16Comments
j-berman
路
20Comments
hersoncruz
路
27Comments
sushantdhiman
路
20Comments
Most helpful comment
No, you open the db when you start the server, then you execute statements whenver you need to. When the app shuts down (e.g. by intercepting SIGINT or SIGKILL), you close the DB handle.