Hello All,
My Customer is looking for vsql alternatives with graphical gui.
We proposed him DBeaver but he did not like it, at all. DBVis for VERTICA has limitation for one session only (I have never tested commercial version). This is one of major disadvantage against MS SQL. (Users are business side data scientis )
So I am looking for alternatives:
Main functional requirements:
- Syntax highlighting
- Query clause completion hints, object completion hints
- Tree visualization of the object
- Fast script generation (useful if table is very wide > 100 column) --> smilar as DBeaver has
- DDL generation with projections
- Keyboard shortcuts
- **Very important: **ability to run more than one query in two different tabs in parrarel: i.e: one query takes 20 min so they would like run other queries, whithout waiting for the first query to complete (of course if there are resources in the pool).
- **Very important #2: **they want to run whole scripts from GUI, and they would like to have flexibility to stop script on error or continue, showing entries in logs in which there were errors (like in our vsql)
They are using native client of MS SQL server (they are get used to it) and they are looking for sth smilirar.
Question:
What are your experiences. What Graphical GUI DB clients customer are using (OpenSource or Commercial). Can You recommend me sth.?
I have found couple of them, here is my list (most of them I haven't tested yet):
1. DB Visualizer (Commercial)
2. Data Grip (https://www.jetbrains.com/datagrip/features/)
3. SQL Workbench/J - http://www.sql-workbench.net/
4. DB Solo - http://www.dbsolo.com/
5. RazorSQL (http://razorsql.com/index.html )
6. Squirell - as it crashes often it is not a good choice
7. Aqua Fold (http://www.aquafold.com/dbspecific/vertica_client.html) - on some forums at 2013 someone wrote - that they do not use Vertica features. - maybe it has changed with latest release.
8. Sqlectron (https://sqlectron.github.io/#gui) - completely new OpenSource
9. Heidisql - (https://www.heidisql.com) - supports JDBC - but don't know how work with Vertica
Any experiences with above ones?
Thanks in advance
