This is 100% possible without a server. Your repo can be your database if you run it statically with something like Hugo (a single binary with no dependencies). Store your content in your own repo in Markdown files (or something similar, like MDX) and host it on Netlify, Vercel, AWS, etc.

If your site has 10K posts and you don’t want to deal with long build times, use Next.js with ISR (make some high traffic pages static, others dynamic (server side rendered)).

As the founder of Forestry.io and Tina.io, I’m biased about a content editing UI, but there are many options if you want a GUI on top of your content files.

You got this.