Laravel Pipeline Query Collection

 The Laravel Pipeline Query Collection package contains a collection of Eloquent query filters for pipelines. Given a complex query of filters, the code can get a bit unwieldy around query conditions:

 1$users = User::query()
 2    ->when($request->name ?? null, function($query, $name) {
 3        $query->where('name', 'like', "%$name%");
 4    })
 5    ->when($request->is_admin ?? null, function($query, $isAdmin) {
 6        $query->where('is_admin', $isAdmin ? 1 : 0);
 7    })
 8    ->when($request->created_at_from ?? null, function($query, $date) {
 9        $query->where('created_at', '>=', $date);
10    })
11    ->when($request->created_at_to ?? null, function($query, $date) {
12        $query->where('created_at', '<=', $date);
13    })
14    ->get();

Using this package could be written as follows:

 1use Baro\PipelineQueryCollection;
 2 
 3// users?name=Baro&is_admin=1&created_at_from=2022-06-01&created_at_to=2022-06-31
 4$users = Users::query()->filter([
 5    new PipelineQueryCollection\RelativeFilter('name'),
 6    new PipelineQueryCollection\BooleanFilter('is_admin'),
 7    new PipelineQueryCollection\DateFromFilter('created_at'),
 8    new PipelineQueryCollection\DateToFilter('created_at'),
 9])
10->get();

At the time of writing, this package contains the following filters:

• Bitwise
• Boolean
• Date from
• Date to
• Exact
• Relation
• Relative
• Scope
• Sort

You can get started with this package on GitHub at l3aro/pipeline-query-collection. The package's author also wrote a more in-depth article—Building a sexy query filter—which walks you through the idea behind the package.

Read More

New Relic Package for Laravel Apps

 The Laravel New Relic package enhances New Relic performance monitoring for Laravel apps. While New Relic works with Laravel applications out of the box, this package reports optimized transactions for Laravel.

Out of the box, this package can tune transactions for:

• HTTP transactions are handled with a global middleware on each request
• CLI requests are filtered out for noise (so long-running calls like php artisan horizon won't skew your stats).
• Queued jobs record a transaction automatically as each one starts and ends.
• Artisan commands are recorded as individual transactions.
• Scheduled tasks are monitored as each one is executed.

Additionally, this package can notify New Relic of code deployments (which can help isolate performance issues and errors) and simulate transactions in environments where the package cannot detect the New Relic PHP module.

1php artisan new-relic:deploy

The configuration file has more details on how to configure this package, ignore commands, and even ignore route patterns. It comes with sensible yet customizable defaults.

You can learn more about this package, get full installation instructions, and view the source code on GitHub.

Read More