Bug busters

Verify if a variable references a Buffer [Node.js]

The Buffer class exposes a static method isBuffer(arg) which returns true if the argument to this function is a Buffer instance.

const buf = Buffer.from([25, 45, 90]);

console.log( Buffer.isBuffer(buf) ); 
// true


PASSWORD function issue when migrating from MySQL less than 5.7.5

While trying to migrate my database from 5.7.37 to 8.0.12, I started experiencing the following error:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

This was as a result of the PASSWORD function being removed from mysql versions greater than 5.7.5