Just a question about plugin architecture

[olegabr]

Just a question about plugin architecture

[codehaiku]

Thank you so much for asking that question.

The main reason why we split the data into four tables is for query efficiency. Sometimes having custom tables has many advantages compare to using default WordPress tables and metatables. With custom tables, we can add indexes to the schema which brings many benefits.

WordPress 'meta_query' is also terribly slow and very expensive. So it is a lot better to organize the plugin data into its 'own' table.

Projects are simple objects and do not need complex associations, so it is fit inside 'wp_posts' table.

Of course, the drawback is that other plugins will not be able to extend the functionality of the plugin (Taskbreaker) easily. This can easily be solved by providing plugin API, hooks, and actions in the future.

Anyways, PRs are always welcome :)

[olegabr]

Thank you for the explanation!