David as Prophet

Acts 2:29 “Brothers, I may say to you with confidence about the patriarch David that he both died and was buried, and his tomb is with us to this day. 30 Being therefore a prophet, and knowing that God had sworn with an oath to him that he would set one of his descendants on his throne, 31 he foresaw and spoke about the resurrection of the Christ, that he was not abandoned to Hades, nor did his flesh see corruption. 32 This Jesus God raised up, and of that we all are witnesses. 33 Being therefore exalted at the right hand of God, and having received from the Father the promise of the Holy Spirit, he has poured out this that you yourselves are seeing and hearing. 34 For David did not ascend into the heavens, but he himself says,
“‘The Lord said to my Lord,Sit at my right hand,35 until I make your enemies your footstool.’
36 Let all the house of Israel therefore know for certain that God has made him both Lord and Christ, this Jesus whom you crucified.”
***
Remember that riddle that Jesus threw at the pharisees? Here Peter lays it all out. He says explicitly that King David was a prophet and that his psalms contain moments of spiritual percetion into the future and hidden truths of God's plans. King David was truly an exceptional person: a warrior, a musician, a passionate worshipper, a sinner and yet a man after God's heart. I find it so comforting that God would allow David to know this truth, centuries before it would happen, without scientific proof, or even firsthand experience. Or perhaps you could argue that he was, in fact speaking from the truest and most trustworthy source of scientific knowledge, and that he has firsthand experience with God, the very same person who was coming in the flesh - either way, I am comforted.