TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

BlocklySQL: A new block-based editor for SQL

128 点作者 leeuw01超过 4 年前

13 条评论

misterdata超过 4 年前
We have been using something like this based on Blockly in production for over seven years now to build dashboards. GIF demo: <a href="https:&#x2F;&#x2F;www.dialogic.nl&#x2F;wp-content&#x2F;uploads&#x2F;2018&#x2F;02&#x2F;demo1.gif" rel="nofollow">https:&#x2F;&#x2F;www.dialogic.nl&#x2F;wp-content&#x2F;uploads&#x2F;2018&#x2F;02&#x2F;demo1.gif</a><p>Our users (researchers) had no problems learning the concepts of querying but didn&#x27;t want to be bothered learning SQL syntax - hence we built this (also, our system does quite a bit of magic behind the scenes to allow mixing e.g. CSV data with data from a database, and also allows for things not easily done in SQL, e.g. pivot tables, so it&#x27;s not just SQL).
评论 #25526450 未加载
评论 #25537730 未加载
Cieplak超过 4 年前
<i>What is the Deutsch Limit?</i><p><i>A term made up by Fred Lakin describing a comment Peter Deutsch made at a VL talk by Scott Kim and Warren Robinett about a visual machine language they had invented.</i><p><i>Deutsch said something like:</i><p>&gt; <i>&quot;Well, this is all fine and well, but the problem with visual programming languages is that you can&#x27;t have more than 50 visual primitives on the screen at the same time. How are you going to write an operating system?&quot;</i><p><i>This points out the obvious density advantage of text. This barrier has become known as the &quot;Deutsch Limit,&quot; stated as:</i><p>&gt; <i>The problem with visual programming is that you can&#x27;t have more than 50 visual primitives on the screen at the same time.</i><p>...<p><i>This is clearly a problem with visual representations. However, it is not immediately clear to me that a similar limit does not also exist in textual languages.</i><p><i>When textually programming I frequently use an Emacs window with about 50 lines of text on my 19&quot; monitor. Anyone older than about 35 complains that they cannot read the text because the font is too small. I use a lot of whitespace in my programs, so we might assume that the 50 lines in the editor contain 40 meaningful lines. Most common programming styles dictate limiting the number of &quot;primitives&quot; or statements to one or two per line, giving my textual screen at most 80 primitives.</i><p><a href="http:&#x2F;&#x2F;www.faqs.org&#x2F;faqs&#x2F;visual-lang&#x2F;faq" rel="nofollow">http:&#x2F;&#x2F;www.faqs.org&#x2F;faqs&#x2F;visual-lang&#x2F;faq</a>
评论 #25526106 未加载
评论 #25527044 未加载
sfgweilr4f超过 4 年前
I like the idea and the look of the whole thing but I couldn&#x27;t figure out how to easily<p>SELECT * from customers<p>so... I&#x27;m kind of bummed out. The blocks seemed to not stick together. They&#x27;d just &quot;island&quot; and sit by themselves. I finally managed to push them together for a &quot;SELECT FROM customers&quot; combination of blocks. But there was a &quot;clause&quot; thing stuck on the screen.<p>I felt like this should be a really quick thing to do.<p>After all that I then got:<p>Ungültige Abfrage: Unknown table &#x27;web1312.customers&#x27;<p>so the table I selected didn&#x27;t even exist. Possibly.<p>Sadness.<p>(Maybe its a firefox thing? Can I blame firefox?)
评论 #25524977 未加载
tangus超过 4 年前
Well, I spent 5 minutes laboriously building a query for the whole thing to hang on me when I reached the ORDER BY clause.<p>I actually don&#x27;t see how this is better than a cheat sheet with SQL keywords and autocompletion of tables&#x2F;fields.
评论 #25531005 未加载
xaedes超过 4 年前
Suggestion: Make the block palette sections collapsable, so one see more than just one category. The way it is, it is a lot of unnecessary clicking.
leeuw01超过 4 年前
Paper: <a href="https:&#x2F;&#x2F;www.researchgate.net&#x2F;publication&#x2F;336754811_BlocklySQL_A_new_block-based_editor_for_SQL" rel="nofollow">https:&#x2F;&#x2F;www.researchgate.net&#x2F;publication&#x2F;336754811_BlocklySQ...</a>
评论 #25524540 未加载
ben509超过 4 年前
Very cool. I think it might benefit from some kind of context. If you could select an open piece, it could restrict the available pieces to what&#x27;s valid at that point.
victor106超过 4 年前
This looks really cool.<p>Anyone know of a tool that can parse a complex sql and generate a table diagram showing the various joins etc.,?
评论 #25526070 未加载
评论 #25524674 未加载
评论 #25524823 未加载
评论 #25525377 未加载
51Cards超过 4 年前
I used to use a tool called FlySpeed SQL Query that had a great quick SQL builder using a UI. This reminds me of it a lot (though it wasn&#x27;t block based). Great concept!
renke1超过 4 年前
This might be useful to teach beginners in our company the basics of SQL. We already use a rather &quot;playful&quot; approach to teach Java to them.
评论 #25528998 未加载
quantumwoke超过 4 年前
Completely freezes up permanently after placing a single block for me on Chrome latest, Windows.
hardwaresofton超过 4 年前
I get a blank screen on top where I assume a diagram should be in FF 85.0b3 (64-bit)
评论 #25525534 未加载
ris超过 4 年前
Um, nope. Couldn&#x27;t figure out how to use the JOINs and gave up.
评论 #25531028 未加载
评论 #25532095 未加载