I want to show newest posts from my WP blog to my static HTML page.

You can’t run queries from a purely HTML page. You’ll need to write code in PHP (or some programming language). Since you’re outside of the WordPress environment you’ll need to write your own code to connect to the WordPress database and extract the post content with SQL queries. And then once extracted you’ll need to write the necessary code to display the content in the way you want.

This isn’t a trivial effort unless you’ve done this sort of thing before.

This is trivial.

There is no need to write custom PHP to grab posts via a database query. Use a simple RSS reader to grab the posts; I can’t remember how many times I’ve done this. see https://simplepie.org/

You can also use Javascript and an external service: https://blog.superfeedr.com/google-feed-api-alternative/

Google’s RSS API was very popular, and still works, but is now officially deprecated and there is no telling when it will be stopped for good: https://developers.google.com/feed/?hl=en

Thanks Songdogtech for mentioning Superfeedr ??

You can indeed easily embed the content of any RSS feed with Javascript with Superfeedr… but more robust solution would be to actually store the data coming *from* superfeedr so you don’t have to load it from our servers.

Thanks for jumping in songdogtech. Your solution certainly sounds much easier.

@julien51: good point; I changed the link to one that explains more how to use the service as a subscriber.