Laravel database log channel
The package provides the ability to write logs into the database synchronously or asynchronously, along with other logging channels.
Installation
You can install the package via composer:
composer require goszowski/laravel-database-log-channel
You can publish and run the migrations with:
php artisan vendor:publish --tag="database-log-channel-migrations"
php artisan migrate
Configure logging.php:
return [
'channels' => [
'stack' => [
'driver' => 'stack',
'channels' => ['daily', 'database'], // Add "database" channel
'ignore_exceptions' => false,
],
// ...
'database' => [
'driver' => 'monolog',
'handler' => Goszowski\DatabaseLogChannel\Logging\DatabaseLogHandler::class,
'via' => Goszowski\DatabaseLogChannel\Logging\DatabaseLogger::class,
'alternative-log-channel' => 'daily', // Use an alternate channel when it is not possible to write to the database
'connection' => null, // Use default connection
'table' => 'logs',
'async' => true, // If true, will be sent to the queue
'queue' => 'default', // Define a queue for asynchronous logging
'level' => 'error',
],
],
];
Usage
use Log;
Log::error('My error message');
Data Pruning
Without pruning, the logs table can accumulate records very quickly. To mitigate this, you should schedule the database-logs:prune Artisan command to run daily:
$schedule->command('database-logs:prune')->daily();
By default, all entries older than 24 hours will be pruned. You may use the hours option when calling the command to determine how long to retain Logs data. For example, the following command will delete all records created over 48 hours ago:
$schedule->command('database-logs:prune --hours=48')->daily();
Changelog
Please see CHANGELOG for more information on what has changed recently.
Security Vulnerabilities
Please review our security policy on how to report security vulnerabilities.
Credits
License
The MIT License (MIT). Please see License File for more information.
2 Aug 10, 2022
2 Sep 15, 2022
13 Nov 11, 2022
19 Dec 27, 2021
94 Nov 22, 2022
4 May 18, 2022
6 May 31, 2023
34 Jul 30, 2021
5 Nov 3, 2022
3 Aug 9, 2022
34 Jun 20, 2022
2.3k Jan 7, 2023
2 Nov 14, 2021
6 Jun 14, 2022
205 Dec 19, 2022
5 Dec 14, 2022
12 Mar 15, 2022
1 Nov 2, 2021
4 Apr 9, 2022