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?

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

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

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

Product Support

meglio (Anton) December 30, 2015, 12:58am 5

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

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