SQL Editor

This repository contains SQL-Editor's backend source.

Caution

SQL-Editor is not meant for public usage. It contains critical security vulnerabilities: E.g. passwords are stored in plaintext (This is clarified on the website)

Philosophy & Motivation

I started the SQL-Editor project in mid 2021, based on an earlier project from 2019. The front and backend were parts of an optional project I made for my high school graduation in 2022.

The objective was to create an easy-to-use, web-based environment for students at my school to learn and get comfortable writing SQL and interacting with real databases. For me, it was a great opportunity to start diving into web development.

Library introductions

• Discovery: Std. WebSocket Impl.: packet-based WebSocket communication system used throughout the SQL-Editor backend

Basic file structure

Sub Projects

• bernie-sql-editor-sdk: Small (partly standalone) libraries and miscellaneous classes I developed for SQL-Editor
• bernie-sql-editor-ton: Actual implementation of SQL-Editor backend

Noteworthy directories & files

• Main class: Main class that starts the backend
• Frontend communication link: Abstract, packet-based communication layer

Updates & Issues

This project is archived. I won't continue adding new features or resolve security vulnerabilities and bugs.