adding db sql and getting rid of shared views