If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > SPL development tool: DBStudio for Informix

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2004
Posts: 11
SPL development tool: DBStudio for Informix

Hello Informix users:

I'm offering DBStudio for Informix as a Free application in trail mode (you can't save or restore files, but you can do everything else.)

If anyone is interested in trying this software, please e-mail me.

DBStudio for Informix is a SQL Delphi-like Editor IDE for rapid store procedure
and query development. It is targeted for Software developers and database
administrators primarily.

The primary objective of DBStudio is to enhance and speed up SPL database
development.


--------------------------------------------------------------------------------
1.) INTRODUCCION
--------------------------------------------------------------------------------

This is version 1.0.9 of DBStuido for Informix.

DBStudio for Informix was/is developed completely by:

- Jose J. Sanchez Rico (jesussanchez@iteso.mx,
SanchezJose@hotmail.com,
jesussanchez@mayanresorts.com.mx,
is34704@msn.com (Messanger))

PLEASE REPORT BUGS, NEW FEATURES, PROPOSALS TO THE EMAILS ABOVE WITH DBSTUDIO AS
SUBJECT.

DBStudio for Informix is a SQL Delphi-like Editor IDE for rapid store procedure
and query development. It is targeted for Software developers and database
administrators primarily.

The primary objective of DBStudio is to enhance and speed up SPL database
development.

DBStudio is FREE, as is, without guarantees or support of any kind.
(But will be willing to add new features and fix bugs).

--------------------------------------------------------------------------------
2.) HISTORY:
--------------------------------------------------------------------------------
DBStudio was born because of my need to develop triggers, views, and
store procedures for a LARGE informix database. I never found an IDE or Editor
that could fit my needs for managing source code, the way Delphi does it for
Pascal code. So I developed this tool to help me do so.

--------------------------------------------------------------------------------
3.) INSTALATION:
--------------------------------------------------------------------------------
1. Unzip to folder and use.
2. To create a conection to an informix database you must put the values as int
Setnet32.

Example:
Connection: Name of the connection "My connection"
Instance / Server: on_informix
Database: dbmydatabase
User: informix
Password: mypassword


--------------------------------------------------------------------------------
4.) FEATURE LIST:
--------------------------------------------------------------------------------

1. Advanced Syntax Highlighting for Informix
a. Tables
b. Stored procedures
c. Reserved words
d. Data types
e. SQL Functions
2. Code Completion.
3. Code Templates. (Customizable).
4. Store procedure parameter listing
5. Bookmarks
6. Find-Go to store procedures
7. Search, Replace, go to line…
8. DB Properties Treeview with
a. Tables (Columns, Primary Keys, Foreign Keys, Indexes,
Unique Constraints and Check Constraints
b. Store procedures (and their definition)
c. Views (and their definition)
d. Triggers (and their definition)
e. Other Database types
9. Printing with syntax highlighting.
10. Save-restore sql files.
11. Multiple editor windows
12. Telnet integration (simple telnet).
13. Languages (Spanish, English)

--------------------------------------------------------------------------------
5.) KNOWN BUGS:
--------------------------------------------------------------------------------

1. Executing multiple non-query statementes (create, insert...) does not
work sometimes (Drop-create Triggers). Must be done 1 by 1.
2. Subqueries not supported completely for viewing.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Nov 2004
Posts: 11
FREE: DBStudio for INFORMIX

DBStudio for Informix is now completely FREE!!!!

Save and restoring files has now been implemented, along with a lot of usefull features such as...

Ctrl+Click on a table/view to open the data,
Ctrl+Click on a trigger, store procedure to open its code.

Saving changes in tables in query view...

Jose Sanchez
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Nov 2004
Posts: 11
DOWNLOAD DBStudio for Informix at...

Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Nov 2004
Posts: 11
DBStudio for Informix FREE FULL VERSION download

Download the FULL FREE version of the installer at :


http://kino.iteso.mx/~caceves/DBStudio/index.html


Please email me with bug’s, wanted features...


Informix ClientSDK, and Setnet32 is needed for connectivity to Informix databases.


Thanks
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Nov 2004
Posts: 11
New version out!

Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Nov 2004
Posts: 11
DBStudio: Another new version out!

http://kino.iteso.mx/~caceves/dbstudio/

-------------------------------------------------------------------------------
Version : 1.0.25
Date : 24-Nov-2006
Description: 1.) Localization corrections, some conection messages where still
in spanish.
2.) New conections now fixed. Specially if its the first connection.
3.) CLIENT_LOCALE can now be configured manualy in the conexiones.dsc
(In the connection form, using the "manual" button.
UPCOMING FEATURES:
b.) Compatibility with FreeVCS.
c.) INI file configuration menu and screens.
e.) Tool: Source code correction.
Identation, change tabs for spaces.
g.) Search form: Interaction with editor at the same time.
h.) When compiling, the editor does not maintain correctly the
scroll position.
i.) Form for short-cut configuration.
j.) Action for deleting backup files.
k.) Copy AND SELECT grid to clipboard, be it a column, row or
al grid info.
m.) Save default conection
o.) Pressing Ctrl must hyperlink the selected row if it's a word
that will open something (SP, Trigger, view, table name...)
p.) Sintax analyzer
q.) Debugger?
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
Version : 1.0.24
Date : 21-Nov-2006
Description: 1.) SynEdit component update, now using version 2.0.3, this version
is updated however.
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
Version : 1.0.23
Date : 13-Nov-2006
Description: 1.) Copy information from grid to clipboard, be it a column, row or
all grid info, as a popup menu for the grid, it currently does not
select the column or row.
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
Version : 1.0.22
Date : 27-Oct-2006
Description: 1.) Delphi database components treat ':' as a parameter calling, it
has been fixed changing it to a '::' so it can function internally.
-------------------------------------------------------------------------------
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On