{"repo":"umbrellio/laravel-pg-extensions","free":true,"listed":false,"github":"https://github.com/umbrellio/laravel-pg-extensions","clone":"git clone https://github.com/umbrellio/laravel-pg-extensions.git","description":"Laravel extensions for Postgres","language":"PHP","stars":103,"topics":["laravel","postgresql","extensions","database"],"license":"MIT","category":"databases-storage","readme_excerpt":"Laravel PG extensions This project extends Laravel's database layer to allow use specific Postgres features without raw queries. Installation Run this command to install: Features - Extended Schema::create() - Added Support NUMERIC Type - Extended Schema with USING - Extended Schema for views - Working with UNIQUE indexes - Working with EXCLUDE constraints - Working with CHECK constraints - Working with partitions - Check existing index before manipulation - Getting foreign keys for table Extended table creation Example: Extended Schema USING Example: Create views Example: Get foreign keys Example: Extended unique indexes creation Example: If you want to delete partial unique index, use this method: $table- dropUnique() doesn't work for Partial Unique Indexes, because PostgreSQL doesn't define a partial (ie conditional) UNIQUE constraint. If you try to delete such a Partial Unique Index you will get an error. When you create a unique index without conditions, PostgresSQL will create Unique Constraint automatically for you, and when you try to delete such an index, Constraint will be deleted first, then Unique Index. Exclude constraints creation Using the example below: An Exclude Constraint will be generated for your table: Check constraints creation Using the example below: An Check Constraint will be generated for your table: Partitions Support for attaching and detaching partitions. Example: Check existing index Numeric column type Unlike standard laravel decimal type, thi","default_branch":null,"files":null,"tree":[],"storefront":"/r/umbrellio","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/umbrellio/laravel-pg-extensions/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}