DB SQL Validator is a fully client-side web application powered by sql.js. Designed for the database course at Stockholm University, it provides an interface for students to write, format, and run SQL queries directly in their browser without the need for a database server. Results can be compared to expected results based on a question bank, and views can be created and managed using the browser's local storage.
- Fully Client-Side Execution: All SQL validation and execution is performed in the browser using sql.js SQLite.
- SQL Editor: A simple text editor with syntax highlighting and formatting.
- Views Management: Create, delete, and manage database views, stored in the browser's local storage.
- Results Comparison: Compare query results to expected results based on a question bank.
- Dark/Light Mode: Toggle between dark and light mode.
- Export Data: Export queries and views to file for sharing and/or backups.
A public instance of DB SQL Validator is available at https://sql-validator.e-su.se, powered with Cloudflare Pages.
To deploy DB SQL Validator locally, follow these steps:
- Clone the repository:
git clone https://github.com/Edwinexd/dsv-db-sql-validator.git - Install dependencies:
npm install - Start the development server:
npm start
This project is licensed under the GNU General Public License v3.0. See the LICENSE file for more information.