Show HN: Graphical SQL Builder and Debugger(github.com)
github.com
Show HN: Graphical SQL Builder and Debugger
https://github.com/webofmarius/SQLJoiner
7 comments
visual SQL builders have been around forever, most feel like they were designed by someone who never writes joins, this one has reverse-engineering from existing SQL which is enough to try it
Isn’t the big problem of SQL visualization coming with subqueries and the WITH statement ?
Plans to support other sql flavors?
Visual SQL builders live or die on the import direction — pasting an existing messy query and seeing it laid out is way more valuable than building from scratch. How robust is the SQL → canvas parsing? That's the feature I'd actually come back for.
Thank you for the feedback.
The project was created to help navigate (understand in my head) large/complex queries done by other people.
To answer your questions: 1. Plans to support other sql flavors? - SQLite support has been recently implemented - Maybe in the future, Postgresql. - Nothing from Microsoft. Sorry, I rarely use Microsoft software. 2. How robust is the SQL → canvas parsing? - It is basic (draws correctly simple SELECT, WHERE, JOINS). Feature upgrades require manually drawn query contexts (feedback for RE).