Sequelize v6.12 released, Node.js ORM
When you start building web applications and APIs you often need something that interacts with databases for you. Maintaining relationships between tables, fetching related records and managing transactions gets very repetitive over time when using just raw queries. Sequelize abstracts these tasks away for you and provides you with a database layer.
It provides simple access to MySQL, MariaDB, SQLite and PostgreSQL databases by mapping database entries to objects or object-to-database entries. In short, ORM (Object-Relational-Mapper). It is written entirely in JavaScript and is suitable for the environment of Node.js.
It has been under development since July 2010 and is used by a large number of users. It’s under active development with new features introduced relatively often.
Feature
- Schema definition
- Schema synchronization/dropping
- 1:1, 1:M & N:M Associations
- Through models
- Promises
- Hooks/callbacks/lifecycle events
- Prefetching/association including
- Transactions
- Migrations
- CLI (sequelize-cli)
Sequelize v6.12 has been released. The update change as follows:
Bug Fixes
- data-types: unnecessary warning when getting data with DATE dataTypes (#13712) (121884b)
- docs: add aws-lamda route (#13693) (3059bce)
- example: fix coordinates format as per GeoJson (#13718) (f9dec20)
- increment: fix key value broken query (#12985) (fc0b19e)
- model.d: fix findAndCountAll.count type (#13736) (b7b472e)
- snowflake: fix to prevent disconnect attempt on already disconnected connection (#13775) (2a9a551)
- types: add Col to where Ops (#13717) (2d7b865)
- types: add instance member declaration (#13684) (ae3cde5)
- types: add missing schema field to sequelize options (c7a0839), closes #12606
- types: allow override json function with custom return type (#13694) (2c3b384)
- upsert: fall back to DO NOTHING if no update key values provided (#13594) (4071378)
- upsert: fall back to DO NOTHING if no update key values provided (#13711) (f9dfaa7), closes #13594
- wrong interface used within mixin (#13685) (bd3ddf5)
Features
- dialects: add experimental support for db2 (#13374) (4443d2a)
- dialect: snowflake dialect support (#13406) (ad68a5e)
- model: complete getAttributes feature (b6510df)
- typescript: create alpha release with ts (911125e)
- types: transition lib/errors (#13710) (8cdce6a)
- upsert: add conflictFields option (#13723) (496bede)