I love Evidence.dev, it’s a great tool!
I love how fast your workbench runs, and how effortlessly it renders 60k rows in the browser
Some UX feedback, if you're open to it:
- It was initially unintiutive for me that I needed to highlight a whole SQL statement to get Ctrl-Enter to run it. Also a prompt that this was the correct shortcut would help!
- I dragged in a CSV file, and the name was too long to show up in your table explorer, so I couldn't tell what the table name had been called (it turned out I needed to `select * from table_name.csv` - the csv postfix was unexpected
- The CSV file had headers, but they were not auto detected - would be good to be able to configure this
What would be a more intuitive way from your POV?
I‘ll look into the horizontal scrolling/CSV header issues, thanks!
Check out what Postico does; it just highlights the current statement under the cursor by default and that's what gets run by default. Can't resist imposing this subtle SQL UX on everyone because it's my favorite (for like 10 years now).
I‘ll look into this as fallback method. I don’t like Monaco Editor‘s handling of selections and cursors, it’s quite complicated, but this should be possible to implement…
I think I would execute the SQL query that the cursor was within.
Ie anything until the next ;