Looking to hire Laravel developers? Try LaraJobs

laravel-optimized-postgres maintained by genealabs

Description
optimizes field types for Postgres.
Author
Mike Bronner
Last update
2026/03/28 23:10 (dev-master)
License
MIT
Links
GitHub - Packagist
Downloads
315 511

dev-master

Last update
2026/03/28 23:10
License
MIT
Require
  • php ^8.2
  • illuminate/database ^10.0|^11.0|^12.0|^13.0
  • illuminate/support ^10.0|^11.0|^12.0|^13.0
13.0.0

Last update
2026/03/28 23:10
License
MIT
Require
  • php ^8.2
  • illuminate/database ^10.0|^11.0|^12.0|^13.0
  • illuminate/support ^10.0|^11.0|^12.0|^13.0
dev-feat/23-add-laravel-13-support

Last update
2026/03/28 23:08
License
MIT
Require
  • php ^8.2
  • illuminate/database ^10.0|^11.0|^12.0|^13.0
  • illuminate/support ^10.0|^11.0|^12.0|^13.0
dev-feat/24-add-php-8-5-support

Last update
2026/03/01 09:25
License
MIT
Require
  • php ^8.2
  • illuminate/database ^10.0|^11.0|^12.0
  • illuminate/support ^10.0|^11.0|^12.0
12.0.1

Last update
2025/05/20 01:17
License
MIT
Require
  • php ^8.2
  • illuminate/database ^10.0|^11.0|^12.0
  • illuminate/support ^10.0|^11.0|^12.0
12.0.0

Last update
2025/05/20 00:51
License
MIT
Require
  • php ^8.2
  • illuminate/database ^10.0|^11.0|^12.0
  • illuminate/support ^10.0|^11.0|^12.0
10.0.0

Last update
2023/05/20 22:43
License
MIT
Require
  • php ^8.2
  • illuminate/database ^10.0
  • illuminate/support ^10.0
0.5.1

Last update
2022/03/21 23:07
License
MIT
Require
  • php ^8.0
  • illuminate/database ^9.0
  • illuminate/support ^9.0
0.5.0

Last update
2022/02/22 12:35
License
MIT
Require
  • php ^8.0
  • illuminate/database ^5.4|^6.0|^7.0|^8.0|^9.0
  • illuminate/support ^5.4|^6.0|^7.0|^8.0|^9.0
0.4.0

Last update
2020/11/04 01:22
License
MIT
Require
  • php >=7.1.3
  • illuminate/database ^5.4|^6.0|^7.0|^8.0
  • illuminate/support ^5.4|^6.0|^7.0|^8.0
0.3.2

Last update
2019/10/03 01:06
License
MIT
Require
  • php >=7.1.3
  • illuminate/database ^5.4|^6.0
  • illuminate/support ^5.4|^6.0
0.3.0

Last update
2019/08/29 05:39
License
MIT
Require
  • php >=7.1.3
  • illuminate/database 5.4 - 6.0
  • illuminate/support 5.4 - 6.0
0.2.0

Last update
2019/06/12 20:03
License
MIT
Require
  • php >=7.1.3
  • illuminate/database 5.4 - 5.8
  • illuminate/support 5.4 - 5.8
0.1.3

Last update
2018/03/12 04:16
License
MIT
Require
  • php >=7.0.0
  • illuminate/database ^5.4
  • illuminate/support ^5.4
0.1.2

Last update
2017/11/20 01:02
License
MIT
Require
  • php >=7.0.0
  • illuminate/database >=5.4
  • illuminate/support >=5.4
0.1.1

Last update
2017/06/21 03:22
License
MIT
Require
  • php >=7.0.0
  • illuminate/database >=5.4
  • illuminate/support >=5.4
0.1.0

Last update
2017/06/21 03:13
License
MIT
Require
  • illuminate/database >=5.4
  • illuminate/support >=5.4
Comments
comments powered by Disqus

Optimized Postgres for Laravel

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 8.2+
  • Laravel 10, 11, 12, or 13

Version Support

PHP Laravel Support
8.2 10, 11 ✅
8.3 10, 11, 12, 13 ✅
8.4 10, 11, 12, 13 ✅
8.5 10, 11, 12, 13 ✅

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.