I am trying to sync WP with another service that offers an API that allows me to hook up their table's Update, Create, Delete to my sites.
So when they create, update, or delete a row on their server, I get details about that update, including the row ID.
The way I am thinking of syncing is by using custom post types, and either add a new separate table with post -> api relation like post_id:1 = api_id:53
.
Or alter wp_posts
table by adding a column containing the api_id.
I know I can add metabox which will add that as post_meta but I am not sure how effective will that be and I am pretty sure if I alter wp_posts
, querying will be a lot faster.
So how can I alter wp_posts
in the WordPress way? If that's not possible, should I add meta boxes or create an entirely new table just for the relation ?