Extend Celery Result Database Backend

[adityar98]

I am using celery for performing a crawlin operation in this process I want to store a extra metadata information in the celery result table. I am using postgresql db as the backend. How can I add this extra column in the table and which should be updated be celery when creating a task.

[sdrabblescripta]

I ended up creating a separate table joined 1-1 with the primary result table. It's not ideal - there should be a way to extend the normal result table - but it works well. This was for django but I expect it would work similarly for plain celery.

[adityar98]

Thank you for that solution what I did was create the table in postgresql before initializing celery and adding in necessary columns which I populate using some generated value based on the values of other column so that I do not need to change the INSERT/UPDATE/DELETE of tasks in the celery. Using this approach it helped me to add metadata to the celery tasks