Integrate `pg-boss` for job scheduling

[rajdip-b]

Description

To run jobs in the background as cronjobs jobs, or jobs that might take up significant resources, we would like to use pg-boss. This would allow us to harness the power of our database.

This issue focuses on creating the client API for pg-boss

Use this article for reference: https://www.npmjs.com/package/pg-boss

Solution

• Create a separate module and name it job-handler. Add a class called JobHandler in job.handler.ts.
• It should have a constructor that will initialize pg boss.
• It should have a generic function that will do the actual job on our behalf. The signature would be:

  async <T, V>registerJob(queue: string, callback: (job: V) => T) => T;

• Export this module globally (take reference from how the prisma module is exported globally).

[Ratnesh2003]

/attempt

[github-actions[bot]]

Assigned the issue to you!

[rajdip-b]

@Ratnesh2003 hey bro made any progress on this?

[rajdip-b]

This issue is up for grabs again!

[rajdip-b]

Integrate pg-boss for job scheduling

[rajdip-b]

Integrate pg-boss for job scheduling

[Allan2000-Git]

@rajdip-b To confirm, I'll have to create job-handler folder in apps/api/src, then create job.handler.ts file and then create a class JobHandler that handles rest of the task?

[rajdip-b]

I think, we won't need all that trouble. You can add job.handler.ts directly in common module

[Allan2000-Git]

/attempt I'd love to work on this issue.

[github-actions[bot]]

Assigned the issue to @Allan2000-Git!