GETTING STARTED

Installation

Connecting

Mapping tables

Data types

Enums

Example

CRUD

Inserting rows

Fetching rows

Updating rows

Upserting rows

Deleting rows

Basic filters

Relation filters

And, or, not, exists

Any, all, none

Fetching strategies

Default values

Validation

Composite keys

Column discriminators

Formula discriminators

Transactions

Raw sql queries

Aggregate functions

Excluding sensitive data

Logging

In the browser

SQLite user-defined functions

What it is not

Changelog

On this page

Are you an LLM? You can read better optimized documentation at /installation.md for this page in Markdown format

Orange can be installed via your preferred package manager.

bash

npm install orange-orm

Pager

Released under the ISC License.