dlgr - Datalogger For Time Series Data

Datalogger aka dlgr is a simple command-line application. It logs one floating point value per time. The application is written in C and uses a SQLite database.

Multiple trackers keeping various time value relations. It also provides an option to execute user-defined SQLite queries to filter, export or process your logs.

Use Datalogger to log temperatures, stock prices, fuel cost, daily power meter values or working hours.

Howto Install Datalogger

git clone http://git.christoph-polcin.com/c/dlgr
make
make install
mkdir -p ~/.config/dlgr
dlgr --help

A Few Examples

# create tracker
dlgr fuel -c

# list all trackers
dlgr -l

# log values
dlgr fuel -t 0 -v 1.50
dlgr fuel -t -5 -v 1.45
dlgr fuel -t 2010.04.12 -v 1.38
dlgr fuel -t 2010.04.15 -v 1.39
dlgr fuel -t 2010.05.15 -v 1.40

# list values
dlgr fuel -l
dlgr fuel -l -t 2010.04..2010.05

# execute a user-defined query
dlgr fuel -q "SELECT MIN(v),t,OID FROM fuel"
dlgr fuel -q "SELECT MAX(v),t,OID FROM fuel"

# import data from a CSV file
dlgr fuel -i 2010.csv

# export a range of values
dlgr fuel -e -t 2010.04..2010.05 > fuel-201004-201005.csv

Usage

Usage: dlgr [TRACKER] [OPTIONS]

OPTIONS
    -c, --create           Create a new tracker
    -d, --database <FILE>  SQLite3 database file
    -e, --export           Export as CSV (oid,value,timestamp)
    -i, --import <FILE>    Import a file with CSV (value,DATE)
    -l, --list             List trackers or tracker logs
    -q, --query <QUERY>    Execute a user-defined SQLite query
                             columns: time->t, value->v, id->OID
    -r, --remove <OID>     Remove a log
    -t, --time <DATE>      Date
                             +/-N - N Days ahead/ago
                             0 - Today 00:00:00
                             dd[.mm[.yyyy [HH[:mm[:ss]]]]]
                             yyyy[.mm[.dd [HH[:mm[:ss]]]]]
                             UNIX Timestamp
                             DATE..DATE to get a time span
    -v, --value <FLOAT>    Value to log
    -h, --help             For general usage information

For bigger data consider RRDtool. Suggestions and patches are welcome.