So, I have a few SQL queries that “fix” some common issues in posts. Running an SQL query updates the raw column only. Now, is there a way to somehow queue those posts for rebaking provided I know their IDs? I mean, maybe there is kind of sidekiq queue where we could put the rebake tasks for the posts?

This will queue a background full rebake ./launcher enter app rails c Post.exec_sql('update posts set baked_version = 0')

While I can’t find the source right now, I think that clearing the cooked version should suffice: One of the regular Sidekiq jobs should then automatically queue a baking task.

[image] fefrei: clearing the cooked version should suffice: One of the regular Sidekiq jobs should then automatically queue a baking task. How will displaying the message behave if it needs to be displayed but no cooked version present yet?

Excellent, so I can do the same with an SQL query right from the data explorer, can I?

No you can not do this from data explorer we explicitly disallow write there.

Throw a rebake with using an SQL query only - is it possible?

Product Support

fefrei (Felix Freiberger) December 30, 2015, 11:06am 7

I think it bakes on demand – at least my installation continued looking normally when I did this.

Topic		Replies	Views
My journey into a massive posts rebake job Self-hosting	35	5240	July 10, 2024
Rebake All Posts Optimization Product Support	4	713	May 30, 2022
Rebaked all my posts, but what's it doing now? Product Support	2	415	February 15, 2021
Slow rebake script to avoid overwhelming your server Migration	4	256	November 13, 2025
Rebake all posts matching a pattern Self-Hosting rails-console , how-to	1	9700	May 30, 2024

Throw a rebake with using an SQL query only - is it possible?

Related topics