GORM vs Objection.js
Overview
Share your Stack
Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.
CLI (Node.js)
Manual
Detailed Comparison
It is a fantastic ORM library for Golang, aims to be developer friendly. It is an ORM library for dealing with relational databases. This library is developed on top of database/sql package. | It 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. |
Full-Featured ORM;
Associations (has one, has many, belongs to, many to many, polymorphism, single-table inheritance);
Hooks (before/after create/save/update/delete/find);
Eager loading with Preload, Joins;
Transactions, Nested Transactions, Save Point, RollbackTo to Saved Point;
Context, Prepared Statment Mode, DryRun Mode;
Batch Insert, FindInBatches, Find/Create with Map, CRUD with SQL Expr and Context Valuer;
SQL Builder, Upsert, Locking, Optimizer/Index/Comment Hints, Named Argument, SubQuery;
Composite Primary Key, Indexes, Constraints;
Auto Migrations;
Logger;
Extendable, flexible plugin API | A 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;
A way to store complex documents as single rows
Completely Promise based API;
Easy to use transactions;
Optional JSON schema validation |
Statistics | |
GitHub Stars 657 | GitHub Stars 7.3K |
GitHub Forks 194 | GitHub Forks 641 |
Stacks 193 | Stacks 38 |
Followers 128 | Followers 67 |
Votes 0 | Votes 0 |
Integrations | |
What are some alternatives to GORM, Objection.js?
Sequelize
Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.
Prisma
Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.
Hibernate
Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
Doctrine 2
Doctrine 2 sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL.
MikroORM
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.
Entity Framework
It is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.
peewee
A small, expressive orm, written in python (2.6+, 3.2+), with built-in support for sqlite, mysql and postgresql and special extensions like hstore.
MyBatis
It is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. It eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. It can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.
Entity Framework Core
It is a lightweight, extensible, open source and cross-platform version of the popular Entity Framework data access technology. It can serve as an object-relational mapper (O/RM), enabling .NET developers to work with a database using .NET objects, and eliminating the need for most of the data-access code they usually need to write.
SQLAlchemy
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
