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 keeping magic to a minimum.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.

Objection.js - An SQL-friendly ORM for Node.js

MikroORM is a TypeScript ORM for Node.js based on Data Mapper, Unit of work and Identity Map patterns. It supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases. Heavily inspired by Doctrine and Nextras ORM.
 
It allows handling transactions automatically. When you call em.flush() all computed changes are wrapped inside a database transaction. It uses source code analysis so you do not have to repeat yourself when defining entities. Simply define correct TypeScript types and you are good to go.
 
Its features include:
<ul>
<li>Clean and Simple Entity Definition</li>
<li>Identity Map</li>
<li>Entity References</li>
<li>Using Entity Constructors</li>
<li>Modelling Relationships</li>
<li>Collections</li>
<li>Unit of Work</li>
<li>Transactions</li>
<li>Cascading persist and remove</li>
<li>Composite and Foreign Keys as Primary Key</li>
<li>Filters</li>
<li>Using QueryBuilder</li>
<li>Preloading Deeply Nested Structures via populate</li>
<li>Property Validation</li>
<li>Lifecycle Hooks</li>
<li>Vanilla JS Support</li>
<li>Schema Generator</li>
<li>Entity Generator</li>
</ul>

MikroORM is a TypeScript ORM for Node.js based on Data Mapper, Unit of work and Identity Map patterns. It supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases. Heavily inspired by Doctrine and Nextras ORM.

MikroORM - TypeScript ORM for Node

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

usql - universal command-line interface for SQL databases

Discover open source projects across all platforms

Projects

Objection.js - An SQL-friendly ORM for Node.js

MikroORM - TypeScript ORM for Node

usql - universal command-line interface for SQL databases

TechStack

Tagcloud

Suggested keywords:

Projects

Objection.js - An SQL-friendly ORM for Node.js

MikroORM - TypeScript ORM for Node

usql - universal command-line interface for SQL databases

TechStack

Tagcloud