genealabs / laravel-optimized-postgres
optimizes field types for Postgres.
Fund package maintenance!
mikebronner
Requires
- php: ^8.2
- illuminate/database: ^10.0
- illuminate/support: ^10.0
README
Impetus
By default I like my Postgres database to use text
type for all textual fields.
When you run your migrations with this package installed, it will convert the
following migration types to text
: char
, and string
.
Installation
Requirements
- PHP >=7.0
- Laravel >=5.4
Composer Command
composer require genealabs/laravel-optimized-postgres
Service Provider
If you are on Laravel 5.5, the service provider will auto-register once the
package is installed. You can skip this step. If you haven't upgraded to
Laravel 5.5 yet, add the following to the providers
array in your
\config\app.php
file:
GeneaLabs\LaravelOptimizedPostgres\Providers\LaravelOptimizedPostgresService::class,
Usage
When writing migrations, be sure to remove the following use statement from the top of the file:
use Illuminate\Support\Facades\Schema;
This is included in the two default migrations provided with Laravel projects,
but I don't believe is added when you make
a new migration.
Future Updates
- possibly expand to normalize numbers, more research needed.