Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
url
option based on the dialect (#17252) (f05281c)bulkDeleteQuery
supported options (#17191) (c53fd01)ModelRepository#_UNSTABLE_bulkDestroy
and manual ON DELETE
handling (#17078) (45ac01a)@sequelize/cli
as a replacement for sequelize-cli
(#17195) (ec00aed)seed generate
command (#17262) (b07ad40)@sequelize/db2
package (#17197) (6aa4ced)@sequelize/postgres
package (#17190) (721d560)@sequelize/mssql
package (#17206) (8631f5a), closes #17206
@sequelize/db2-ibmi
package (#17209) (21772a5), closes #17209
@sequelize/mysql
package (#17202) (5c7830e), closes #17202
@sequelize/mariadb
package (#17198) (46ea159), closes #17198
db2
, ibmi
, snowflake
and sqlite
do not accept the url
option anymore"url"
option.dialectOptions
option has been removed. All options that were previously in that object can now be set at the root of the option bag, like all other options.sequelize.pool
sequelize.config
field has been removed. Everything related to connecting to the database has been normalized to sequelize.options.replication.write
(always present) and sequelize.options.replication.read
(only present if read-replication is enabled)sequelize.options
is now fully frozen. It is no longer possible to modify the Sequelize options after the instance has been created.sequelize.options
is a normalized list of option. If you wish to access the options that were used to create the sequelize instance, use sequelize.rawOptions
':memory:'
anymore, but sequelize.sqlite
in your current working directory.':memory:'
or ''
requires configuring the pool to behave like a singleton, and disallowed read replicationmatch
option is no longer supported by sequelize.sync
. If you made use of this feature, let us know so we can design a better alternative.dialectModulePath
has been fully removed to improve compatibility with bundlers.dialectModule
option has been split into multiple options. Each option is named after the npm library that is being replaced. For instance, @sequelize/postgres
now accepts pgModule
. @sequelize/mssql
now accepts tediousModule
pg
package, users need to install @sequelize/postgres
.tedious
package, users need to install @sequelize/mssql
.odbc
package, users need to install @sequelize/db-ibmi
.mysql2
, users need to install @sequelize/mysql
.mariadb
package, users need to install @sequelize/mariadb
.ibm_db
package, users need to install @sequelize/db2
.snowflake-sdk
package, users need to install @sequelize/snowflake
.@sequelize/utils
package. This package still needs to be improved but is meant to be a general-purpose utility library, not specific to Sequelize (#17168) (1d96a59)Model._UNSTABLE_destroyMany
(#17031) (1fead8a)MACADDR8
DataType (#17059) (c64b3c2)