A training tool for Databases/SQL course.
- SQL training environment.
- fully platform independant and light weight (Using QT).
- execute queries and view results instantly.
- save a "bundle" file of queries and database (homework file).
- As SQLite is sometimes too permissive we would like to prevent/alert user on : selection of non-aggregated fields in an aggregated query, double aggregated functions, nested selets in select parameter list. This requres implementing a simple SQL parser to detect these cases.
- double click to show table
- context menu to rename a query
- export option in file menu to export sqlearn file into separate sqlite db, and text files with queries