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.
We neded 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
- Shapefile query results
So after the phase of requirements gathering and research, we started wireframing.