Orange ORM is an object-relational mapper for JavaScript and TypeScript applications.
It runs on Node.js, Bun and Deno, with support for CommonJS and ECMAScript modules.
The software offers a strongly typed query API, Active Record operations and relationship mapping without requiring code generation. It works with a broad selection of relational databases and provides Express and Hono adapters for securely accessing data from browser applications.
This is free and open source software.
Key Features
- Offers expressive, strongly typed filtering, querying and data manipulation.
- Implements the Active Record pattern for retrieving and modifying rows.
- Provides TypeScript IntelliSense without generating model code.
- Supports JavaScript and TypeScript with CommonJS and ECMAScript modules.
- Maps one-to-one, one-to-many and reference relationships between tables.
- Supports PostgreSQL, PGlite, MySQL, MariaDB, SQLite and Microsoft SQL Server.
- Also works with Oracle Database, SAP ASE and Cloudflare D1.
- Runs on Node.js, Bun and Deno, with selected Cloudflare and browser support.
- Provides transactions with automatic rollback when an operation fails.
- Supports row locking with select-for-update and skip-locked operations.
- Includes Express and Hono adapters for browser-based database access.
- Allows inserts, updates and deletions to be persisted with saveChanges().
Website: github.com/alfateam/orange-orm
Support:
Developer: Lars-Erik Roald
License: ISC License
Orange ORM is written in JavaScript. Learn JavaScript with our recommended free books and free tutorials.
Related Software
| JavaScript Object-Relational Mapping Software | |
|---|---|
| Sequelize | Promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and more |
| Objection.js | ORM for Node.js that aims to stay out of your way |
| Bookshelf | ORM for Node.js, built on the Knex SQL query builder |
| Waterline | Adapter-based ORM for Node.js |
| Flyweight | ORM for SQLite |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |
Please read our Comment Policy before commenting.