Login
Register
Actian.comUseful or not?
I have shared some very simple script I wrote and using for a while. Personally, I think every Ingres user could use it. Especially a new users with some experience with other databases. It is just another Terminal Monitor with few tricks. Once session is started, user can list existing user databases, create or delete database, connect to a database and run SQL statements, disconnect and connect to another database and more. I am sure a few more useful things can be added to make it even better. Some better error handling also comes to mind.
Detailed description and script itself can be copied from here:
Another_terminal_monitor
Sometimes, little changes can make a difference. Would love to hear your ideas on this one and maybe on some other little tiny things which can be done to improve usability and overall Ingres experience.
UPDATED (10/8/10): Version 3 is created and posted at
Another Terminal Monitor v3
Eugene.
You can view some other little things I shared on my page, at: http://community.ingres.com/wiki/User:Ekar
Total Comments 7
Comments
-
Hi, Eugene! I downloaded your Terminal Monitor script yesterday and in fact find it pretty useful. A frequent task for me is to look up existing databases and it is complicated to start accessdb each time.
To have your script run on my client machine I replaced iidbdb within the script file by dba::iidbdb where dba is the node to connect to the DB Server. May I suggest to have the node name as a parameter or option?
Thanks for sharing your program!
Cheers,
Chris.Posted 2010-08-31 at 02:02 AM by cbirkl
-
Thank you, Chris.
I like your idea, so I added vnode functionality into the script. Will post it shortly, as link to another version from the original page.
Thank you for your input.
EugenePosted 2010-08-31 at 08:52 AM by ekar
-
Here is direct link to the v2 of this script.
AnotherTerminalMonitorv2 - Ingres Community Wiki
EugenePosted 2010-08-31 at 12:30 PM by ekar
-
Thank you, that's elegant and useful!
Chris.Posted 2010-09-01 at 04:08 AM by cbirkl
-
I have added one more tiny thing - list of existing vnodes - I think it will be useful to know what vnodes are exist before using "net" command (to connect to remote node). Command added is:
net list
EugenePosted 2010-09-03 at 06:36 AM by ekar
-
Good idea, thank you!Posted 2010-09-07 at 08:51 AM by cbirkl
-
I have added version 3 - please see link to the page I posted in the blog entry - page include description of the added stuff.
Thank you,
EugenePosted 2010-10-08 at 06:38 AM by ekar
