I'm trying to have my posts published when wp_posts.ID IN (list). Is it advisable to do it with an event in MySQL/MariaDB? Would it mess up the cache? Is it enough to just do
SET posts_status = 'publish' WHERE wp_posts.ID IN (list)
? I found one answer that could be the solution here https://wordpress.stackexchange.com/a/313060/151436 but I'm not really sure how to implement it.
Also, it would be great if a solution had like a minute gap between publishing, so it doesn't slow down the server.
Any help would be greatly apriciated! Thank you