SimpleDB based on Rust

Overview

This is a database system developed based on Rust, which currently supports basic database operations and instructions, supports persistent storage, and is compatible with MySQL syntax.

Getting Start

To get started with RustDB, follow these steps:

1. Visit Rust's official website to install the basic environment required for running Rust programs.

2. Clone this repository to your local machine:

   $ git clone https://github.com/DMSintalor/simple-db.git

3. Navigate to the project directory:

   $ cd simple-db

4. Build and install RustDB:

   $ cargo build --release

5. Execute SimpleDB

   $ cd target/release
   $ run SimpleDB

Alternatively, you can use cargo run to start the program.

Support Commands

• Create Table
• Drop Table
• Select Data
  • Inner Join
  • Multi Conditions
    • Like
    • IS NULL
    • < > =
    • And Or
• Insert Data into Table
• Delete Data from Table
  • Multi Conditions
• Update Data
  • Multi Conditions
• Create New Database
• Change Database
• Drop Database
• Change Password

How to work

1. SimpleDB-ClassMap
2. Create Parser
3. Select Parser
4. Generate Conditions

Future Work

• I/O Lock
• BTree
• Cloud Storage
• Data Encryption With RSA
• Support Python API like SQLAlchemy