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 |
| Drizzle | Lightweight, headless object-relational mapper |
| Objection.js | ORM for Node.js that aims to stay out of your way |
| Midnight | ORM for SQLite |
| Bookshelf | ORM for Node.js, built on the Knex SQL query builder |
| Orange ORM | Runs on Node.js, Bun and Deno, supporting CommonJS and ECMAScript mods |
| Sutando | Object-relational mapper for Node.js |
| Waterline | Adapter-based ORM for Node.js |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.