Skip to content
プロジェクト

sutandojs/sutando has 310 GitHub stars and 28 forks. GitHot measured -1 stars in 24 hours and 0 in 7 days. Last checked 2026-11-20 19:48 UTC. Last push 2026-05-09.

この数値の測り方

できること

  • Supports MySQL, PostgreSQL, SQLite and other databases
  • Concise syntax and intuitive operations
  • Model relationships for handling complex data queries and operations
  • Powerful query builder

計測したスター増加

24時間
-1
7日間
0
15日間
履歴を収集中
1か月
履歴を収集中

期間ごとの純増数です。期間は重複しており、日別の値ではありません。未計測の値は空欄です。スター数は注目度の指標であり、品質の保証ではありません。

概要

Sutando is a modern Node.js ORM, like Laravel Eloquent.

データ

Sutando is an object-relational mapper (ORM) that makes it enjoyable to interact with your database. When using Sutando, each database table has a corresponding "Model" that is used to interact with that table. In addition to retrieving records from the database table, Sutando models allow you to insert, update, and delete records from the table as well.

Heavily inspired by Laravel's ORM Eloquent.

✨ Features

  • Supports MySQL, PostgreSQL, SQLite and other databases
  • Concise syntax and intuitive operations
  • Model relationships for handling complex data queries and operations
  • Powerful query builder
  • Customized data type conversion for model attributes
  • Easy-to-use transaction
  • Support for hooks to execute custom logic at different stages of model operations
  • Simple plugin mechanism for easy expansion

📖 Documentation

Check the full documentation on https://sutando.org | 中文文档

🚀 Quick Start

Let’s take mysql as an example.

Install Sutando and mysql database library

$ npm install sutando mysql2 --save

The easiest way to make SQL queries is to use the Database query builder. It allows you to construct simple and complex SQL queries using JavaScript methods.

const { sutando, Model } = require('sutando');

// Add SQL Connection Info
sutando.addConnection({
  client: 'mysql2',
  connection: {
    host : '127.0.0.1',
    port : 3306,
    user : 'root',
    password : '',
    database : 'test'
  },
});

const db = sutando.connection();

// Query Builder
const users = await db.table('users').where('age', '>', 35).get();

// ORM
class User extends Model {}

// Query Data
const users = await User.query().where('age', '>', 35).get();

// Insert
const user = new User;
user.name = 'David Bowie';
await user.save();

// Delete
await user.delete();

// Pagination
const users = await User.query().paginate();

// Eager Loading
const users = await User.query().with('posts').get();

// Constraining Eager Loads
const users = await User.query().with({
  posts: q => q.where('likes_count', '>', 100)
}).get();

// Lazy Eager Loading
await user.load('posts');

💖 Show Your Support

Please ⭐️ this repository if this project helped you