Add route/page to a deployed next app

[zeldyrr]

New to next and I've run through the tutorial on creating a blog app. What's missing is the functionality to create a new blog post. Is there a tutorial/example out there for a next app that lets user dynamically create routes and pages?

For example, consider a web forum application. I want a user to be able to create a new post. The data for this new post would be stored in a database. I want a new route for the post to be created dynamically. Basically, is there a way to add content to a deployed next app without rebuilding and redeploying?

Continuing the example, I would like the forum posts to be search engine optimized. So they would be either statically or server-side rendered and the sitemap would have to be dynamically updated as well. (Clearly it isn't feasible to redeploy the site every time someone creates a post.) Is something like this possible with next?