bakraj/databasewatcher

Laravel Package to track and monitor DB requests

DataBase Watcher

Laravel package to monitor database request , exposing an API to collect the usage statistics or using the package builtin view to represent the data on graphs using Chartjs., _(*1)

install:

Require this package with composer using the following command:, _(*2)

composer require bakraj/databasewatcher

After updating composer, add the service provider to the providers array in config/app.php, _(*3)

$ bakraj\DataBaseWatcher\DataBaseWatcherServiceProvider::class,

Laravel 5.5 uses Package Auto-Discovery, so doesn't require you to manually add the ServiceProvider., _(*4)

Publishing views, assets and config:

1- publishing all:, _(*5)

$ php artisan vendor:publish --provider="bakraj\DataBaseWatcher\DataBaseWatcherServiceProvider"

2- publishing views:, _(*6)

$ php artisan vendor:publish --tag=databasewatcer.views --force

3- publishing assets:, _(*7)

$ php artisan vendor:publish --tag=databasewatcer.assets --force

API Documentation:

over all statistics:

calling the route, _(*8)

/databasewatcher/overall

expected result:, _(*9)

{
    "stats":
    {
        "2018-07-25":121
    }
}

specific day statistics:

calling the route:, _(*10)

/analyze/{date}

expected result:, _(*11)

{
    "stats":
    {
        "hour_request":
            {
            "1":3,"2":9
            },
        "total":12
    }
}