swapnilmj
/
web-vqd
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
A Web-based Visual Query Designer for Mysql. https://swapnilmj.github.io/web-vqd/
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
40 Commits
1 Branch
0 Tags
188 KiB
 
 
 
 
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
Go to file
swapnil.gnu 1debdad207
minor fix 		1 month ago
ajax initial commit 11 years ago
coffee various changes 10 years ago
css updates 1 month ago
images/icons initial commit 11 years ago
js loads table list on click of addTable btn ; Fade effects. 11 years ago
.gitignore minor 11 years ago
LICENSE initial commit 11 years ago
conn.php Minor UX change 1 month ago
index.php updates 1 month ago
lib.php initial commit 11 years ago
readme.md minor fix 1 month ago
table_sel_list.php updates 1 month ago

readme.md

Web-based Visual Query Designer

Codeberg repository GitHub mirror

Web-based Visual Query Designer is a tool for visually generating SELECT SQL queries. Currently, it is designed only for MySQL .

Feel free to try this tool for generating simple SELECT queries for the MySQL database.

Think of it as a supplement to your MySQL front-end tool (like phpMyAdmin ).

Online demo (adapted for a static website)

Screenshots

Design queries visually

Example

Drag-n-drop

Drag-n-drop

Screencast

Youtube / Invidious

Dependencies

  • apache2
  • mysql server
  • php7
  • php mysqli extension

Installation

Extract all the files to the www folder of your web server. Open conn.php file and set the $username and $password for your MySQL database. This user (configured in conn.php) needs to have atleast READ access to information_schema.

Limitations (as of now)

  • A join can be made between 2 tables only on one set of condition

  • Aggregate queries and sub-queries are not yet supported

License

Web-based Visual Query Designer is an open source software released under the MIT License.

Feedback

Please let me know if you find it useful.

Swapnil Joshi

swapnil [dot] gnu [at] gmail.com