Roso-db NPM | npm.io

Badges

Authors

@thatfriendlyasiandev - Idea & Initial work
waitingwittykitty- Command structure and help

Message from the author

Hello everyone,

I hope this message finds you well. As you may already know, RosoDB has not been actively developed for the past few months. However, I am excited to announce that I have found new motivation and will be taking on the responsibility of updating and fixing bugs on a regular basis going forward.

I have some great news to share with you all as well. We will be creating a dashboard for the database, which will make it much easier to manage. I know this has been a highly requested feature, and I am thrilled to be able to bring it to you.

Thank you for your patience during the development pause, and I look forward to bringing you the latest updates and improvements to RosoDB.

Best regards, BabyMonie

ROSO DB

RosoDB is a database solution that utilizes a mix of SQL and JSON. Its ease of use makes it an excellent option for individuals in need of a straightforward database solution. While you may be familiar with my other project, Causedb, I want to highlight that RosoDB is a superior choice due to its lighter, faster, and more secure performance.

Tech Stack

Client: NODE.JS

Server: Node, Express

Installation

Install rosodb with npm

  npm install rosodb

Usage/Examples

  #Look at the commands

  roso --help

  #Run it

  roso -h any hostname -p any port -username for connection -pa password for connection

How to create your own custom extensions/commands

  #create a file and name it whatever you want and then paste this baseplate code in It,check the api.js docs below for more info.
  const api = require('../api')
  const command = {
    name: 'name',
    description: 'description, can be empty',
   #add your args here for example databaseName and tableName
    args: [],
    run: async (args) => {
      #how to import args
      const databaseName = args.databaseName;
      #return sonethin
      return {
          sucess:true,
          message:"WOW, it works
          };
      }
    },
  };

  api.registerCommand(command);

  api.executeCommand('create db', { databaseName: 'users' });

  #this command is a prebuilt command in rosodb so you can use it as a reference for your own commands.

How to Import custom extensions/commands

  # drag and drop the extension file to the commands folder wherever the database server is running, and then restart the server commands will automatically be imported.

API Reference

Get all databases

  api.getDatabases();
  #args required: none

Check if database exists

   api.databaseExists();
    #args required: databaseName

Create a database

  api.createDatabase();
  #args required: databaseName

Delete a database

  api.dropDatabase();
  #args required: databaseName

Get all tables in a database

  api.getTables();
  #args required: databaseName

Check if table exists in a database

  api.tableExists();
  #args required: databaseName, tableName

Create a table in a database

  api.createTable();
  #args required: databaseName, tableName

Delete a table in a database

  api.dropTable();
  #args required: databaseName, tableName

Update a row in a database

  api.updateTable();
  #args required: databaseName, tableName, id, data

Get a row by an id in a table in a database

  api.selectFromTableById();
  #args required: databaseName, tableName, id

Get all rows in a table in a database

  api.getRows();
  #args required: databaseName, tableName

Get a row by an query in a table in a database

  api.selectFromTableByQuery();
  #args required: databaseName, tableName, query

Insert a row in a table in a database

  api.insertIntoTable();
  #args required: databaseName, tableName, data

Delete a row in a table in a database, only takes id to make sure that you don't delete the wrong row

  api.deleteFromTable();
  #args required: databaseName, tableName, id

Register a command

  api.registerCommand();
  #args required: command object

Execute a command

  api.executeCommand();
  #args required: command name, args

Features

SQL Based comamnds
Fast
Light
JSON Storage

Appendix

Clients for more languages are coming soon.

FAQ

How good is the speed

Decent,better than CauseDB.

What are the benefits of using this database?

One advantage is that it is specifically designed for simple projects where both the client and server are hosted on the same device. This means that if you were to host an API on a server, the database server would also be located there, simplifying your setup. An additional advantage is that this database offers fast speeds and improved security. Your data will be processed quickly, and you can rest assured that it is being stored safely and securely.