Read 1st and 2nd Samuel and also the Psalms of David. I challenge you to continue worshiping, singing God's praises, repenting, and striving to be better despite falling short because God doesn't use perfect He uses incomplete clay and molds it into the perfect instrument for HIS will.
