log4r-sequel
Log4r outputter to a Sequel database handle
- usage
- pre-built gem installation (stable)
- from-source installation (latest)
- demo
- supported databases
- notes
the de-facto standard library for logging in Ruby, log4r, works very well for a wide array of logging targets:
- STDOUT / STDERR
- file
- syslog
and so on, but didn't have a way to output directly to a database - enter log4r-sequel
this project was inspired/motivated by the fact that chainsaw isn't supported on recent versions of OSX.
usage
pre-built gem installation (stable)
gem install log4r-sequel
irb
...
irb(main):001:0> require 'log4r/outputter/sequeloutputter'
=> true
irb(main):002:0> logger = Log4r::Logger.new('foo')
=> #<Log4r::Logger:0x007f889b056df8 @fullname="foo" ...>from-source installation (latest)
git clone https://github.com/chorankates/log4r-sequel.git
cd log4r-sequel
rake clean build
gem install --local pkg/log4r-sequel*.gem
irb
...
irb(main):001:0> require 'log4r/outputter/sequeloutputter'
=> truedemo
$ ruby example/log2sqlite.rb
2016/08/27 17:08.1472342938 | bar | DEBUG | this is a debug message
2016/08/27 17:08.1472342938 | bar | INFO | this is an info message
2016/08/27 17:08.1472342938 | bar | WARN | this is a warning
2016/08/27 17:08.1472342938 | bar | ERROR | this is an error
2016/08/27 17:08.1472342938 | bar | FATAL | this is a fatal
$ sqlite3 example/log.sqlite
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> select * from logs;
1|2016/08/27 17:10.1472343022|foo|DEBUG|this is a debug message
2|2016/08/27 17:10.1472343022|foo|INFO|this is an info message
3|2016/08/27 17:10.1472343022|foo|WARN|this is a warning
4|2016/08/27 17:10.1472343022|foo|ERROR|this is an error
5|2016/08/27 17:10.1472343022|foo|FATAL|this is a fatal
sqlite>
supported databases
- sqlite3
- Postgres
notes
-
:database,:table, and:fileoptions are passed throughTime.now.strftime(%s) - sqlite filenames cannot contain underscores (
the scheme sqlite does not accept registry part)