Immerse SQL editor is very useful to test some queries, build views, etc. It needed a redesign. Here are some details of the redesign process.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyyUP6oTtUm4FjfOIyWMzs8HsO49WrfzZDrSJIa_IXFIcVvb-7F9Osf2cR3dz-AAv1Hcd6ggUmYvttdlndM5B9ht5BTUvPIZ0g0TeziM7TSxr6hqM6tDBCFWNupAGOEdY7PpoX433iDg/w640-h348/Capture+d%25E2%2580%2599e%25CC%2581cran%252C+le+2021-02-24+a%25CC%2580+22.59.12.jpg)
We needed some new functionalities like:
- Better syntax highlighting, autocomplete, SQL formatting and validation
- Better table/column browser with filtering
- Query history with preview data
- Reusable query snippets
- Run multiple queries in the same context instead of notebook-style
- Notifications
- Shapefile query results
So after the phase of requirements gathering and research, we started wireframing.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiymvuw6LKzTCDCLHNxx-6d1qappoFAn9xnwqJGY4mZfazcoyDfNgDTbkqWWwCtFb9cDr7qJOlojRsfpItSaqxqCNM9SMSWrwjJIcj0ZxwF2tm_dHL-1QEvarQN9DUL5U5gyNQl8EaE8g/s320/Capture+d%25E2%2580%2599e%25CC%2581cran%252C+le+2021-02-24+a%25CC%2580+22.51.46.jpg)
At OmniSci, we maintain a nice set of Figma components that we use to compose
mockups quickly.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibJHRM75ln5Gamg3QbknOVkqMcrpQleKbtl8l6i6K9g6rtHJAB9tQSNWFg0axmZAdb7oUV4IEq5SMhgpnpf-xQLqgVQsjnFObbW5d243IKFQDf-gGZCRf8-wDQyZO7iUc36lWCGb6kzA/w640-h344/Capture+d%25E2%2580%2599e%25CC%2581cran%252C+le+2021-03-05+a%25CC%2580+22.38.29.jpg)
Here is the result of the SQL Editor redesign.
Before:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnoUrQZK9UvSfj_cRh7YjhucVFqXypYhVUeN8Y11K_wfhHq0BLDIMlRhKskntSVu_6WIUmCLACFb7wFk_yft5gZ7LGqk9nNFyY2zQk-jsgqVpTZJNiap7E6T9Mi8KCTWV1gxK-_EHZGQ/w640-h350/Capture+d%25E2%2580%2599e%25CC%2581cran%252C+le+2021-03-08+a%25CC%2580+09.16.31.jpg)
After:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCowjjojcCd88LqC0dix1y2XRROltRdlSVS_DMVq5rXGYGylHvpxvjYlfKpBx5_FidQM3GFcn2gouZwhfABEWGBi6XT0ceBTZTaewYVYyNJvFp0it8rl0qHZTUWOQxLlNC72KhOvppYg/w640-h350/Capture+d%25E2%2580%2599e%25CC%2581cran%252C+le+2021-02-24+a%25CC%2580+22.58.38.jpg)
If you don't see a big difference, that's a good thing. All the barely visible
features that facilitate editing, like key shortcuts, notifications,
simplified flow, automatic formatting, validation, query history and snippets
makes a big difference in usability without adding much cognitive load.