Skip to main content
Version: 6.4

Changelog

All notable changes to this project will be documented in this file. See Conventional Commits for commit guidelines.

6.4.16 (2025-05-30)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.15 (2025-05-09)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.14 (2025-05-05)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.13 (2025-04-12)​

Bug Fixes​

  • postgres: fix schema diffing for default and nullable of check constraint enums (#6572) (db9b0bf), closes #6571

6.4.12 (2025-04-06)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.11 (2025-03-21)​

Bug Fixes​

  • postgres: cockroachdb may not require unmarshallArray (#6501) (0661942)

6.4.10 (2025-03-16)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.9 (2025-03-07)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.8 (2025-03-06)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.7 (2025-02-22)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.6 (2025-02-12)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.5 (2025-01-30)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.4 (2025-01-23)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.3 (2025-01-08)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.2 (2024-12-22)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.1 (2024-12-08)​

Note: Version bump only for package @mikro-orm/postgresql

6.4.0 (2024-11-11)

Bug Fixes​

  • postgres: return all results for multi statement raw queries (adcef5f), closes #6009

6.3.13 (2024-10-06)​

Bug Fixes​

  • postgres: improve schema diffing for native enums with explicit schema (#6114) (fa537b1), closes #6101

6.3.12 (2024-10-01)​

Note: Version bump only for package @mikro-orm/postgresql

6.3.11 (2024-09-26)​

Bug Fixes​

  • core: support atomic updates on properties with custom types (951284b), closes #6030
  • postgres: set max identifier length to 63 characters (5b866fa), closes #6042

6.3.10 (2024-09-15)​

Note: Version bump only for package @mikro-orm/postgresql

6.3.9 (2024-09-09)​

Bug Fixes​

  • postgres: fix diffing vector columns without length (2f7a7fb), closes #6008

6.3.8 (2024-09-04)​

Bug Fixes​

  • schema: change default of disableForeignKeys to false (#5993) (8a8aa2d)

6.3.7 (2024-08-28)​

Note: Version bump only for package @mikro-orm/postgresql

6.3.6 (2024-08-14)​

Bug Fixes​

  • postgres: do not cast json columns to text (574390b), closes #5936

6.3.5 (2024-08-11)​

Bug Fixes​

  • entity-generator: ensure columnType is emitted correctly and when necessary (#5930) (72333ad), closes #5928
  • postgres: detect native enums with same name but different schema (31735e5), closes #5905
  • postgres: do not produce extra updates for fulltext properties (d18e5ed), closes #5908
  • postgres: respect timezone option and interpret timestamp columns in UTC by default (#5916) (1da0722), closes #5591

6.3.4 (2024-08-06)​

Note: Version bump only for package @mikro-orm/postgresql

6.3.3 (2024-08-03)​

Note: Version bump only for package @mikro-orm/postgresql

6.3.2 (2024-08-01)​

Note: Version bump only for package @mikro-orm/postgresql

6.3.1 (2024-07-25)​

Note: Version bump only for package @mikro-orm/postgresql

6.3.0 (2024-07-18)

Bug Fixes​

  • postgres: implement diffing support for vector type (9eadac1), closes #5739
  • postgres: put new native enum values into the correct position (f79e3bc), closes #5791
  • postgresql: ignore tables that use inheritance during schema diffing (#5648) (55f452a)
  • postgres: respect empty string in enum items (c02f12e), closes #5751
  • postgres: support enum arrays with special characters (54b30cb), closes #5781

Features​

  • core: addz Platform.getDefaultVarcharLength and optional Type.getDefaultLength (#5749) (29dcdeb)
  • core: implement "character" type (DB type "char") (#5684) (9fa5fad)
  • postgres: allow specifying deferred mode on unique constraints (#5537) (7672b56)
  • postgres: support on delete set null/default with subset of columns (5353e6a), closes #5568
  • postresql: add support for varchar with unlimited length (#5707) (c22e971)

6.2.9 (2024-05-31)​

Bug Fixes​

  • postgres: respect deferMode option in 1:1 relations (#5641) (101c0a8)

6.2.8 (2024-05-21)​

Note: Version bump only for package @mikro-orm/postgresql

6.2.7 (2024-05-18)​

Note: Version bump only for package @mikro-orm/postgresql

6.2.6 (2024-05-14)​

Bug Fixes​

  • core: fix mapping of Date properties from bigint values (05c802b), closes #5540

6.2.5 (2024-05-05)​

Note: Version bump only for package @mikro-orm/postgresql

6.2.4 (2024-05-02)​

Note: Version bump only for package @mikro-orm/postgresql

6.2.3 (2024-04-24)​

Note: Version bump only for package @mikro-orm/postgresql

6.2.2 (2024-04-20)​

Bug Fixes​

  • postgres: support wildcard native enums (e183de3), closes #5456

6.2.1 (2024-04-12)​

Note: Version bump only for package @mikro-orm/postgresql

6.2.0 (2024-04-09)

Bug Fixes​

  • entity-generator: allow arbitrary class and prop names as identifiers (#5359) (b0c0236)
  • postgres: drop text enum check constraints only when necessary (#5414) (5162345), closes #4112
  • postgres: removed erroneous duplicates in FK discovery query (#5376) (eec2b38)

Features​

  • mssql: add MS SQL Server driver (#1375) (eeaad45), closes #771
  • postgres: allow defining deferred FK constraints (#5384) (f42d171), closes #5306
  • schema: improve orm.schema.execute() to support executing batches (3c5a347)

6.1.12 (2024-03-24)​

Bug Fixes​

  • postgres: fix query for loading all foreign keys from existing schema (2eb85d5), closes #5364

Performance Improvements​

  • postgres: try to optimize loading of foreign keys (2dff96b), closes #5364

6.1.11 (2024-03-18)​

Note: Version bump only for package @mikro-orm/postgresql

6.1.10 (2024-03-14)​

Bug Fixes​

  • postgres: fix diffing of native enums (create/remove via schema:update) (7c8be79), closes #5322
  • schema: support compound index over JSON property and a regular column (319df49), closes #5333

Features​

  • postgres: provide more details in driver exceptions (e782d06)

6.1.9 (2024-03-10)​

Features​

  • postgres: add support for native enum arrays (c2e362b), closes #5322

6.1.8 (2024-03-06)​

Note: Version bump only for package @mikro-orm/postgresql

6.1.7 (2024-03-04)​

Note: Version bump only for package @mikro-orm/postgresql

6.1.6 (2024-02-28)​

Note: Version bump only for package @mikro-orm/postgresql

6.1.5 (2024-02-21)​

Note: Version bump only for package @mikro-orm/postgresql

6.1.4 (2024-02-16)​

Note: Version bump only for package @mikro-orm/postgresql

6.1.3 (2024-02-13)​

Bug Fixes​

  • postgres: implement casting for JSON queries on types like double or bigint (b00eae6), closes #5239

6.1.2 (2024-02-11)​

Note: Version bump only for package @mikro-orm/postgresql

6.1.1 (2024-02-10)​

Bug Fixes​

  • postgres: declare dependency on postgres-array (e73fd1a)
  • postgres: fix parsing of date properties inside object emebddables (760ec77), closes #5216

6.1.0 (2024-02-04)

Bug Fixes​

  • postgres: improve diffing of native postgres enums (49d6b4d), closes #5108

Features​

  • core: allow mapping array columns to arrays of objects via ArrayType (#5204) (42cc9cc), closes #5188

6.0.7 (2024-01-30)​

Features​

  • postgres: add support for interval type (659a613), closes #5181

6.0.6 (2024-01-29)​

Note: Version bump only for package @mikro-orm/postgresql

6.0.5 (2024-01-18)​

Note: Version bump only for package @mikro-orm/postgresql

6.0.4 (2024-01-15)​

Note: Version bump only for package @mikro-orm/postgresql

6.0.3 (2024-01-13)​

Note: Version bump only for package @mikro-orm/postgresql

6.0.2 (2024-01-09)​

Note: Version bump only for package @mikro-orm/postgresql

6.0.1 (2024-01-08)​

Note: Version bump only for package @mikro-orm/postgresql

6.0.0 (2024-01-08)

Bug Fixes​

  • core: refactor mapping of Date properties (#4391) (3a80369), closes #4362 #4360 #1476
  • core: rework pivot table joining (#4438) (0506d36), closes #4423
  • entity-generator: use index expressions for complex indexes (e.g. conditional) (64a39f8), closes #4911
  • postgres: allow using array operators (e.g. @>) with object arrays (ca8795a), closes #4973
  • postgres: parse timestamp dates less than year 100 (e774d40), closes #5071
  • postgres: respect column length in down migrations (d49d13c), closes #5048

Features​

5.9.2 (2023-11-02)​

Note: Version bump only for package @mikro-orm/postgresql

5.9.1 (2023-10-31)​

Note: Version bump only for package @mikro-orm/postgresql

5.9.0 (2023-10-24)

Note: Version bump only for package @mikro-orm/postgresql

5.8.10 (2023-10-18)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.9 (2023-10-15)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.8 (2023-10-11)​

Bug Fixes​

  • postgres: escape array literal values containing backslash (#4797) (20179ec), closes #4796

5.8.7 (2023-10-05)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.6 (2023-10-02)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.5 (2023-09-30)​

Bug Fixes​

  • core: pin all internal dependencies (f4868ed), closes #4764

5.8.4 (2023-09-27)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.3 (2023-09-24)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.2 (2023-09-20)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.1 (2023-09-12)​

Note: Version bump only for package @mikro-orm/postgresql

5.8.0 (2023-09-10)

Note: Version bump only for package @mikro-orm/postgresql

5.7.14 (2023-07-27)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.13 (2023-07-16)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.12 (2023-06-10)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.11 (2023-06-01)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.10 (2023-05-23)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.9 (2023-05-22)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.8 (2023-05-21)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.7 (2023-05-14)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.6 (2023-05-13)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.5 (2023-05-09)​

Bug Fixes​

  • postgres: improve enum/check constraint inspection in schema diffing (6c44b42), closes #4312

5.7.4 (2023-05-01)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.3 (2023-04-28)​

Bug Fixes​

  • postgres: do not convert date column type to Date object automatically (a7d1d09), closes #4194 #4276

5.7.2 (2023-04-25)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.1 (2023-04-25)​

Note: Version bump only for package @mikro-orm/postgresql

5.7.0 (2023-04-23)

Bug Fixes​

5.6.16 (2023-04-04)​

Reverts​

  • Revert "chore(release): v5.6.16 [skip ci]" (49faac9)
  • Revert "chore(release): update internal dependencies to use tilde [skip ci]" (381cba1)

5.6.15 (2023-03-18)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.14 (2023-03-12)​

Bug Fixes​

  • postgres: use explicit schema in table identifier when altering comments (#4123) (60d96de), closes #4108

5.6.13 (2023-03-01)​

Bug Fixes​

  • postgres: use quoted schema+table name when dropping constraints (#4079) (ff1dfb6)

5.6.12 (2023-02-26)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.11 (2023-02-17)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.10 (2023-02-17)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.9 (2023-02-10)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.8 (2023-01-25)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.7 (2023-01-13)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.6 (2023-01-10)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.5 (2023-01-09)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.4 (2023-01-04)​

Bug Fixes​

  • core: improve inference of driver exported MikroORM.init() (497f274)

5.6.3 (2022-12-28)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.2 (2022-12-25)​

Note: Version bump only for package @mikro-orm/postgresql

5.6.1 (2022-12-20)​

Bug Fixes​

  • postgres: ignore internal timescale schemas automatically (85d9083)

5.6.0 (2022-12-09)

Bug Fixes​

  • postgres: quote array literal items containing a comma (5ffa81c), closes #3810
  • postgres: use postgres as the management db name + allow override (eab1668), closes #3769
  • query-builder: respect case-insensitive regexp flag (1a1d381), closes #3801

5.5.3 (2022-11-10)​

Bug Fixes​

  • postgres: fix ensuring database exists (d23dde0), closes #3713

5.5.2 (2022-11-07)​

Note: Version bump only for package @mikro-orm/postgresql

5.5.1 (2022-11-05)​

Bug Fixes​

  • postgres: fix ensuring database exists when postgres database does not exist (b1a867d), closes #3671

5.5.0 (2022-10-23)

Bug Fixes​

  • query-builder: support top level $not operator in join condition (#3609) (047504f)

Features​

  • core: add defineConfig helper (#3500) (67d3c68)
  • core: add MikroORM and Options exports to each driver package (#3499) (b68ed47)

Performance Improvements​

  • schema: improve schema inspection speed in SQL drivers (#3549) (74dc3b1)

5.4.2 (2022-09-12)​

Note: Version bump only for package @mikro-orm/postgresql

5.4.1 (2022-09-08)​

Bug Fixes​

  • core: change internal dependencies to use ~ instead of ^ (fdbf67c), closes #3468
  • postgres: fix parsing enum definition when one of the items has comma (c8062cb), closes #3460

5.4.0 (2022-09-01)

Bug Fixes​

  • postgres: fix escaping of special chars in string arrays (#3405) (cd7c42f)

5.3.1 (2022-08-04)​

Note: Version bump only for package @mikro-orm/postgresql

5.3.0 (2022-08-01)

Features​

5.2.4 (2022-07-25)​

Note: Version bump only for package @mikro-orm/postgresql

5.2.3 (2022-07-08)​

Note: Version bump only for package @mikro-orm/postgresql

5.2.2 (2022-07-03)​

Note: Version bump only for package @mikro-orm/postgresql

5.2.1 (2022-06-21)​

Features​

  • core: allow to adjust default type mapping (ca8ce57), closes #3066

5.2.0 (2022-06-10)

Bug Fixes​

  • schema: do not consider autoincrement columns as primary automatically (088afdb), closes #3187
  • typing detection with typescript 4.7 node16 (#3163) (08322fa)

5.1.5 (2022-05-29)​

Note: Version bump only for package @mikro-orm/postgresql

5.1.4 (2022-05-19)​

Bug Fixes​

  • mongo: support queries with mongo specific operators on embeddables (2fb9002)
  • postgres: do not try to create schema for migrations when it exists (d6af811), closes #3106
  • postgres: fix resolving knex when other version is explicitly installed (41f5665), closes #3129
  • postgres: ignore schemas prefixed with crdb_ too (049fea3), closes #3021
  • schema: always ignore PostGIS schemas when diffing (#3096) (626e3db)

Features​

  • postgres: allow ignoring specified schemas (3f1d2da)

5.1.3 (2022-04-27)​

Bug Fixes​

  • postgres: allow using special characters in string arrays (366da5f), closes #3037
  • schema: fix diffing of indexes with too long inferred name (01ba9ed), closes #2932

5.1.2 (2022-04-10)​

Bug Fixes​

  • postgres: do not ignore custom PK constraint names (#2931) (24bf10e)
  • postgres: drop enum constraints only when the column was an enum (76fef39)
  • postgres: ensure correct column order in compound index/uniques (321be79), closes #2932
  • postgres: fix pagination with order by bool column (d5476cd), closes #2910
  • postgres: fix schema diffing on enums with case-sensitive names (050875b), closes #2938 #2932

Features​

5.1.1 (2022-03-20)​

Bug Fixes​

  • postgres: fix pagination with order by UUID PK (042626c), closes #2910

5.1.0 (2022-03-13)

Bug Fixes​

  • core: do not alias JSON conditions on update/delete queries (5c0674e), closes #2839

Features​

  • core: map check constraint failures to specific error type (ebcbdff), closes #2836

5.0.5 (2022-02-27)​

Note: Version bump only for package @mikro-orm/postgresql

5.0.4 (2022-02-22)​

Bug Fixes​

  • schema: escape table/column comments (fff1581), closes #2805

5.0.3 (2022-02-20)​

Bug Fixes​

  • postgres: consider int8 as numeric when inferring autoincrement value (64bc99d), closes #2791

5.0.2 (2022-02-16)​

Bug Fixes​

  • postgres: do not ignore custom PK constraint names (3201ef7), closes #2762

5.0.1 (2022-02-13)​

Note: Version bump only for package @mikro-orm/postgresql

5.0.0 (2022-02-06)

Bug Fixes​

  • core: allow empty strings in postgres arrays (#2680) (5a33722)
  • core: declare peer dependencies on driver packages (1873e8c), closes #2110
  • postgres: fix runtime support for native pg enum arrays (#2584) (fcdb9b0)
  • postgres: limit index names to 64 characters (48c105a), closes #1915
  • schema: improve diffing of default values for strings and dates (d4ac638), closes #2385
  • sql: split $and branches when auto joining to-many relations (70c795a), closes #2677

Features​

BREAKING CHANGES​

  • core: Embeddable instances are now created via EntityFactory and they respect the forceEntityConstructor configuration. Due to this we need to have EM instance when assigning to embedded properties.

Using em.assign() should be preferred to get around this.

Deep assigning of child entities now works by default based on the presence of PKs in the payload. This behaviour can be disable via updateByPrimaryKey: false in the assign options.

mergeObjects option is now enabled by default.

  • core: em.getReference() now has options parameter.

4.5.10 (2021-12-26)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.9 (2021-08-24)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.8 (2021-08-24)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.7 (2021-06-30)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.6 (2021-06-06)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.5 (2021-05-17)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.4 (2021-04-26)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.3 (2021-04-09)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.2 (2021-04-06)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.1 (2021-03-27)​

Note: Version bump only for package @mikro-orm/postgresql

4.5.0 (2021-03-21)

Note: Version bump only for package @mikro-orm/postgresql

4.4.4 (2021-02-21)​

Note: Version bump only for package @mikro-orm/postgresql

4.4.3 (2021-02-14)​

Note: Version bump only for package @mikro-orm/postgresql

4.4.2 (2021-02-04)​

Features​

4.4.1 (2021-02-01)​

Note: Version bump only for package @mikro-orm/postgresql

4.4.0 (2021-01-24)

Features​

4.3.4 (2020-12-11)​

Note: Version bump only for package @mikro-orm/postgresql

4.3.3 (2020-12-04)​

Bug Fixes​

  • schema: fix diffing tables in other than default schema (429d832), closes #1142 #1143

4.3.2 (2020-11-24)​

Note: Version bump only for package @mikro-orm/postgresql

4.3.1 (2020-11-20)​

Bug Fixes​

  • postgres: use ->> to search in object embeddables (78c9373), closes #1091

4.3.0 (2020-11-13)

Bug Fixes​

  • core: pin dependencies (0f3a8e5), closes #961
  • sql: do not batch update unique properties (87b722a), closes #1025
  • sql: inline array parameters when formatting queries (a21735f), closes #1021

4.2.3 (2020-10-24)​

Note: Version bump only for package @mikro-orm/postgresql

4.2.2 (2020-10-22)​

Note: Version bump only for package @mikro-orm/postgresql

4.2.1 (2020-10-20)​

Note: Version bump only for package @mikro-orm/postgresql

4.2.0 (2020-10-18)

Note: Version bump only for package @mikro-orm/postgresql

4.1.1 (2020-10-14)​

Bug Fixes​

  • postgres: escape question marks in parameters (813e3cd), closes #920

4.1.0 (2020-10-12)

Bug Fixes​

  • postgres: do not convert date type columns to Date js objects (2cfb145), closes #864
  • sqlite: rework schema support for composite keys in sqlite (82e2efd), closes #887

Performance Improvements​

  • core: interpolate query parameters at ORM level (742b813), closes #732
  • core: use bulk inserts in all drivers (10f2e55), closes #732
  • core: use JIT compilation for snapshotting entities (5612759), closes #732

4.0.7 (2020-09-24)​

Performance Improvements​

  • core: use batch inserts in UoW (postgres & mongodb) (#865) (54ad928), closes #732

4.0.6 (2020-09-22)​

Note: Version bump only for package @mikro-orm/postgresql

4.0.5 (2020-09-21)​

Bug Fixes​

  • schema: defer creating of composite indexes + implement diffing (f57b457), closes #850

4.0.4 (2020-09-19)​

Note: Version bump only for package @mikro-orm/postgresql

4.0.3 (2020-09-15)​

Note: Version bump only for package @mikro-orm/postgresql

4.0.2 (2020-09-11)​

Note: Version bump only for package @mikro-orm/postgresql

4.0.1 (2020-09-10)​

Note: Version bump only for package @mikro-orm/postgresql

Page Options