vlquery

vlquery TypeScript ORM

Simple to use TypeScript based database first ORM for postgres.

Example usage:

const books = await db.book
	.where(book => book.author.firstname == "Jan")
	.orderByAscending(book => book.title.lowercase())
	.toArray();

const author = await db.person.find("<a very long uuid>");
const authorsFirstBookFrom2001 = await author.books
	.first(book => book.publishedAt.year == 2001);

authorsFirstBookFrom2001.title = "A new title";
await authorsFirstBookFrom2001.update();

Examples

Simple Example Project
Using audits with an express server

Documentation

Getting started
Database structure
Reading, filtering and ordering data
Altering data
Adding audits
Performance and include

Sponsoring and support

This project is sponsored and supported by inter allied crypsis / ACRYPS and VLVT.IN GmbH.