A Mysql transport for winston.
Installation
Installing winston-mysql-transport via npm
$ npm install winston$ npm install winston-mysql-transport
(or add it to your package.json)
Usage
First you must generate your log table
/*file : extras/schema.sql*/NOT EXISTS `my_database`.`log_table` (`id` int(10) NOT NULL AUTO_INCREMENT,`level` varchar(45) NOT NULL,`message` text NOT NULL,`timestamp` datetime NOT NULL,`meta` varchar(255),`hostname` varchar(255),PRIMARY KEY (`id`));
And in your code...
var winston = ;//// Requiring `winston-mysql-transport` will expose// `winston.transports.Mysql`//Mysql;options =database : "my_database"table : "log_table"user : "root"winston;
You can find a list of options that you can pass here :
https://github.com/felixge/node-mysql#connection-options
Unsupported
This transport does not support (yet) :
- streaming
- querying
- Saving of metadata