simplified conn string (thank god) and fixed some linting errors