MochaDB

MochaDB copied to clipboard

Featured Features

• Open source and free for everyone
• High performance
• Lightweight
• ACID support
• RDBMS(Relational Database Management System) features
• MHQ(MochaDB Query) for simple and fast queries
• MHQL(MochaDB Query Language) for advanced queries

Compatibility

MochaDB

MochaDB Server

MochaDB Terminal

Components

• MochaDB Studio

Work with MHQL

Perform deep queries with MHQL and avoid complex tasks manually.

USE Name AS Username,
    $CompanyId,
    COUNT() AS Count of users
FROM Persons MUST
Name = "mertcandav" AND
  IN CompanyId {
    USE Id, $Name FROM Companies MUST
    Name = "Microsoft"
  }
CORDERBY ASC
ORDERBY Name
GROUPBY Name
SUBROW 100

Example Use

using MochaDB;
using MochaDB.Mhql;

// Create your database connection.
var database = new MochaDatabase(path: "db", password: "1231", logs: false);
var username = Console.ReadLine(); // Get username from user.
var password = Console.ReadLine(); // Get password from user.
database.Connect(); // Connect to database.

// Get table filtered by username and password with using mhql query.
var result = new MochaDbCommand(database).ExecuteScalar(
    $@"USE Username, Password
       FROM Persons
       MUST Username = ""{username}"" AND
       Password = ""{password}""");

database.Disconnect(); // Disconnect from database.
if (!result.Any()) // If table is empty.
{
    Console.WriteLine("Username or password is wrong!");
}
else
{
    Console.WriteLine("Success!");
}

License

MochaDB is distributed under the terms of the MIT license.
See license details.