redbean-sql

RedBeanNode

(Early Development)

RedBeanNode is an easy to use ORM tool for Node.js, strongly inspired by RedBeanPHP. !!!WARNING!!! redbean-sql is last (0.0.20) version of redbean-node with bug fixes

Original: https://www.npmjs.com/package/redbean-node

• Automatically creates tables and columns as you go
• No configuration, just fire and forget
• Ported RedBeanPHP's main features and api design
• Build on top of knex.js
• Supports JavaScript & TypeScript
• async/await or promise friendly

Supported Databases

• MySQL / MariaDB
• SQLite

Installation

npm install redbean-node --save

Read More

Docs: http://redbean-node.whatsticker.online

Playground

Try RedBeanNode in browser!

https://runkit.com/louislam/redbeannode-playground

Code Example

This is how you do CRUD in RedBeanNode:

const {R} = require("redbean-node");

// Setup connection
R.setup();

(async () => {
    let post = R.dispense('post');
    post.text = 'Hello World';

    // create or update
    let id = await R.store(post);

    // retrieve
    post = await R.load('post', id);

    console.log(post);

    // delete
    await R.trash(post);

    // close connection
    await R.close();
})();

New

Added getSlots(array)

/**
* @param {Array} array 
*/
genSlots(array = []) {
    var str;
    if (!Array.isArray(array)) return undefined
    str = array.length ? array.fill("?").join() : ''
    return str
}

This automatically generates the tables and columns... on-the-fly. It infers relations based on naming conventions.

Unit Test

Please build the project before run the test.

Additional

Icons made by Vitaly Gorbachev from https://www.flaticon.com