In 2 Corinthians 7:10, we read, “Godly sorrow brings repentance that leads to salvation and leaves no regret, but worldly sorrow brings death.” Godly sorrow is what David eventually had for the sins he had committed. Worldly sorrow is what we have when we're upset that we got caught in our sin. The Psalmist has some good words of encouragement for us regarding how God handles our sin though.
In Psalm 103:11-12, David says “For as high as the heavens are above the earth, so great is his love for those who fear him; as far as the east is from the west, so far has he removed our transgressions from us.” David wrote this in 1,000 BC, and people didn't know at that time that the world was round. God could have inspired David to write that our sins had been removed as far as the north is from the south. That distance would be a really long way to separate us from our sins. But there is a North Pole and there is a South Pole with 3,900 miles between them. God, in his infinite wisdom, had David write that he would take your sin as far as the east is from the west. You can head east the rest of your life and just keep circling the globe; same with west.
God will never bring your sins back up, and it's your choice whether or not you believe that God's forgiveness is so complete that he banishes it to never be seen again. Now there may be earthly consequences for us. There may be legal penalties because of our sin. There may be consequences with other relatives or other people because of what's taken place. But if you've given your life to Christ and you sincerely repent of your sins, he is faithful and will forgive you of your sin.
Discussion/Reflection Question: Do you accept that God has completely banished your sin and will never again bring it up?