Sub-Minute and Cron-less Scheduled Tasks in Laravel

 The Spatie team released two new packages around scheduled tasks: the laravel-cronless-schedule package and laravel-short-schedule. While these packages have different use-cases, we thought they were related enough to share them in one post.

Typically the native Laravel scheduling gives you enough flexibility for most apps; however, these packages provide both an excellent development flow and advanced features when you need to run scheduled tasks more often than every minute.

Scheduled Tasks without Cron

The laravel-cronless-schedule package uses a ReactPHP loop to run the scheduler without relying on cron. If you’re developing locally, the “cron-less” scheduler could come in handy to run scheduled tasks without setting up cron:

1php artisan schedule:run-cronless

According to the documentation, “This command will never end. Behind the scenes, it will execute php artisan schedule every minute.”

Freek Van der Herten explains in his blog post, A package to run the Laravel scheduler without relying on cron, why you should consider using this package in your development workflow:

If you want to run the scheduler every minute in a local environment, using cron can be cumbersome. I bet most developers will never have touched their local crontab. There’s also launchd, which can work great, but it’s not as easy as just running the artisan command that spatie/laravel-cronless-schedule provides.

On Windows, cron doesn’t even exist (I’m not an expert, but there you should use the Windows Scheduler). And on Docker containers, cron mostly isn’t available.

This package avoids all the platform-specific scheduling issues, and also includes some useful flags:

1# Run the scheduler every five seconds
2php artisan schedule:run-cronless --frequency=5
3
4# Run a custom command
5php artisan cronless-schedule:run --command=your-favorite-artisan-command
6
7# Stop running the scheduler after x seconds
8php artisan cronless-schedule:run --stop-after-seconds=5

As an aside, I wrote about Running the Laravel Scheduler and Queue with Docker that runs the scheduler command in a separate container. However, it can be a pain if you want to run the scheduler docker container in development selectively.

You can find the source code for laravel-cronless-schedule on GitHub at spatie/laravel-cronless-schedule.

Laravel Short Schedule

The second package Spatie released is laravel-short-schedule, which enables running the Laravel scheduler at sub-minute frequencies. Similar to the cronless-schedule package, it uses a ReactPHP event loop.

Here’s an example of what you can do with this package by defining a shortSchedule() method on an app’s console Kernel class:

 1use \Spatie\ShortSchedule\ShortSchedule;
 2protected function shortSchedule(ShortSchedule $shortSchedule)
 3{
 4    // this command will run every second
 5    $shortSchedule->command('artisan-command')->everySecond();
 6 
 7    // this command will run every 30 seconds
 8    $shortSchedule->command('another-artisan-command')->everySeconds(30);
 9 
10    // this command will run every half a second
11    $shortSchedule->command('another-artisan-command')->everySeconds(0.5);
12}

Like the native Laravel scheduler, you can schedule commands to run between two times and avoid overlapping tasks if a task is still running.

You can learn more about this package by checking out Freek’s blog post: A package to schedule Artisan commands at sub-minute frequencies. You can find the source code on GitHub at spatie/laravel-short-schedule.

Read More

Postgres Range Type Support for Laravel 7

 The PosgreSQL range types package by @belamov provides range type support to Eloquent for the Postgres database:

 1Schema::create('table', function (Blueprint $table) {
 2    $table->id();
 3    // ...
 4    $table->dateRange('date_range');
 5    $table->timestampRange('timestamp_range');
 6    $table->floatRange('float_range');
 7    // for int4range
 8    $table->integerRange('integer_range');
 9    // for int8range
10    $table->bigIntegerRange('integer_range');
11 
12    // you can add any modifications
13    // $table->dateRange('date_range')->nullable();
14    // $table->dateRange('date_range')->default('[2010-01-01,2010-01-02)');
15});

The main features of this package include:

• Extended Laravel’s PostgresGrammar and PostgresConnection classes to provide a fluent API for range columns
• Support for the following Postgres range types: daterange, tsrange, numrange, intrange, and timerange.
• A number of query build macros for convenience (i.e., whereRangeContains($left, $right)
• Model property casting

The model property casting provided by this package provides convenience for working with ranges on model instances. For example:

1use Belamov\PostgresRange\Ranges\IntegerRange;
2 
3$range = new IntegerRange(10, 20, '[', ')');
4 
5$range->from(); // 10
6$range->to(); // 20
7(string) $range; // [10,20)
8$range->forSql(); // '[10,20)'

You can learn more about this package, get full installation instructions, and view the source code on GitHub at belamov/postgres-range. The package has an excellent blog post to bring you up to speed on the powerful features available in Postgres’ range types: Ranges in Laravel 7 using PostgreSQL.

Read More