Have you looked into WordPress with SQLite? Also important: does the content change over time a lot? You might also want to look at Sphinx Search Engine to speed up your full text searches (from Wordpress search functions):
Also remember that with popular posts, you will want to have query caching activated. But if all posts get visited the same amount of times, you might not want to do activate this.