add local gems
revise batch logging to log against execute instead of insert