Better way to query posts?

Since the queries are not related to each other, there is no other way around it. You are going to end with with many queries and slow page (when it is not cached) on a site with many categories. A better approch may be to show latest 50 posts, and display them by category, but … Read more

Kohana Frontend, WordPress Backend

You could add the Kohana part as a WordPress plugin that filters template_include and returns a local file path to your Kohana controller. Then you all the regular WordPress variables and functions are available in your additional code. If you want to use your own database layer you’d have to do the rewrite part probably … Read more

Create page with custom php script and fetched data

1) It is easy to create tables in WP. I suggest making a plugin to handle this for you. See the codex for more info: https://codex.wordpress.org/Creating_Tables_with_Plugins 2) Again, I suggest using WP to handle this for security purposes. As you stated, you would have connection details that could potentially be exploited. 3) I think there … Read more