71–80 of 90 posts
The idea is good, but the UI is all but immersive. Things that would it make more immersive: - autocomplete - and/or the ability to view the schema alongside the query (on a wide enough screen) - a way to copy table and column names easily with a click (table names cannot be selected at all!) - ability to just add more queryies under/over the already executed ones, instead of only being able to replace them.
The idea is good, but the UI is all but immersive. Things that would it make more immersive: - autocomplete - and/or the ability to view the schema alongside the query (on a wide enough screen) - a way to copy table and column names easily with a click (table names cannot be selected at all!) - ability to just add more queryies under/over the already executed ones, instead of only being able to replace them.
This is cool! Great job! I completed the first challenge. I guess I’m used to sql server management studio I tried running multiple queries at once and wasn’t able to. I also tried writing a comment with two dashes to keep track of the id’s and it replaced most of my query with dashes. It might have something to do with being on mobile on iOS.
Thanks for pointing that out. I just fixed the single line comments. It should work as expected now.
Love this! The style is unique and awesome. I see the beginnings of a really fun way to learn / practice / remember SQL. A few notes: - Would be cool if it was a single workspace (no tabs). Was constantly switching tabs back and forth. - Saving previous SQL queries and results would be cool. I was copying results into the notes. Feel like this is important as things get more complex. Excited to see where you take thi…
The editor behaves weirdly when I try to add comments. It's hard to explain, but you can reproduce like this: 1. Write several lines, for example: select i.*, s.* from interviews i join suspects s on s.id = i.suspect_id 2. Try to comment each line on its own by typing -- in front of each line. -- select i.*, s.* from interviews i join suspects s on s.id = i.suspect_id -- select i.*, s.* -- from interviews i join susp…
Earlier quoted context omitted.
You should be able to add -- and comment out lines of queries. If not, this is a bug that I will investigate. Also you can use the Notes tab to store any past queries and findings.
It works for the first line, but doing it on a second seems to make it merge lines.
When I click on SQL Workspace, I get an error: > Failed to load database Can't find variable: WebAssembly
Really cute. But I really want the ability to put the different tabs -- Brief, Workspace, Schema -- side-by-side. I know SQL and wanted to play with this, but the UX was frustrating enough to drive me away, even though it is really pretty.
Earlier quoted context omitted.
That's a good suggestion. I'm not sure if screen real estate won't be a problem though.
Maybe modeled after browser dev tools. Big display at the top, small repl at the bottom with a dragged to resize. Also tab structure and the “menu” are chewing up a lot of vertical real estate for two classes of data most users won’t see as separate. The schema ui seems to be big because of the graph display… which is not at all done baking yet. The hard part of displaying graphs is the pathing, and the very first on…
The idea is good, but the UI is all but immersive. Things that would it make more immersive: - autocomplete - and/or the ability to view the schema alongside the query (on a wide enough screen) - a way to copy table and column names easily with a click (table names cannot be selected at all!) - ability to just add more queryies under/over the already executed ones, instead of only being able to replace them.
Thank you for the suggestions. I have just implemented the following: - Side by Side view to open up two different tabs at the same time - Copy button to copy table names