Supported: 4.0 + If using Nodejs >= 14 & Postgres, you must use pg driver >= 8.1. v7 doesn't work correctly (tests time out). Tests are run on Travis CI If you want you can run tests locally. Create Models, sync, drop, bulk create, get, find, remove, count, aggregated functions. Create Model associations, find, check, create and remove. Define custom validations (several builtin validations, check instance properties before saving - see enforce for details). Model instance caching and integrity (table rows fetched twice are the same object, changes to one change all). Plugins: MySQL FTS , Pagination , Transaction, Timestamps, Migrations. A Model is an abstraction over one or more database tables. Models support associations. The name of the model is assumed to match the table name. Models can be in separate modules. Simply ensure that the module holding the models uses module.exports to publish a function that accepts the database connection, then load your models however you like.
Features
- Supports MySQL & MariaDB
- Supports PostgreSQL
- Supports Amazon Redshift
- Supports SQLite
- Supports MongoDB (beta, node 6 or older, doesn't work with node 8. Also, missing aggregation features)
- Create Models, sync, drop, bulk create, get, find, remove, count, aggregated functions