SQL Editors
Posted: Fri Oct 23, 2015 12:23 am
Hi Patrick,
I guess the SQL Explorer can do 100 times more. And besides that there are certainly dbSchema (Gary swears by it) and dbVis
http://eclipsesql.sourceforge.net/screenshots.php
http://www.dbschema.com/
https://www.dbvis.com/
Our tiny SQL Editor has three functions that we did not find elsewhere:
1) it is integrated into our own solution, so that we can SELECT and UPDATE data without switching to pgAdmin, also when we are with a customer using the solution
2) getting the names of tables and fields with a mouseclick, from large tables that show at once, instead of typing them in or opening table/field-trees with the +-button, which needs time
3) change (flush) any updated data right away in our client, so that we can see the actual changes at once without starting the client new
From Foxpro, I was used to have direct access to my data in my own solution, and I wanted that feeling again.
That was also the reason why we created the Data Record Editor:
https://www.servoyforge.net/attachments/download/1571/Screenshot_Example.PNG
https://www.servoyforge.net/projects/editwindow
I guess the SQL Explorer can do 100 times more. And besides that there are certainly dbSchema (Gary swears by it) and dbVis
http://eclipsesql.sourceforge.net/screenshots.php
http://www.dbschema.com/
https://www.dbvis.com/
Our tiny SQL Editor has three functions that we did not find elsewhere:
1) it is integrated into our own solution, so that we can SELECT and UPDATE data without switching to pgAdmin, also when we are with a customer using the solution
2) getting the names of tables and fields with a mouseclick, from large tables that show at once, instead of typing them in or opening table/field-trees with the +-button, which needs time
3) change (flush) any updated data right away in our client, so that we can see the actual changes at once without starting the client new
From Foxpro, I was used to have direct access to my data in my own solution, and I wanted that feeling again.
That was also the reason why we created the Data Record Editor:
https://www.servoyforge.net/attachments/download/1571/Screenshot_Example.PNG
https://www.servoyforge.net/projects/editwindow