Manage databases easily with Laravel Prequel

Manage databases easily with Laravel Prequel

Laravel Prequel is a Laravel package which can be used to manage databases without the need for tools like PHPmyadmin or Sequel Pro.

Laravel Prequel is a Laravel package which can be used to manage databases without the need for tools like PHPmyadmin or Sequel Pro.

What is Prequel exactly?

Prequel is meant to be a database management tool for Laravel to replace the need for separate standalone database tools like phpMyAdmin, Sequel Pro or MySQL Workbench. With its (hopefully) clear and concise UI, Prequel is to be a modern and lightweight database browser/tool ready for the web of the future. Prequel's design is purposefully based on that of Laravel Telescope because (web-)developers today have enough to learn and master already, so let's help eachother out and make sure to not add anything virtually useless to that huge pile of knowledge.

Clear and concise database management## Installation

To install follow the instructions below.
$ composer require protoqol/prequel  
$ php artisan prequel:install
When installation and publishing is done navigate to /prequel in your browser to see Prequel in action!

Updating

To update you can use the command specified below.
$ php artisan prequel:update

Issues, bugs and feature requests can be reported here!

Configuration

You might have noticed that, while publishing a config file appeared under config/prequel.php. That configuration file looks something like this.

Note that you can define PREQUEL_ENABLED in your .env file.

[  

    /*  
    |--------------------------------------------------------------------------  
    | Prequel Master Switch : boolean
    |--------------------------------------------------------------------------  
    |  
    | Manually disable/enable Prequel, if in production Prequel will always  
    | be disabled. Reason being that nobody should ever be able to directly look  
    | inside your database besides you or your dev team (obviously).  
    |  
    */
    'enabled'      => env('PREQUEL_ENABLED', true),  

    /*  
    |--------------------------------------------------------------------------  
    | Prequel Path : string
    |--------------------------------------------------------------------------  
    |  
    | The path where Prequel will be residing. Note that this does not affect 
    | Prequel API routes.  
    |  
    */
    'path'         => 'prequel',  

    /*  
    |--------------------------------------------------------------------------  
    | Prequel Database Configuration : array
    |--------------------------------------------------------------------------  
    |  
    | This enables you to fully configure your database-connection for Prequel.
    |  
    */
    'database' => [  
      'connection' => env('DB_CONNECTION', 'mysql'),  
      'host'       => env('DB_HOST', '127.0.0.1'),  
      'port'       => env('DB_PORT', '3306'),  
      'database'   => env('DB_DATABASE', 'homestead'),  
      'username'   => env('DB_USERNAME', 'homestead'),  
      'password'   => env('DB_PASSWORD', 'secret'),  
     ],  

    /*  
    |--------------------------------------------------------------------------  
    | Prequel ignored databases and tables : array
    |--------------------------------------------------------------------------  
    | Databases and tables that will be ignored during database discovery.
    |
    | Using 'mysql' => ['*'] ignores the entire mysql database.
    | Using 'mysql' => ['foo']  ignores only the mysql.foo table.
    */
    'ignored'      => [  
         // 'information_schema'  => ['*'],  
         // 'sys'                 => ['*'],
         // 'performance_schema'  => ['*'], 
         // 'mysql'               => ['*'],
         '#mysql50#lost+found'    => ['*'],  
     ],

    /*
    |--------------------------------------------------------------------------
    | Prequel pagination per page : integer
    |--------------------------------------------------------------------------
    |
    | When Prequel retrieves paginated information, this is the number of
    | records that will be in each page.
    |
    */
    'pagination' => 100,

        /*
        |--------------------------------------------------------------------------
        | Prequel middleware : array
        |--------------------------------------------------------------------------
        |
        | Define custom middleware for Prequel to use.
        |
        | Ex. 'web', Protoqol\Prequel\Http\Middleware\Authorised::class
        |
        */

        'middleware' => [
            Protoqol\Prequel\Http\Middleware\Authorised::class,
        ],
];

Clear and concise database management

laravel php web-development database

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

PHP Web Application Development Company

As a top **PHP Web Application Development Company in USA**[https://www.dataeximit.com/php-development-services/](https://www.dataeximit.com/php-development-services/ "https://www.dataeximit.com/php-development-services/"), we at Data EximIT have...

PHP Website Development

Skenix Infotech is a leading PHP Web Development Company that helps companies get results with industry best practices. Get affordable PHP Development Services.

Laravel Development Company

Skenix Infotech is a top Laravel Website Development Company with Expert Laravel Developers that provides robust Laravel Development Services at fair costs.

Hire Dedicated PHP Developer

Looking to hire affordable yet experienced PHP developers? **[Hire Dedicated PHP Developer](https://hourlydeveloper.io/hire-dedicated-php-developer/ "Hire Dedicated PHP Developer")**, who can convert your idea to reality, within the stipulated...

Hire PHP Developer

Looking to develop a PHP based website from scratch or revamp your existing website? **[HourlyDeveloper.io](https://hourlydeveloper.io/ "HourlyDeveloper.io")** has always been an industry leader for companies and business owners looking to hire...