Turn Small Data Into Smart Data. Part 3: gnuplot and psql


This is the third of a three part series focused on an open source tool chain for small data business intelligence. Part 1 explored dimensional modeling from a logical and use case perspective. Part 2 focused on Extract, Transform and Load with NodeJS.

Part 3 uses gnuplot to graph data both interactively and programmatically via scripts. Plus, psql is also used to pull and dump data in the correct format. Both of these are "sharp tools" in the Unix philosophy sense. They are cmdline executables which take text inputs, can be used interactively, and can be scripted too.