Learn more about nukak
at its website https://nukak.org
nukak
is a powerful and efficient ORM, featuring serializable JSON
syntax and intelligent type-inference. It enables you to write queries in the frontend (browser/mobile), or any other client, which can then be safely sent to the server. Additionally, you can use nukak
solely in the server, or even in a mobile application with an embedded database (such as SQLite
).
Features
- Serializable
JSON
syntax for all the queries. - Uses the power of
TypeScript
to get smart type-safety everywhere. - The generated queries are performant, safe, and human-readable.
$project
, $filter
, $sort
, $limit
works at multiple levels (including deep relations and their fields).- declarative and imperative
transactions
. - soft-delete, virtual fields, repositories,
connection pooling
. - Transparent support for inheritance between entities.
- Unified API for
MySQL
, MariaDB
, SQLite
, Postgres
, MongoDB
.
Install
-
Install the core package:
npm install nukak --save
-
Install one of the specific adapters for your database:
Database | Driver | Nukak Adapter |
---|
MySQL | mysql2 | nukak-mysql |
MariaDB | mariadb | nukak-maria |
SQLite | sqlite sqlite3 | nukak-sqlite |
PostgreSQL | pg | nukak-postgres |
MongoDB | mongodb | nukak-mongo |
For example, for Postgres
:
npm install pg nukak-postgres --save
-
Additionally, your tsconfig.json
may need the following flags:
"target": "es2020",
"experimentalDecorators": true,
"emitDecoratorMetadata": true
Configure
A default querier-pool can be set in any of the bootstrap files of your app (e.g. in the server.ts
).
import { setQuerierPool } from 'nukak';
import { PgQuerierPool } from 'nukak-postgres';
export const querierPool = new PgQuerierPool(
{
host: 'localhost',
user: 'theUser',
password: 'thePassword',
database: 'theDatabase',
},
{ logger: console.log }
);
setQuerierPool(querierPool);
Define the entities
Take any dump class (aka DTO) and annotate it with the decorators from nukak/entity
.
import { v4 as uuidv4 } from 'uuid';
import { Id, Field, Entity } from 'nukak/entity';
@Entity()
export class User {
@Id({ onInsert: uuidv4 })
id?: string;
@Field()
name?: string;
@Field()
email?: string;
@Field()
password?: string;
}
Manipulate the data
import { getQuerier } from 'nukak';
import { User } from './shared/models/index.js';
async function findLastUsers(limit = 10) {
const querier = await getQuerier();
const users = await querier.findMany(User, {
$project: ['id', 'name', 'email'],
$sort: { createdAt: -1 },
$limit: limit,
});
await querier.release();
return users;
}
async function createUser(body: User) {
const querier = await getQuerier();
const id = await querier.insertOne(User, body);
await querier.release();
return id;
}
Learn more about nukak
at its website https://nukak.org