Download the PHP package mnabialek/laravel-sql-logger without Composer
On this page you can find all versions of the php package mnabialek/laravel-sql-logger. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download mnabialek/laravel-sql-logger
More information about mnabialek/laravel-sql-logger
Files in mnabialek/laravel-sql-logger
Package laravel-sql-logger
Short Description Log SQL queries in Laravel/Lumen framework
License MIT
Informations about the package laravel-sql-logger
Laravel SQL Logger
This module allows you to log SQL queries (and slow SQL queries) to log file in Laravel/Lumen framework. It's useful mainly when developing your application to verify whether your queries are valid and to make sure your application doesn't run too many or too slow database queries.
Support
Using this package is free of charge, however to keep it up-to-date and add new features small money support is appreciated. Suggested amount is 5$ per project where you use this package but any amount will help further development of this package. (you are free to change amount on Paypal page)
Installation
-
Run
in console to install this module (Notice
--dev
flag - it's recommended to use this package only for development). -
If you use Laravel < 5.5 open
config/app.php
and inproviders
section add:Laravel 5.5 uses Package Auto-Discovery and it will automatically load this service provider so you don't need to add anything into above file.
If you are using Lumen open
bootstrap/app.php
and add: -
If you use Laravel < 5.5 run:
in your console to publish default configuration files.
If you are using Laravel 5.5 run:
and choose the number matching
"Mnabialek\LaravelSqlLogger\Providers\ServiceProvider"
provider.By default you should not edit published file because all the settings are loaded from
.env
file by default.For Lumen you should skip this step.
-
In your .env file add the following entries:
and adjust values to your needs. You can skip variables for which you want to use default values.
If you have also
.env.sample
it's also recommended to add those entries also in.env.sample
file just to make sure everyone know about those env variables. Be aware thatSQL_LOGGER_DIRECTORY
is directory inside storage directory. If you want you can change it editingconfig/sql_logger.php
file.To find out more about those setting please take a look at Configuration file
-
Make sure directory specified in
.env
file exists in storage path and you have valid file permissions to create and modify files in this directory (If it does not exist this package will automatically create it when needed but it's recommended to create it manually with valid file permissions) - Make sure on live server you will set logging SQL queries to false in your
.env
file. This package is recommended to be used only for development to not impact production application performance.
Upgrading from 1.*
When upgrading from 1.*
version you should remove current sql_logger.php
config file and replace this with new one (see installation step). You should also use new variables in .env
file (old won't be used).
Authors
Author of this awesome package is Marcin Nabiałek and Contributors
Changes
All changes are listed in Changelog
License
This package is licenced under the Support is more than welcome.
All versions of laravel-sql-logger with dependencies
mnabialek/laravel-version Version ^1.0.6
nesbot/carbon Version ~1.0 || ^2.0 || ^3.0
illuminate/filesystem Version 5.*|6.*|7.*|8.*|9.*|10.*|11.*
illuminate/container Version 5.*|6.*|7.*|8.*|9.*|10.*|11.*