Download the PHP package efureev/laravel-support-db without Composer
On this page you can find all versions of the php package efureev/laravel-support-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download efureev/laravel-support-db
More information about efureev/laravel-support-db
Files in efureev/laravel-support-db
Package laravel-support-db
Short Description PostgreSQL features for Laravel's schema and query builders: partial indexes, views, CREATE TABLE LIKE, extensions, RETURNING, and PostgreSQL-only column types
License MIT
Informations about the package laravel-support-db
laravel-support-db
PostgreSQL features for Laravel's schema and query builders.
Laravel's builders cover what every database can do. This package adds the PostgreSQL parts they
leave out — partial indexes, views, CREATE TABLE … LIKE, extensions, RETURNING, and the
PostgreSQL-only column types — using the same fluent style, so they read like the rest of a
migration.
It extends; it does not replace. Everything the framework already does keeps working unchanged.
Install
It registers itself through package discovery — no provider to add, no config to publish. Type-hint
the package's Blueprint in migrations to get the additions in your editor:
| Version | |
|---|---|
| PHP | >= 8.5 |
| Laravel | >= 13.0 (illuminate/database) |
| PostgreSQL | 13 – 18, every one of them exercised in CI |
compression() needs PostgreSQL 14 and nullsNotDistinct() needs 15; everything else works from
- The package takes effect on
pgsqlconnections only — other drivers on the same application are untouched.
Documentation
Read it at https://efureev.github.io/laravel-support-db/, or as markdown in
docs/.
The
docs/directory is not shipped in the Composer package — it would be dead weight invendor/— which is why the links below are absolute.
| Page | Covers |
|---|---|
| Getting started | Requirements, version floors, how the package hooks in, a first migration |
| Columns | The PostgreSQL-only column types, UUID key generation, TOAST compression |
| Indexes | Partial and unique-partial indexes, predicates, modifiers, GIN operator classes |
| Views | Plain and materialized views — create, refresh, inspect, drop, other schemas |
| Schema operations | CREATE TABLE … LIKE / AS TABLE / AS SELECT, DROP … CASCADE, extensions |
| Query builder | RETURNING on UPDATE and DELETE |
| Recipes | Thirteen realistic problems worked end to end |
| Behaviour notes | The things that are easy to trip over, and what Laravel 13 already does itself |
| Testing & contributing | Running the suite, and the gate a pull request has to pass |
What it adds
Partial and unique-partial indexes with a fluent WHERE · CREATE INDEX CONCURRENTLY and
NULLS NOT DISTINCT on them · GIN indexes with an operator class · views, including materialized
ones, with schema-qualified lookups · CREATE TABLE … LIKE / AS SELECT / AS TABLE ·
DROP TABLE … CASCADE · CREATE / DROP EXTENSION · column compression ·
UPDATE / DELETE … RETURNING · and shorthands for bit, numeric, xml, cidr, daterange,
tsrange, the geometric types, the array types, and UUID primary keys that need no extension.
Contributing
Issues and pull requests are welcome — see Testing & contributing for the gate CI runs.
License
MIT — see LICENSE.