Visualize SQL Queries
Learning and science
sql education visualisation
SHOW HN2022
Legend
Visualize SQL Queries
My co-worker and I were debugging a SQL issue; having not seen SQL in two years, I embarrassed myself by…
animatesql.comHow HN took it
3 positive, 1 neutral or asking, 2 mixed, 7 critical, out of 13 comments about the project. Thread score -0.23.
Idea: 2 for, 1 againstDesign: 0 for, 2 againstExecution: 0 for, 2 againstPerformance: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful for understanding joins and LEFT JOIN.
From 2 comments
Thank you for building this! I now understand the LEFT JOIN story shared a couple days ago.
FR10 on HNReally cool for joins. It would be nice to be able to adjust the speed after you already started an animation, and maybe play/pause. I also expected to be able to type into the…
dsmmcken on HN
Good for studying SQL.
From 1 comment
In overall, it seems good, I'll use it while studying SQL.
gozeloglu on HN
Objections
Procedural animation may mislead about declarative SQL and execution.
From 2 comments
I'm not sure a procedural visualization is appropriate for a declarative language like SQL. It can be misleading both on underlying concepts (sets and relations) and actual query…
ComodoHacker on HNThis may help you mentally map in brain what happens. But this is all table scanning and doesn't include indexes, which organize data in a tree. When you do SQL, you should…
jve on HN
Ignores indexes and real query execution.
From 1 comment
This may help you mentally map in brain what happens. But this is all table scanning and doesn't include indexes, which organize data in a tree. When you do SQL, you should…
jve on HN
Unusable on mobile because examples span pages.
From 1 comment
Promising. Unusable on mobile since the examples span multiple pages
hackernewds on HN
Requests
Support more complex queries.
From 1 comment
Very nice ! Would be happy to see more complex queries in the future, did you plan any update ?
23202586 on HN
Play/pause and speed control during animation.
From 1 comment
Really cool for joins. It would be nice to be able to adjust the speed after you already started an animation, and maybe play/pause. I also expected to be able to type into the…
dsmmcken on HN
Fix LIMIT and OFFSET support.
From 1 comment
LIMIT not working. Try: SELECT whiteRating, blackRating FROM ChessGames WHERE gameWinner='black' LIMIT 2 OFFSET 8;
ieee2 on HN
Fix disabled duration buttons.
From 1 comment
Bug report: The buttons used to change the animation duration do nothing, probably because the buttons have the `disabled` attribute applied.
Natfan on HN
Questions
Has the maker seen revj or QBE tools?
From 2 comments
Did you ever see http://revj.sourceforge.net/ ?
flarg on HNCan't you also do this with Microsoft Access or LibreOffice Base? I think it's called QBE, or Query By Example.
zozbot234 on HN
Alternatives named
QBE in Microsoft Access or LibreOffice Base.
From 1 comment
Can't you also do this with Microsoft Access or LibreOffice Base? I think it's called QBE, or Query By Example.
zozbot234 on HN
revj.sourceforge.net
From 1 comment
Did you ever see http://revj.sourceforge.net/ ?
flarg on HN