database and snippet updates