An experimental attempt at creating a simple, standalone, serverless Database Management System with an ultimate goal of learning the internals. Supports simple, basic queries. SQL statements have the same syntax as MySQL's. Runs only on linux machines.

1. It can be installed by running the install.sh shell script (or)
2. cmake . & make install

The executable binary will be installed inside OurSQL/bin

The executable takes only a data-directory location as a command line argument, which also is optional. By default, OurSQL creates a data directory in the current working directory.

The following queries are supported in OurSQL. All SQL commands are case insensitive.

1. CREATE DATABASE dbname;
2. SHOW DATABASES;
3. USE dbname;
4. CLOSE DATABASE;
5. DROP DATABASE dbname;

6. CREATE TABLE tblname (col1 col1-type[(col1-width)] [, col2 col2-type[(col2-width)] ,...]);
7. INSERT INTO tblname [(col1, col2,...)] VALUES (val1[, val2 ,...]);
8. SELECT *|col1[,col2 ,...] FROM tblname [WHERE cond];
9. UPDATE tblname SET col=val [WHERE cond];
10. DELETE FROM tblname [WHERE cond];
11. SHOW TABLES;
12. SHOW COLUMNS FROM tblname;
13. ALTER TABLE tblname RENAME TO new-tbl-name;
14. ALTER TABLE tblname RENAME COLUMN col-name TO new-col-name;
15. ALTER TABLE tblname ADD COLUMN new-col new-coltype;
16. ALTER TABLE tblname DROP COLUMN col-name;
17. DROP TABLE tblname;

18. IMPORT FROM complete-sql-file-path;