This repository contains the pre-project for my GSoC '15 proposal under Pencil Code. The project is aimed at making it easier for teachers to teach the concept of databases and information management and providing uncomplicated platform for teachers and students to contribute data. The project is live at http://vps.rkravi.com:3000/.
The project presents a straightforward UI to perform CRUD operations on a microdatabase. The authetication is done through secret tokens.
Click on Don't have a secret token? Click here to generate one! option and enter your name to generate a secret token.
Enter the name of a microdatabase(file) you want to create and press Create.
You can leave the second input blank.
Enter the name of the microdatabase to read. A default value val = 40 is entered in the databases while creation.
For executing a dojox json query, enter it in the second input along with the file name. Leaving the second input blank will read the whole file
Enter the name of the microdatabase to be updated in the first input and enter the new values separated by an & in the second input. Values in the query which do not exist will already be created.
For example, entering the update query val=70&name=rishabh will update the value of val to 70 and create a new key name with the value rishabh
Enter the name of the microdatabase to be deleted. You can leave the second input empty.
If you face any difficulty, feel free to open an issue.
- The application is an Express app
- Handlebars is used for views
- jsonql is used to implement dojox json query.
- jwt is used for token generation and authorization.
- Clone the repository
- Run
npm install - Make a directory named schema in root folder
mkdir schema - Run
node index.js - The application would be running on
localhost:3000
- Add API documentation
- Handle form submission on enter (which doesn't work currently) through JavaScript.
- Add passwords for authentication
- Protect against vulnerabilities