nightly work; sql/threading thoughts + pick json lib