Fixed

• Laravel 13.8 support for SortDirection enum

Added

• Laravel 13 support
• $start and $end parameter of TimescaleDB CreateRefreshPolicy action are now optional

Fixed

• TimescaleDB Continuous Aggregates now work with Laravel table prefixes (#130)
• Eloquent Builder insertReturning and insertUsingReturning did not set wasRecentlyCreated flag (#128)

Changed

• Removed tsvector() blueprint type param to be compatible with Laravel 12.54.0 (#129)

Added

• fulltext search mode=none (#122)

Added

• temporal indexes (primary key, unique constraint, foreign key) (#117)
• configurable search_path for functions (#119)

Added

• New boolean $native parameter for Uuid7 expression (#117)

Added

• notEnforced() foreign key constraint definition (#117)

Fixed

• Unit tests failed when TimescaleDB extension was not installed
• db:wipe --drop-views could fail when TimescaleDB extension was not installed

Fixed

• Removed the @internal tag from column/index definition classes beause PHPStan complained when using them (#109)
• Join queries couldn't use the added where*() methods (#110)
• Escaping functionality was always using the write connection (#112).

Changed

• Added new Timescale actions for the columnstore and deprecated the old ones for compression.

Backward Incompatible Changes

• Changed the trigger definition when() method to whenCondition() to solve conflict with Laravel 12.10.0
• Changed dependencies to depend on laravel/framework instead of distinct illuminate/* packages

Fixed

• Support Laravel's new transaction onFailure callback (laravel/framework#55338)

Added

• upsertPartial to do upserts when partial indexes are used

Fixed

• Type errors with db:wipe when dropping tables/views on PG databases without Timescale extension

Fixed

• Hypertable/ContinuousAggreate/(Materialized)View dropping will now respect connections dont_drop setting
• Added some views from popular extensions to the dont-drop-list for views

Fixed

• (or)WhereNotLike query build did not use the negation in the query
• The (or)Where(Not)Like query builder methods did not cast the column to text like in Laravel (col::text)

Fixed

• Artisan migrate:fresh support for materialized views
• Artisan migrate:fresh --drop-views support for Timescale hypertables and continuous aggregates

Added

• Laravel 12 support

Added

• Timescale migration support

Added

• JsonForceEmptyObjectAsArray eloquent cast

Fixed

• PHP 8.4 deprecation warnings because of implicitly marked nullable parameters

Fixed

• Laravel 11.30 compatability ($dimension parameter of vector migration type is now optional)

Backward Incompatible Changes

• The dimensions value for the vector migration type is now required to copy the behavior of Laravel 11.25.0

Fixed

• Support PostgreSQL's ^@ starts with operator.

Fixed

• Eager loading and lazy loading prevention was not implemented for lazyByCursor()

Added

• orderByNullsFirst, orderByNullsLast and $nulls parameter for orderBy

Fixed

• Migration failed when automatic aliases had been disabled in Laravel

Backward Incompatible Changes

• The whereLike and orWhereLike had been changed to the behavior of Laravel 11.17.0

Fixed

• Migration failed when automatic aliases had been disabled in Laravel

Fixed

• Changes to adapt to bc-breaking migration behavior of Laravel 11.15.0

Fixed

• Changing compression mode conflicted with upstream Laravel 11.x changes

Added

• PHPStan Extension Installer Support
• Doctrine DBAL 4 Support (deep Laravel 11 dependency)

Added

• concurrently() modifier for index creation

Added

• UUIDv7 expression

Added

• Laravel 11 compatibility

Fixed

• Incompatability with Laravel 10.47.0

Breaking Changes

• Some query builder methods had to be changed because they've now overlapped with new ones added by Laravel 10.47:
  • whereAll -> whereAllValues
  • whereNotAll -> whereNotAllValues
  • orWhereAll -> orWhereAllValues
  • orWhereNotAll -> orWhereNotAllValues
  • whereAny -> whereAnyValue
  • whereNotAny -> whereNotAnyValue
  • orWhereAny -> orWhereAnyValue
  • orWhereNotAny -> orWhereNotAnyValue

Added

• IDE autocomplete support for PhpStorm with Laravel Idea plugin

Fixed

• Table prefixes had been ignored by query grammar

Added

• USING clause for column type migrations

Added

• pgvector support: vector type, eloquent cast, query builder similarity sorting

Added

• Alternative column names for views

Added

• Integer array type for migrations
• Integer array cast for eloquent
• whereIntegerArrayMatches query builder method

Fixed

• Support Laravel 10.13 grammar escaping for values

Added

• Automatic date format traits for eloquent models

Added

• Initial column modifier

Added

• Tables can be set unlogged
• Table storage parameters can be set

Fixed

• rawIndex definitions had not been handled correctly

Added

• Triggers can be added to tables

Added

• Laravel 10.x compatibility

Fixed

• Provide doctrine data types for all console operations to support schema inspection tools

Added

• Domain types support for migrations

Added

• Extensions can be added to specific schemas

Fixed

• The recursive keyword was added multiple times when multiple recursive CTEs had been added

Changed

• Adding the same CTE multiple times now only keeps the last one

Added

• Methods with query param now use Laravel 9 query contract for doctype to do better PHPStan type checking

Added

• Functions created in migrations can also return tables
• Unique indexes with NULLS NOT DISTINCT options

Added

• whereAll clause for query builder
• whereAny clause for query builder
• whereBoolean clause for query builder
• whereBetweenSymmetric clause for query builder

Fixed

• Manually created \Illuminate\Database\Query\Builder instances failed when trying to process CTE expressions

Added

• Creating and deleting functions in migrations

Added

• Column Types:
  • bigIntegerMultiRange
  • dateMultiRange
  • decimalMultiRange
  • integerMultiRange
  • timestampMultiRange
  • timestampTzMultiRange

Added

• Common Table Expressions

Added

• PostgreSQL returning statements for eloquent builder:
  • deleteReturning
  • forceDeleteReturning
  • insertOrIgnoreReturning
  • insertReturning
  • insertUsingReturning
  • updateFromReturning
  • updateOrInsertReturning
  • updateReturning
  • upsertReturning

Added

• whereLike clause for query builder

Fixed

• Rolling back migrations failed with type error since 0.14.0

Added

• Support for left later joins with an 'ON true' condition

Added

• PHPStan support for all extensions to Laravel

Added

• lazyByCursor for Query\Builder and Eloquent\Builder

Fixed

• Changed returning statements to return a collection instead of array like Query\Builder::get()

Breaking Change

• The return type of all returning statements was changed from array to Collection to replicate the Query\Builder::get() method signature.

Added

• Materialized views

Added

• PostgreSQL returning statements for query builder:
  • deleteReturning
  • insertOrIgnoreReturning
  • insertReturning
  • insertUsingReturning
  • updateFromReturning
  • updateOrInsertReturning
  • updateReturning
  • upsertReturning
• Eloquent concern RefreshDataOnSave

Breaking Change

• The ZeroDowntimeMigration concern namespace moved from Tpetry\PostgresqlEnhanced\Concerns to Tpetry\PostgresqlEnhanced\Schema\Concerns

Added

• Laravel 9 compatibility

Added

• If exists fulltext index dropping
• Partial index support for fulltext indexes
• Storage parameters support for fulltext indexes
• Column weighting for fulltext indexes and query builder

Added

• Lateral Subquery Joins for Query Builder

Fixed

• PostgreSQL specific explain output on Eloquent\Builder instances

Added

• PostgreSQL specific explain output on Query\Builder instances

Fixed

• Zero Downtime Migration support for Laravel 6.x and 7.x

Added

• Zero Downtime Migrations

Changed

• The internal grammar name for the PostgreSQL types has been changed to their native names

Added

• Identity column type
• Tsvector column type
• Functional Indexes
• Column Index Options
• Column compression modifier

Added

• Index Storage Parameters
• Index Include Columns

Fixed

• Query Builder to raw query string did use integer instead of boolean literal for boolean values

Changed

• Partial indexes are no longer extra functions of the table blueprint, they are now index options

Fixed

• Query builder to sql helper's typing did not allow eloquent builder

Added

• If exists index dropping
• Partial indexes

Fixed

• Service Provider no longer extends DatabaseServiceProvider (#1)

Added

• Extension Management
• View Management

Added

• Column Types:
  • bigIntegerRange
  • bit
  • caseInsensitiveText
  • dateRange
  • decimalRange
  • europeanArticleNumber13
  • hstore
  • integerRange
  • internationalStandardBookNumber
  • internationalStandardBookNumber13
  • internationalStandardMusicNumber
  • internationalStandardMusicNumber13
  • internationalStandardSerialNumber
  • internationalStandardSerialNumber13
  • ipNetwork
  • labelTree
  • timestampRange
  • timestampTzRange
  • universalProductNumber
  • varbit
  • xml