GeneaLabs / laravel-optimized-postgres by mikebronner

65,557
37
3
Package Data
Maintainer Username: mikebronner
Maintainer Contact: mike@genealabs.com (Mike Bronner)
Package Create Date: 2017-06-20
Package Last Update: 2023-05-20
Home Page:
Language: PHP
License: MIT
Last Refreshed: 2024-04-27 03:05:00
Package Statistics
Total Downloads: 65,557
Monthly Downloads: 3,096
Daily Downloads: 101
Total Stars: 37
Total Watchers: 3
Total Forks: 1
Total Open Issues: 0

Optimized Postgres for Laravel

Join the chat at https://gitter.im/GeneaLabs/laravel-optimized-postgres

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.