My question is similar to that one which was closed for being too broad, so I'll try to be clearer.
What I have: a sqlite database (single table) containing over 50'000 posts (with fields like author, content, date, etc.). It stems from scraping a huge static, html-only website.
What I want to achieve: displaying those posts in a standard WP installation.
My approach: I would
- Initialize an empty WordPress website
- Write a script that reads a post from the original DB and writes it into the corresponding fields of the WP database (ID -> ID, author -> author, date -> date, ...)
- Run the WordPress engine engine and expect the posts to appear
My question: is this approach likely to succeed, or should I avoid this futile work and consider other solutions?