Register the DB listener through the boot function instead of register function

All service providers extend the Illuminate\Support\ServiceProvider class. Most service providers contain a register and a boot method. Within the register method, you should only bind things into the service container. You should never attempt to register any event listeners, routes, or any other piece of functionality within the register method.

As stated in the laravel document.The registration of listener should not be placed on register. This is the current provider code:

    public function register()    
    {    
        // ...    
        // listen to database queries    
        $this->app['db']->listen($this->getListenClosure($logger));    
    }

$this->app['db'] will cause db to be instantiated,Any provider executed after that, if it contains changes to db, will be ignore because the db is instantiated in advance.

There is a bug, which causes the official package of laravel-mongodb not to be correctly register in the resolving callback of db. This bug is modified by the official suggestion of mongodb. see https://github.com/mongodb/laravel-mongodb/issues/2715#issue-2104526953

So the solution to the problem is that db should not be instantiated in register, which does not conform to the specification of laravel and can lead to conflicts between packages.

mnabialek / laravel-sql-logger

Register the DB listener through the boot function instead of register function #37