npmpackage.info

objection

An SQL-friendly ORM for Node.js

3.1.5

7,285

MIT

JavaScript

629.45 kB

31,610,844 4.5

Installations

npm install objection

Developer Guide

BETA

Typescript

Yes

Module System

CommonJS

Min. Node Version

>=14.0.0

Node Version

20.12.2

NPM Version

10.5.0 Score

Supply Chain

Quality

81.9

Maintenance

100

Vulnerability

99.3

License

Pull Requests

Open

21

Total

766

Closed

275

Merged

470

Issues

Open

86

Total

1,943

Closed

1,857

Releases

Unable to fetch releases

Contributors

160

View all 160 contributors

Languages

JavaScript

TypeScript

PEG.js

Shell

JavaScript (95.47%)

TypeScript (4.25%)

PEG.js (0.27%)

Shell (0.01%)

Developer

vincit

Download Statistics

Total Downloads

31,610,844

Last Day

4,421

Last Week

80,045

Last Month

516,150

Last Year

6,748,139

GitHub Statistics

7,285 Stars

2,204 Commits

639 Forks

78 Watching

14 Branches

160 Contributors

Maintainers

Package Meta Information

Latest Version

3.1.5

Package Id

objection@3.1.5

Unpacked Size

629.45 kB

Size

133.49 kB

File Count

181

NPM Version

10.5.0

Node Version

20.12.2

Publised On

25 Sept 2024

Total Downloads

Cumulative downloads

Total Downloads

31,610,844

Last day

-81.3%

4,421

Compared to previous day

Last week

-34.5%

80,045

Compared to previous week

Last month

-5.3%

516,150

Compared to previous month

Last year

-1.5%

6,748,139

Compared to previous year

Daily Downloads

Weekly Downloads

Monthly Downloads

Yearly Downloads

Versions

Objection.js

Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while still making the common stuff easy and enjoyable.

Even though ORM is the best commonly known acronym to describe objection, a more accurate description is to call it a relational query builder. You get all the benefits of an SQL query builder but also a powerful set of tools for working with relations.

Objection.js is built on an SQL query builder called knex. All databases supported by knex are supported by objection.js. SQLite3, Postgres and MySQL are thoroughly tested.

What objection.js gives you:

An easy declarative way of defining models and relationships between them
Simple and fun way to fetch, insert, update and delete objects using the full power of SQL
Powerful mechanisms for eager loading, inserting and upserting object graphs
Easy to use transactions
Official TypeScript support
Optional JSON schema validation
A way to store complex documents as single rows

What objection.js doesn't give you:

A fully object oriented view of your database With objection you don't work with entities. You work with queries. Objection doesn't try to wrap every concept with an object oriented equivalent. The best attempt to do that (IMO) is Hibernate, which is excellent, but it has 800k lines of code and a lot more concepts to learn than SQL itself. The point is, writing a good traditional ORM is borderline impossible. Objection attempts to provide a completely different way of working with SQL.
A custom query DSL. SQL is used as a query language. This doesn't mean you have to write SQL strings though. A query builder based on knex is used to build the SQL. However, if the query builder fails you for some reason, raw SQL strings can be easily written using the raw helper function.
Automatic database schema creation and migration from model definitions. For simple things it is useful that the database schema is automatically generated from the model definitions, but usually just gets in your way when doing anything non-trivial. Objection.js leaves the schema related things to you. knex has a great migration tool that we recommend for this job. Check out the example project.

The best way to get started is to clone our example project and start playing with it. There's also a typescript version available.

Check out this issue to see who is using objection and what they think about it.

Shortcuts:

Stable Version

3.1.5

CRITICAL

9.8/10

Summary

objection.js Prototype Pollution vulnerability

Affected Versions

< 2.2.16

Patched Versions

2.2.16

10

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

10

License

Determines if the project has defined a license.

10

Dangerous-Workflow

Determines if the project's GitHub Action workflows avoid dangerous patterns.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

9

Pinned-Dependencies

Determines if the project has declared and pinned its dependencies.

2

Code-Review

Determines if the project requires code review before pull requests (aka merge requests) are merged.

0

Maintained

Determines if the project is "actively maintained".

0

CII-Best-Practices

Determines if the project has a CII Best Practices Badge.

0

Token-Permissions

Determines if the project's workflows follow the principle of least privilege.

0

Security-Policy

Determines if the project has published a security policy.

0

Fuzzing

Determines if the project uses fuzzing.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

Score

4.5

/10

Last Scanned on 2022-08-15

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More

Other packages similar to objection

@tsed/objection

8.3.6

Objection.js package for Ts.ED framework

objection-filter

4.4.0

A filter module for objection.js

@bitovi/objection-querystring-parser

0.3.1

This library builds on top of [`@bitovi/querystring-parser`](https://github.com/bitovi/querystring-parser/tree/main/packages/querystring-parser#readme) to transform CRUD-related querystrings into structured data for the [Objection ORM](https://vincit.gith

objection-visibility

1.2.0

Objectionjs plugin to whitelist/blacklist model properties

objection

Installations

Developer Guide

Yes

CommonJS

>=14.0.0

20.12.2

10.5.0

Score

Pull Requests

21

766

275

470

Issues

86

1,943

1,857

Releases

Unable to fetch releases

Contributors

Languages

Developer

Download Statistics

GitHub Statistics

Maintainers

Package Meta Information

Total Downloads

31,610,844

Daily Downloads

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

Peer Dependencies

Dev Dependencies

Objection.js

Stable Version

3.1.5

CRITICAL

10

10

10

10

9

2

0

0

0

0

0

0

4.5

/10

Other packages similar to objection