Hacker News new | ask | show | jobs
by busterarm 1713 days ago
It doesn't even have to be this hard -- just be familiar with how the WordPress database lays out its custom post types.

I wrote a Jekyll Generator plugin that just makes a SQL query to the WordPress database and generates all of the sites' content a good 5 or 6 years ago. It's fairly trivial work.
2 comments
wjohnsto 1713 days ago
You're right and your approach works well for all the mostly static content. The tools above are useful if you want to enable things like authentication/gated content, e-commerce etc while also having some static content.
link
handrous 1713 days ago
WP also has an HTTP-speaking API, but yeah, I've done the "extract posts and pages directly from the DB" thing too. It's maybe half a day if you've never looked at the WP DB schema before, mainly figuring out which tables & fields you need to look at to select only published items. Probably minutes if you're already familiar with it.
link