RDBMS Background Jobs - ServiceStack

About

In this show, we explore the inner workings that goes into each ServiceStack Release and explore the benefits and purpose behind major features and how they can empower your next project and help you build better apps faster. We also dive deep into some of the most popular topics in modern web dev, API design, microservices architecture, and more.

This episode introduces the new DatabaseJobFeature, which ports ServiceStack's Background Jobs functionality from SQLite to industrial-strength relational database management systems (RDBMS) like PostgreSQL, SQL Server, and MySQL.

This feature allows developers to run background jobs and schedule tasks within their existing .NET 8+ applications, providing durability and a management UI for monitoring. A key element is replicating SQLite's monthly data archival strategy by using monthly partitioned SQL tables for completed and failed job history, with PostgreSQL offering native partitioning support.

The functionality supports queuing existing APIs or custom Commands and offers extensive options for controlling job execution, including serialization via named workers, dependency management, and authenticated user contexts, while also supporting recurring tasks via TimeSpan or CRON expressions.

About

Listen