Sequelize v6.12 released, Node.js ORM

by · Published · Updated

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.

Sequelize

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

Download

Tags: