🚀 Boost Your Laravel Performance with Real-Time Laravel N+1 Query Detection! 🛠️

ScaleUp SaaS — Mon, 08 Jul 2024 22:23:08 +0000

Sure! Here's a revised version tailored specifically for dev.to:

🚀 Boost Your Laravel Performance with Real-Time N+1 Query Detection! 🛠️

As Laravel developers, we've all faced the dreaded N+1 query problem at some point. It's a silent performance killer that can turn a blazing-fast application into a sluggish one. But fear not! Introducing Laravel N+1 Query Detector, a powerful tool to help you identify and resolve N+1 query issues in real-time.

🔗 Check it out on GitHub

Why You Need This

N+1 queries occur when your application executes additional queries inside a loop, leading to a significant performance hit. Identifying these queries manually can be a daunting task, especially in large applications. Our package simplifies this by detecting N+1 queries as they happen, providing detailed insights and advanced notifications to keep your application running smoothly.

Key Features

Real-time Detection: Catch N+1 queries as they happen, ensuring your application's performance remains top-notch.
Detailed Insights: Get comprehensive details about each detected N+1 query, including the class and methods involved.
Advanced Notifications: Stay informed with alerts via Slack, webhooks, or email.
Rich Admin Dashboard: View all N+1 warnings in a user-friendly dashboard.
Team-Friendly: Perfect for solo developers and teams working collaboratively.
Compatibility: Supports Laravel 5.5+ and PHP 7+.

Installation

Getting started is easy. Install the package via composer:

composer require --dev saasscaleup/laravel-n-plus-one-detector

Publish the package's configuration and migration files:

php artisan vendor:publish --provider="SaasScaleUp\NPlusOneDetector\NPlusOneDetectorServiceProvider"

Run the migrations to create the necessary database table:

php artisan migrate

Configuration

Edit the config/n-plus-one.php file to set thresholds, notification preferences, and more.

Usage

The package automatically listens to your database queries and detects N+1 issues in real-time. Access the admin dashboard to view all warnings:

Route::get('/nplusone/dashboard', [NPlusOneDashboardController::class, 'index'])->name('nplusone.dashboard');

Notifications

Configure notifications to be sent via Slack, webhook, or email. Set your notification preferences in the config/n-plus-one.php file to stay informed about N+1 issues in your application.

Slack notification

Webhook notification

Email notification

By leveraging Laravel N+1 Query Detector, you can ensure your application runs smoothly and efficiently, providing the best experience for your users. Start detecting and fixing N+1 queries today!

🔗 Check it out on GitHub

This should help you effectively share your Laravel N+1 Query Detector package with the dev.to community.

PHP Version of console.log() for Laravel

ScaleUp SaaS — Thu, 27 Jun 2024 21:38:54 +0000

Easily stream your Laravel application logs to the browser console tab (console.log) in real-time using server-sent event (SSE)

Welcome to Laravel Console Log (LCL)! This package brings real-time logging to your Laravel application, allowing you to stream your logs directly to your browser's console. Perfect for backend developers who want the power of console.log for their PHP projects. Say goodbye to tedious log file hunting and hello to instant insights!

✨ Features

Stream Backend Events: Send messages from Controllers, Events, Models, etc., directly to your browser console.
Stream Application Logs: View your Laravel logs (storage/logs/laravel.log) in real-time in your browser console.

Requirements

PHP >= 7
Laravel >= 5

Installation - Via Composer (Dev Environment)

Not recommended for production.

composer require --dev saasscaleup/laravel-console-log

For Laravel < 5.5

Add the Service Provider to config/app.php in the providers section:

Saasscaleup\LCL\LCLServiceProvider::class,

Add the Facade to config/app.php in the aliases section:

'LCL' => Saasscaleup\LCL\Facades\LCLFacade::class,

Configuration

Publish Config, Migration, and View Files

php artisan vendor:publish --provider="Saasscaleup\LCL\LCLServiceProvider"

Run Migration

Create the stream_console_logs table:

php artisan migrate

Setup LCL in Your View/Layout

Add this to your main view/layout (usually layout/app.blade.php) file before </body>:

@include('lcl::view')

<body>
...
@include('lcl::view')
</body>

Environment Configuration

Adjust your .env file or config/lcl.php to customize settings:

return [

    'enabled' => env('LCL_ENABLED', true),
    'log_enabled' => env('LCL_LOG_ENABLED', true),
    'log_type' => env('LCL_LOG_TYPE', 'info,error,warning,alert,critical,debug'),
    'log_specific' => env('LCL_LOG_SPECIFIC', ''),
    'interval' => env('LCL_INTERVAL', 1),
    'append_user_id' => env('LCL_APPEND_USER_ID', true),
    'keep_events_logs' => env('LCL_KEEP_EVENTS_LOGS', false),
    'server_event_retry' => env('LCL_SERVER_EVENT_RETRY', '2000'),
    'delete_log_interval' => env('LCL_DELETE_LOG_INTERVAL', 600),
    'js_console_log_enabled' => env('LCL_JS_CONSOLE_LOG_ENABLED', true),

];

Usage

Stream notifications from your controllers or event classes:

use Saasscaleup\LCL\Facades\LCLFacade;

public function myFunction()
{
    LCLFacade::notify('Message 1');
    LCLFacade::notify('Message 2', 'success');
    LCLFacade::notify('Message 3', 'error');
}

Or use the helper function:

stream_log('Message 1');
stream_log('Message 2');

Log messages using Laravel's logging system:

\Log::info('Log Message 1');
\Log::error('Log Message 2');

Customizing

Customize Notifications

Modify resources/views/vendor/lcl/view.blade.php to change the notification appearance.

Custom Events

Change the event type in LCLFacade::notify:

LCLFacade::notify('User purchased a plan', 'info', 'UserPurchase');

Handle it in your view:

<script>
var es = new EventSource("{{route('lcl-stream-log')}}");

es.addEventListener("UserPurchase", function (e) {
    var data = JSON.parse(e.data);
    alert(data.message);
}, false);
</script>

Github link

Check out laravel-console-log package Github repository

License

This package is open-sourced software licensed under the MIT license.

DEV Community: ScaleUp SaaS

🚀 Boost Your Laravel Performance with Real-Time Laravel N+1 Query Detection! 🛠️

🚀 Boost Your Laravel Performance with Real-Time N+1 Query Detection! 🛠️

Why You Need This

Key Features

Installation

Configuration

Usage

Notifications

Slack notification

Webhook notification

Email notification

PHP Version of console.log() for Laravel

✨ Features

Requirements

Installation - Via Composer (Dev Environment)

For Laravel < 5.5

Configuration

Run Migration

Setup LCL in Your View/Layout

Environment Configuration

Usage

Customizing

Customize Notifications

Custom Events

Github link

License