PHP download

Download the PHP package labofgood/module-db-query-log-extended without Composer

On this page you can find all versions of the php package labofgood/module-db-query-log-extended. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download labofgood/module-db-query-log-extended
More information about labofgood/module-db-query-log-extended
Files in labofgood/module-db-query-log-extended

Vendor labofgood
Package module-db-query-log-extended
Short Description The module enhances the DB logger functionality, offering the capability to display DB logs in the xlsx format and produce a report analyzing query similarities.
License BSD-3-Clause

Keywords dev

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of labofgood/module-db-query-log-extended

Informations about the package module-db-query-log-extended

Database Query Log Extended magento2 module

Overview

The Labofgood_DbQueryLogExtended module offers enhanced analysis capabilities for the db.log generated using Magento's command:

This module enriches the standard command functionalities by introducing:

Extended information about queries added the record context (request uri or CLI command), record number, UID of process.
Capability to export the log to an XLSX file format.
A feature to do a similarity analysis of SQL queries and showcase them in a separate XLSX sheet.

Example of the report:

Example of the similarity analysis report:

Prerequisites

PHP 8.1 or higher
Magento 2.4.5

Dependencies

composer.json includes:

Installation Steps

Please follow the instructions:

Run composer require --dev labofgood/module-db-query-log-extended
Run bin/magento setup:upgrade

Usage Guide

To install, please adhere to the following steps:
Browse the website or initiate a CLI command to populate db.log with queries.
Run the following command to transform db.log into a XLSX file
For grouping similar queries and showcasing them in a separate XLSX sheet, run the following command:
When done, deactivate the query log with:

Uninstallation

To uninstall the module, run: bin/magento module:uninstall Labofgood_DbQueryLogExtended

Credits

Anton Abramchenko [email protected]

Licensing

All versions of module-db-query-log-extended with dependencies

PHP Build Version

Package Version

Version v1.0.4 Release 02. Nov 2023
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of module-db-query-log-extended from vendor labofgood

Requires php Version ^8.1
magento/framework Version 103.0.*
magento/module-developer Version 100.4.*
shuchkin/simplexlsxgen Version ^1.3

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package labofgood/module-db-query-log-extended contains the following files

Loading the files please wait ....