Settings

Theme

Show HN: Graphical SQL Builder and Debugger

github.com

21 points by matei88 · 7 comments

Reader

5 threads
webofmarius

hey guys, I am the creator of the SQLJoiner project. Nice to meet you all :)

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).

ElenaDaibunny

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

  • lolive

    Isn’t the big problem of SQL visualization coming with subqueries and the WITH statement ?

XorNot

The Microsoft Access query builder is back!

  • lolive

    Did the story end well for that tool ? (Does it still exist in Access 365?)

whattheheckheck

Plans to support other sql flavors?

levi840714

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.

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection