changed to sqlite local and added view