OurDB Database

light weight Database. Created using c++ for every type of machine. Scalable as well as easy to use Database.

Authors

Zeel Sheladiya
Mihir Surati
Parth Dabheliya

🔗 Social Media Links

Documentation

Video Tutorial

You can watch the video of how to use ourdb database on ourdb youtube channel.
here is the link :- click here

Other Syantax related help

you can check ourdb_database/syntax.txt where you can find all updated syntax.

Features

Light weight (size less than 2mb)
scalable
Can run cross platform (Windows ,Mac ,Linux)
Dynamically made database. Any developer can easily made changes
Files with own encryption and own extension .Ourdb
Even low end device like Arduino , raspberry pi can also run it.
It requires minimum c++ 17 standard compiler or above to run on any system
It is combination (NoSQL + SQL) because it doesn’t have schema for storing table but it has perfect syntax for creating query like SQL

Run Locally

Clone the project

  git clone https://github.com/zeelsheladiya/OurDB-Database.git

Usage/Examples

-> Add Database to your project

Add or include OurDB_Database.h in your colnsole or gui program file

#include "OurDB_Database.h"

How To Use OurDB Database

Create database:

First step to enter in the database system is to create database. A physical storage area where all table resides.
Syntax : create/make database/db <database_name>

create database zeel

Even you can change the (create) keyword in the code(instruction for developer) its dynamic add or remove keyword etc.

Select database:

select the database among the existing databases else returns the error.
Syntax : select/choose database/db <database_name>
After creating database you have to compulsory select the database in order to create table and perform some action/operations.

select database zeel

database is so flexible that developer can change any keyword.

Create Table:

Creates table in the database along with the column in it.
Syntax : create/make table <table_name> @ <column1_name> <column2_name>…
After creating database you have to compulsory select the database in order to create table and perform some action/operations.

create table mark @ id name age

with this simple syntax we can easily create the table in database.

Current database:

it will show the selected database/the database you are in right now.
Syntax : current/present database/db

current database

this query used when you don’t know what database you are in right now.

Rename database:

It will rename the database in the system.
first you have to select the database then and then you can perform rename query.and after renaming you have to again select the database to perform the operation.
Syntax : rename database <database_name>

select database parth

rename database parthx

we have given this facility who wants to change the name of the database but it is not good practice to do so..

Show databases:

It will show all the database resides in the system.
Syntax : show/display/view all db/database

show all db

it is advisable to run query prior to any other query so that you can see all the database exists in the system

Show tables:

It will show all the tables resides in the selected database.
first we have to select the database so that we can see the table resides in it.
Syntax : show/display/view all table

show all table

Show column in table:

It will list out all the column which is present in the table
After selecting database , create table and then you will be able to use this feature.
Syntax : show all col @ <table_name>

show all col @ tb1

show column in table never return null value because column in the table decide at the creation of table.

Rename table in database:

This command will rename the table exist in the particular database.
make sure that table must exist before renaming the table.
Syntax : rename table <old_table_name> <new_table_name>

reaname table tbn tb1

Rename column in table:

This command will rename the column in the particular table
make sure to check that column exist in the table by show all column @ table.
Syntax :rename column/col from <table_name> @ <old_col_name> <new_col_name>

rename col from tb1 @ age agex

this feature looks so simple but most important while working with the database.

Insert data in to the table:

Insert query is used to enter the data in the empty column which was created with the table during creation of table
make sure in which table you are going to insert the data ,that must be created before insertion of data.
insert or add both will be accepted but not simultaneously.
Syntax : insert into <table_name> @ '<col1_value>' '<col2_value>' ...

insert into mark @ '1' 'zeel' '20'

you can see the data in the table by select command we will look for it later on.
Single quote is necessary for inserting the value in to the table.

Adding new column in the table:

This command will add a new column in the existing table.
make sure in which table you are going to insert the column ,that must be created before insertion of column.
insert or add both will be accepted but not simultaneously.
Syntax : insert/add col/column into <table_name> @ <col_name>

insert col into mark @ gender

Updating a data in to the table:

It used to update a data in to the table.
Here after where table field and value connected with the = operator. Or !(not equal) operator.
And for more than one condition you can concatenation condition with either &(and) or |(or)
It's also support < , > , <= , >= operators.
Syntax : update @ <table_name> set/put <table_field> '<field_value>' where <table_field1>(=|!)<field_value1> & <table_field2>(=|!)<field_value2>

update @ mark set gender 'female' where id=1 & name=zeel

Delete the database:

It will delete the database from the system.
delete or destroy both are accepted but not simultaneously
Syntax : delete/destroy database <database_name>

delete db dbn

Before deleting the database always make sure that your all the tables are deleted or you may loss important data.

