completed generic API
changed app name from API to api
change to use temportal sqlite database