Rust implementation of basic SQL database, originally implemented in Java by the Edward Sciore's book "Database Design and implementation".

simpledb is a database engine that can handle a subset of SQL. The following is the examples of commands which can be accepted by simpledb.

-- Creating tables
CREATE TABLE users(id INT, name VARCHAR(16));
-- Insertions
INSERT INTO users(id, name) VALUES(1, 'User');
-- Queries
SELECT u.id, u.name FROM users u where u.id=1;
-- Removal
DELETE FROM users WHERE id=1;
-- Updating
UPDATE users SET name='Other' WHERE id=1;
-- Index creation
CREATE INDEX users_ids ON users(id);
-- View for joins
CREATE TABLE salaries(user_id INT, amount INT);
CREATE VIEW users_salaries AS select id, amount FROM users, salaries WHERE id=user_id;

The Remote JDBC Interface and network interface is in development(DB_00003 branch)

• B-Tree Index - implemented as single file structure, without using the recursion on insert, get and delete
• JOINs - can be executed in two types of queries SELECT a, b FROM a, b and SELECT a, b FROM a JOIN b ON a = b

Clone this repository

cargo build --release

Then the executables will be generated in the target/release folder.

cd target/release

./cli