First merge of public API

Please run db updates: update2014_11_11.sql and update2014_11_19.sql from wlox/wlox.