Interactive SQL

Scriptcase 8 Discussion
#1

Does anyone know what software is used to do this:

[ATTACH=CONFIG]n69789[/ATTACH]

I got it from this Scriptcase related video (7 minutes), which looks interesting:
https://www.youtube.com/watch?v=y07mJnfyo2w

It is in Spanish, which I don’t understand at all.

If someone speaks Spanish and watches the video, I would appreciate if you could explain what he is doing.

What is the relation between SQL in the grid and the Interactive SQL that he shows. I was expecting him to copy the code into the SQL of the grid, but he doesn’t do it.

Also, what software is he using?

Thanks for any info.

2016-07-07_17-23-14.jpg

#2

Afaik https://www.webyog.com/

#3

the screeshot looks like the old “dbisql”-Util from sybase :wink:

#4

Hi. Its IBOConsole of Firebrird. here a english video: https://www.youtube.com/watch?v=6n7rnpBScqs

#5

Yes it is IBConsole, thanks alvagar!

Actually https://www.webyog.com/
suggested by Albert looks pretty interesting.

I have also looked at Navicat and dbForge Studio.

Anyone using these or another tool? Do they help much with Scriptcase development?

#6

Out of the 3 tools, for me the only valuable feature would be inteligent data synchronization. That allows to backup automaticaly changed data and keep the copy of your data on another server. In case of a disaster this would be very helpful. Everything else can be achiever with tools available from MySQL or related sites at no charge. My SQL GUI tools are great for that. Workbench helps in design and syncing the structure so I would not bother to pay $300 for just one or two features to use. If you use however other SQL databases it might have more value. I don’t think there is something like MySQL Workbench for MSSQL , Postgress etc.

SC quary builder (while not perfect - still has some bugs) is excellent for building more complex stuff - why not to use it.