NodeOM

NodeOM is a persistence library written in Typescript for Node. It supports high level abstractions to manipulate data from different persistence engines in a typesafe manner. Inspired by rom-rb ❤️

Active development. Not ready for usage at this moment. ⚠️

Concepts

NodeOM defines multiple abstractions that are independent from the the data storage. This abstractions allow the interoperation between different persistence engines. For example, you can have a relation backed by Postgres database and another relation powered by Redis and operate between them.

Schema

A schema defines how data is structured. Schemas are powered by Generics to allow type safety operations between them.

Relations

A relation is a set of tuples that provide database specific APIs for reading and writing. A sql adapter will expose the common operations that are allowed in sql like select, where or join while a redis adapter will expose operations like hget, set or lpop

Gateway

A gateway is database specific object that manages the connection with the database. Gateways are also aware of the relations that belong to him.

Example

This is a very simple example of what is possible at the moment with NodeOM.

export interface IUserAttributes {
  id?: number
  email: string
  name?: string
  age?: number
}

export interface ITestGateway {
  users: IUserAttributes
  // blogs: IBlogAttributes
  // posts: IPostAttributes
}

const gateway = new GatewaySQL<ITestGateway>({
  client: "sqlite3",
  connection: {
    filename: ":memory:",
  },
})

await gateway.connect()

await migrateSQLSchema(gateway)

const userSchema = new SchemaSQL<IUserAttributes>("users")

userSchema.attribute("id", "INTEGER", { primaryKey: true })
userSchema.attribute("email", "STRING")
userSchema.attribute("name", "STRING")
userSchema.attribute("age", "INTEGER")

gateway.registerSchemas([userSchema])

// Select only the attribute you need.
gateway.relation("users").select("id", "email").toArray()

// Find by primaryKey
gateway.relation("users").byPk(44)

// Find the first tuple
gateway.relation("users").first()

// All tuples
gateway.relation("users").toArray()

// Filter by some condition (only equals is supported)
gateway.relation("users").where({ name: "John" }).toArray()

// Limit the returned tuples
gateway.relation("users").limit(10).toArray()