Pay attention to the documentation of node-mysql: If you paid attention, you may have noticed that this escaping allows you to do neat things like this: var post = {id: 1, title: ‘Hello MySQL’}; var query = connection.query(‘INSERT INTO posts SET ?’, post, function(err, result) { // Neat! }); console.log(query.sql); // INSERT INTO posts SET … Read more
I reached out to the node-mysql folks on their Github page and got some firm answers. MySQL does indeed prune idle connections. There’s a MySQL variable “wait_timeout” that sets the number of second before timeout and the default is 8 hours. We can set the default to be much larger than that. Use show variables … Read more
This is gonna be a little scattered, forgive me. First, assuming this code uses the mysql driver API correctly, here’s one way you could wrap it to work with a native promise: function getLastRecord(name) { return new Promise(function(resolve, reject) { // The Promise constructor should catch any errors thrown on // this tick. Alternately, try/catch … Read more
Your “cash” setter calls the “cash” setter, which calls the “cash” setter, which calls the “cash” setter… Accessing the property setter by its own name inside the setter creates an infinite recursive function call.
The node-mysql library automatically performs escaping when used as you are already doing. See https://github.com/felixge/node-mysql#escaping-query-values