Delete the table:

Delete the table from the database.
make sure to select the database before deleting table.
Syntax : delete table <table_name>

delete table tb

Delete the particular table data:

Delete the data from the table at particular row/rows.
make sure to select the database before deleting table.
Here at particular row/rows you can delete a data.
Here after where table field and value connected with the = operator. Or !(not equal) operator.
And for more than one condition you can concatenation condition with either &(and) or |(or)
It's also support < , > , <= , >= operators.
Syntax : delete/destroy @ <table_name> where <column_name> (=/!) <column_value> (&/|) <column_name1> (=/!) <column_value1>

delete @ tb1 where id=4

Delete the column:

This will delete the column from the table.
make sure in which table you are going to insert the column ,that must be created before insertion of column.
Syntax : delete/destroy column/col from <table_name> @ <col_name>

delete col from tb1 @ pass

Select data from table:

It will select and display the the data into the table format.
Syntax : select/choose col1 col2 @ <table_name> where <column_name> (=/!) <column_value> (&/|) <column_name1> (=/!) <column_value1>

select * @ tb

To set primary and foreign key:

Now ourdb has schema such as primary key nad foreign key.
Syntax [primary key] : set $ <col_name> @ <table_name>
Syntax [foreign key] : set # <col_name> @ <table_name> $ <primary_table_name>

// to set primary key
set $ id @ testTable

// to set foreign key
set # id @ testTable $ mainTable

Functions for output:

there are mainly three functions to get better formatted output such as output as a string , map , json.
Syntax [ output as a table string for console app ] : To_StringTable(run_query("your query"))
Syntax [ output as a map object ] : To_Map(run_query("your query"))
Syntax [ output as a json object ] : To_Json(run_query("your query"))

// to get table string
To_StringTable(run_query("select * @ testTable"))

// to get map object
To_Map(run_query("select * @ testTable"))

// to get json object
To_Json(run_query("select * @ testTable"))

Other updates will be added after new commits...

Examples of console app with ourdb database

this example's code also can be seen in OurDB_Database/console.cpp.

#include "OurDB_Database.h"
#include <iostream>
#include <string>
#include "variables/query_variables.h"
#include "global_functions/global_function.h"
#include "global_functions/SyntaxCheckerForResultString.h"

using namespace std;

template<class Element, class Container>
bool selectChecker(const Element & s ,const Container & s1)
{
    for(string i : s1)
    {
        //cout << i << endl << s.find(i) << endl;
        if(s.find(i) != -1)
        {
            return true;
        }
    }

    return false;
}


int main() {

    string s;

    while(true) {

        cout << "Enter Your query :  ";
        getline(cin, s);

        if(selectChecker(s,select_db_query))
        {
            if(selectChecker(s,colSymbol))
            {
                string check = run_query(s);

                if(SyntaxCheckerForResultString(check))
                {
                    cout << endl << To_StringTable(run_query(s)) << endl;
                }
                else
                    cout << endl << run_query(s) << endl;
            }
            else
            {
                cout << endl << run_query(s) << endl;
            }
        }
        else
        {
            cout << endl << run_query(s) << endl;
        }
    }

    return 0;
}

Contact

If you need any help regarding this project feel free to contact us on our social media link and github account.

Contribution

If you want to contribite in this then read contribution.txt

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

README.md

README.md

OurDB Database

Authors

🔗 Social Media Links

Documentation

Video Tutorial

Other Syantax related help

Features

Run Locally

Usage/Examples

How To Use OurDB Database

Create database:

Select database:

Create Table:

Current database:

Rename database:

Show databases:

Show tables:

Show column in table:

Rename table in database:

Rename column in table:

Insert data in to the table:

Adding new column in the table:

Updating a data in to the table:

Delete the database:

Delete the table:

Delete the particular table data:

Delete the column:

Select data from table:

To set primary and foreign key:

Functions for output:

Other updates will be added after new commits...

Examples of console app with ourdb database

Contact

Contribution

Files

README.md

Latest commit

History

README.md

File metadata and controls

OurDB Database

Authors

🔗 Social Media Links

Documentation

Video Tutorial

Other Syantax related help

Features

Run Locally

Usage/Examples

How To Use OurDB Database

Create database:

Select database:

Create Table:

Current database:

Rename database:

Show databases:

Show tables:

Show column in table:

Rename table in database:

Rename column in table:

Insert data in to the table:

Adding new column in the table:

Updating a data in to the table:

Delete the database:

Delete the table:

Delete the particular table data:

Delete the column:

Select data from table:

To set primary and foreign key:

Functions for output:

Other updates will be added after new commits...

Examples of console app with ourdb database

Contact

Contribution