An intuitive browser-based SQL console to run and save SQL queries.
Snacks@console is a PHP based application. Before you use it, you have to make sure that your system is ready to run PHP applications. All web server such as Laragon (recommended) or XAMPP provide bundle all the requirement to run a PHP based application in one package.
After you setup your webserver. Open the command line inside the web server's root directory, usally www
, and follow along the installation process
we recommend installing this package through composer :
composer create-project mazentouati/snacks-console "console"
Note: make sure that your web server enables the RewriteEngine.
This is an initial version, it's just a prototype to test and enhance the current experience. We plan to add the following features :
currently the console supports the following commands:
- Select
- Update
- Delete
- Insert
- Use
database
Theoretically, it can execute any SQL command but we plan to make the experience of DDL ( data definition language ) like Create
or Alter
more accessible by supporting interactive inserting in the console.
Additionally, we plan to add syntax highlight for the SQL commands
currently, the data shown when using select
command isn't interactive. We plan to make the table resizable, the cells clickable ( shows full column's data when click ) and whatever required to make it interactive.
Unfortunately, I'm overwhelmed by Snacks project and it's sub-projects. I'll incrementally add the documentation, tests for both the source code and the application.
very SOON...
Please check the guide
If you like to contribute by writing the JavaScript tests, It would be great !
© MIT | 2018, mazentouati/snacks-console