MySQL DB Connector
Wrapper utility to easily manage multiple data sources and pooled connections.
Error Returns
By default, all errors occurring during a query are returned. If you want to be extra-safe in a production environment, you can set HIDE_DB_ERRORS value on the root config passed to the connector on initialization. When you do this, all errors will be logged, but none returned when a query error occurs.
SSL Settings
This connector allows setting SSL connection using a few different options.
You can provide a custom cert:
SSL: {
CUSTOM_CERT: // custom cert string
}
By default, when specifying an SSL object, the mysql connector will reject unauthorized calls by adding rejectUnauthorized: true. You may override this setting by specifying a value for REJECT_UNAUTHORIZED in your SSL config:
SSL: {
REJECT_UNAUTHORIZED: false // not recommended
}
#Data Typing Options
This connector gives you a few options for configuring how data is returned from the connector. 'typeCast' defaults to true, and converts data from the database to its javascript equivalent. For example, it will convert DATETIME SQL objects to a DATE javascript type. You can also set 'dateStrings' which defaults to false. If you set it to true it will override typeCast and force date returns to be a string instead of a DATE type.