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 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