TL;DR? Test Prequel here!
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
composer require protoqol/prequel:v1.2
When using Prequel 1.2 and up you can try and use the auto updater!
And else 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_ENABLEDin your .env file.
<?php
[
/*
|--------------------------------------------------------------------------
| 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 Locale : string
|--------------------------------------------------------------------------
|
| Choose what language Prequel should display in.
|
*/
'locale' => env('APP_LOCALE', 'en'),
/*
|--------------------------------------------------------------------------
| Prequel Path
|--------------------------------------------------------------------------
|
| The path where Prequel will be residing. Note that this does not affect
| Prequel API routes.
|
*/
'path' => 'prequel',
/*
|--------------------------------------------------------------------------
| Laravel asset generation suffix and namespace definition
|--------------------------------------------------------------------------
|
| Here you can define your preferred asset suffixes and directory/namespaces.
| Separate with a double backwards slash to define namespace and directory
| location. Everything after the last '\\' will be treated as a suffix.
| Note that the backslash needs to be escaped with an extra backslash
|
| For example
|
| Configuration
| 'suffixes' => [
| 'model' => 'Models\\Model',
| 'seeder' => 'MyMadeUpSeederSuffix'
| ]
|
| When generating for `users` table
| (directory) app/models/UserModel.php
| (qualified class) App\Models\UserModel
| (directory) database/seeds/UserMyMadeUpSeederSuffix.php
|
*/
'suffixes' => [
'model' => 'Models\\',
'seeder' => 'Seeder',
'factory' => 'Factory',
'controller' => 'Controller',
'resource' => 'Resource',
],
/*
|--------------------------------------------------------------------------
| 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' => ['foo'] ignores only the mysql.foo table.
| Using 'mysql' => ['*'] ignores the entire mysql database.
|
*/
'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
Contributing
See Contributing to see how you can contribute to Prequel!
Contributors
License
Prequel is licensed under the MIT License. Please see License File for more information.
![[Feature] Beta dark theme](https://avatars.githubusercontent.com/u/6562688?v=4)
![[BUG] Can't make it work with Homestead](https://avatars.githubusercontent.com/u/18409311?v=4)
![[FEATURE] List of DBs that will be ignored by default added.](https://avatars.githubusercontent.com/u/20080764?v=4)
![[BUG] Custom middleware not working](https://avatars.githubusercontent.com/u/45792245?v=4)
![[FEATURE REQUEST] Tests for source code](https://avatars.githubusercontent.com/u/956888?v=4)
![[BUG] Table 'users'](https://avatars.githubusercontent.com/u/31971074?v=4)
![[FIX] fixed error in DatabaseController](https://avatars.githubusercontent.com/u/10757342?v=4)
![[BUG] Can not install on laravel 6](https://avatars.githubusercontent.com/u/53075504?v=4)
![[RFC] Adding i18n](https://avatars.githubusercontent.com/u/31711158?v=4)
![[BUG] Prequel not loading](https://avatars.githubusercontent.com/u/16943788?v=4)
![[BUG] Malformed UTF-8 characters](https://avatars.githubusercontent.com/u/53626578?v=4)
![[BUG] Custom Database Connection Name](https://avatars.githubusercontent.com/u/5032579?v=4)
440 Dec 27, 2022
3.5k Jan 1, 2023
192 Dec 10, 2022
891 Dec 23, 2022
12.8k Dec 29, 2022
2.4k Dec 29, 2022
3.3k Dec 21, 2022
1.3k Dec 22, 2022
902 Jan 2, 2023
513 Dec 30, 2022
2.1k Dec 29, 2022
21 Jan 8, 2022
9 Jul 18, 2021
7.2k Jan 4, 2023
13 Nov 11, 2022
947 Dec 22, 2022
681 Jan 4, 2023
281 Nov 24, 2022
3k Jan 5, 2023
2 Sep 20, 2022
