node-pg-migrate Files

• Check https://salsita.github.io/node-pg-migrate/upgrading#from-v8-to-v9 for upgrading guide
• Check https://github.com/salsita/node-pg-migrate/discussions/1635 for future plans

What's Changed

• infra: use merge_group by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1453
• infra: merge_group for semantic PR by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1454
• infra: utilize git clean by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1452
• chore(deps): update pnpm to v10.12.4 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1447
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1445
• chore(deps): update dependency @stylistic/eslint-plugin to v5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1450
• chore(deps): update dependency prettier to v3.6.2 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1449
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1446
• feat: support index based filename naming strategy by @adrenalin in https://github.com/salsita/node-pg-migrate/pull/1443
• fix: remove unused silent option from dotenv config by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1461
• test: remove outdated TODO comment in createTable spec by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1466
• docs: simplify theme config and add tsconfig for Vitepress by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1468
• chore(deps): update pnpm to v10.13.1 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1467
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1456
• feat!: jiti support by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1460
• fix!: throw error when no constraint options are provided in addConstraint by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1462
• fix!: throw error when no policy options are provided in alterPolicy by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1463
• fix!: throw error when no sequence options are provided in alterSequence by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1464
• fix!: throw error when no options are provided in alterTable by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1465
• chore(deps): update dependency dotenv to v17 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1451
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1457
• chore(deps): update dependency @vitest/eslint-plugin to v1.3.4 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1448
• chore(deps): lock file maintenance by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1444
• fix(deps): update dependency yargs to v18 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1426
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1472
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1473
• chore(deps): update dependency eslint-plugin-unicorn to v60 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1475
• refactor!: replace StringIdGenerator with generator function by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1477
• fix!: change indexMethod type from Name to string in operator functions by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1476
• release: 9.0.0-alpha.0 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1479
• infra: add vitest project by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1480
• fix: enable quiet mode in default dotenv config by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1481
• infra: add vitest workspaces and TestContainer by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1478
• chore(deps): update actions/download-artifact action to v5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1491
• chore(deps): update dependency typescript to v5.9.2 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1484
• fix(deps): update dependency jiti to ~2.5.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1487
• chore(deps): update dependency vitepress to v1.6.4 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1490
• feat: add nulls option to createIndex by @jonahkagan in https://github.com/salsita/node-pg-migrate/pull/1489
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1485
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1483
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1486
• release: 9.0.0-alpha.1 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1492
• chore(deps): update actions/upload-pages-artifact action to v4 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1495
• chore(deps): update amannn/action-semantic-pull-request action to v6 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1496
• chore(deps): update actions/checkout action to v5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1494
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1493
• feat: Support JS/TS config file loading in migration CLI by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1505
• chore(deps): update dependency esbuild-fix-imports-plugin to v1.0.22 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1499
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1500
• chore(deps): lock file maintenance by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1474
• release: 9.0.0-alpha.2 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1506
• fix: keep migration file order intact while importing by @benkroeger in https://github.com/salsita/node-pg-migrate/pull/1514
• chore(deps): update actions/setup-node action to v5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1510
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1508
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1509
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1501
• chore(deps): update dependency @vitest/eslint-plugin to v1.3.9 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1507
• chore(deps): remove unused cross-env by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1515
• chore(deps): update dependency eslint-plugin-unicorn to v61 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1511
• chore(deps): lock file maintenance by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1512
• release: 9.0.0-alpha.3 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1516
• chore(deps): update dependency typescript to v5.9.3 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1523
• fix: Ignore default property in FunctionParams while dropping function by @JAPNITSINGH in https://github.com/salsita/node-pg-migrate/pull/1531
• chore(deps): update actions/setup-node action to v6 - autoclosed by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1526
• fix(deps): update dependency jiti to ~2.6.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1522
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1518
• chore(deps): update github artifact actions (major) by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1529
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1521
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1517
• chore(deps): update dependency eslint-plugin-unicorn to v62 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1528
• chore(deps): update dependency @vitest/eslint-plugin to v1.4.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1520
• fix: allow falsy default values in function by @therealsujitk in https://github.com/salsita/node-pg-migrate/pull/1533
• release: 9.0.0-alpha.4 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1534
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1539
• chore(deps): update actions/checkout action to v6 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1542
• fix(deps): update dependency glob to ~11.1.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1543
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1538
• chore(deps): update dependency @eslint/compat to v2 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1540
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1535
• chore(deps): update vitest to v4 (major) by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1530
• chore(deps): update vitest by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1537
• chore(deps): update dependency prettier to v3.7.4 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1545
• chore(deps): update dependency typescript-eslint to v8.49.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1546
• chore(deps): update pnpm to v10.25.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1548
• fix(deps): update dependency glob to v13 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1549
• chore: upgrade supported db systems by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1550
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1547
• chore(deps): lock file maintenance by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1519
• release: 9.0.0-alpha.5 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1551
• docs: fix typo by @PirAhmedShah in https://github.com/salsita/node-pg-migrate/pull/1556
• feat: handle PgLiteral in index expressions by @brenoepics in https://github.com/salsita/node-pg-migrate/pull/1561
• chore: add eslint-plugin-import-x by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1562
• chore(deps): update github artifact actions (major) by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1554
• chore(deps): update vitest by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1558
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1559
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1552
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1553
• chore(deps): lock file maintenance by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1555
• release: 9.0.0-alpha.6 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1563
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1564
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1565
• chore(deps): update vitest by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1569
• chore(deps): update dependency prettier to v3.8.1 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1567
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1566
• chore(deps): lock file maintenance by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1568
• chore: switch to trusted publishing by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1571
• fix: use type-only import in TypeScript migration template by @shimscho in https://github.com/salsita/node-pg-migrate/pull/1579
• chore(deps): update github artifact actions (major) by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1576
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1572
• chore(deps): lock file maintenance by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1575
• chore(deps): update eslint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1573
• chore(deps): update vitest by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1577
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1574
• chore(deps): update eslint (major) by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1570
• chore: update license year by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1580
• release: 9.0.0-alpha.7 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1581
• feat: Add migration loader strategies with SQL grouping and docs by @peturv in https://github.com/salsita/node-pg-migrate/pull/1582
• release: 9.0.0-alpha.8 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1583
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1590
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1586
• chore(deps): update vitest by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1584
• chore(deps): update actions/configure-pages action to v6 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1591
• chore(deps): update actions/deploy-pages action to v5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1592
• chore(deps): update pnpm/action-setup action to v5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1588
• chore: switch from eslint to oxlint by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1594
• chore: switch from prettier to oxfmt by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1595
• chore: switch from tsup to tsdown by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1596
• chore(deps): update davelosert/vitest-coverage-report-action action to v2.11.1 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1597
• chore(deps): update dependency typescript to v6 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1599
• release: 9.0.0-alpha.9 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1600
• infra: add dotenv renovate group by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1601
• chore(deps): update dependency @types/node to v20.19.39 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1598
• chore(deps): update pnpm/action-setup action to v6 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1609
• chore(deps): update actions/upload-pages-artifact action to v5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1608
• chore(deps): update vitest to v4.1.4 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1603
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1602
• chore(deps): update devdependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1606
• chore(deps): update dependency @types/config to v4 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1587
• chore(deps): update dependency oxfmt to v0.45.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1605
• chore(deps): update oxlint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1607
• chore(deps): update dependency tsdown to v0.21.10 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1611
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1613
• chore(deps): update oxlint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1614
• chore(deps): update dependency typescript to v6.0.3 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1612
• chore(deps): update dependency oxfmt to v0.47.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1618
• chore(deps): update oxlint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1619
• chore(deps): update pnpm to v10.33.2 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1616
• chore(deps): update vitest to v4.1.5 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1617
• fix(deps): update dependency jiti to ~2.7.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1625
• chore(deps): update dependency oxfmt to v0.49.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1623
• chore(deps): update dependency oxlint to v1.64.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1624
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1621
• chore(deps): update vitest to v4.1.6 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1630
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1631
• chore(deps): update oxlint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1633
• chore(deps): update dependency oxfmt to v0.50.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1632
• docs: add @brenoepics and @osdiab as co-maintainers by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1634
• feat: Create new files ext by @beterrabaA in https://github.com/salsita/node-pg-migrate/pull/1636
• release: 9.0.0-alpha.10 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1637
• chore(deps): update vitest to v4.1.7 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1640
• chore(deps): update dependency node to v24.16.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1641
• docs: Fix documentation of JSON config options by @acoulton in https://github.com/salsita/node-pg-migrate/pull/1627
• chore(deps): update pnpm to v10.34.1 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1646
• feat: introduce advisory lock mode by @nemisj in https://github.com/salsita/node-pg-migrate/pull/1648
• chore(deps): update all non-major dependencies to v6.0.3 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1649
• feat: add jiti tsconfigPaths option for migrations by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1645
• release: 9.0.0-alpha.11 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1651
• feat: support array column type option by @dosacha in https://github.com/salsita/node-pg-migrate/pull/1653
• feat: support IF EXISTS table guard for dropConstraint by @dosacha in https://github.com/salsita/node-pg-migrate/pull/1654
• feat: add renameIndex method by @beterrabaA in https://github.com/salsita/node-pg-migrate/pull/1638
• chore(deps): update actions/checkout action to v7 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1655
• chore(deps): update all non-major dependencies by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1652
• chore(deps): update vitest to v4.1.9 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1650
• chore(deps): update dependency oxfmt to v0.57.0 by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1642
• chore(deps): update oxlint by @renovate[bot] in https://github.com/salsita/node-pg-migrate/pull/1643
• release: 9.0.0-alpha.12 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1656
• docs: programmatic api example by @mrl5 in https://github.com/salsita/node-pg-migrate/pull/1657
• docs: add v8 to v9 upgrading guide by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1662
• release: 9.0.0 by @Shinigami92 in https://github.com/salsita/node-pg-migrate/pull/1663

New Contributors

• @adrenalin made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1443
• @jonahkagan made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1489
• @JAPNITSINGH made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1531
• @therealsujitk made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1533
• @PirAhmedShah made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1556
• @shimscho made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1579
• @peturv made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1582
• @beterrabaA made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1636
• @acoulton made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1627
• @nemisj made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1648
• @dosacha made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1653
• @mrl5 made their first contribution in https://github.com/salsita/node-pg-migrate/pull/1657

Full Changelog: https://github.com/salsita/node-pg-migrate/compare/v8.0.4...v9.0.0