api and db updates