Skip to content

A simple SQL Database implementation for "Database System Concepts" course.

Notifications You must be signed in to change notification settings

leohaipengli/nanosql

 
 

Repository files navigation

NanoSQL

screenshot

Dependencies

The dependencies can be installed by simply use pipenv.

  1. install pipenv.
pip install pipenv

  1. install dependencies
pipenv install

  1. enter virtual envirment
pipenv shell

Run app

Make sure currently in the pipenv or all dependencies are installed.

CLI

python shell.py

Web

python web.py

Sample SQLs

create table student (
  sno char(8),
  sname char(16) unique,
  sage int,
  sgender char (1),
  primary key ( sno )
);
create index stunameidx on student ( sname );
insert into student values ('12345678','wy',22,'M');

See more test cases at: test/sample.txt

About

A simple SQL Database implementation for "Database System Concepts" course.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • CSS 68.4%
  • Python 23.2%
  • JavaScript 7.0%
  • HTML 1.4%