Oh these boring database IDE’s!
Posted by carl.reitschuster on 29th May 2006
Hi reader,
Since 15 years i am working with the Oracle Database and as a Developer with GUI driven oracle tools. But what slowly gets boring it that no new GUI driven concept hase been developed for. Consequential an application for database development has an SQL window, a data grid and database object browser and some editing functionality. OK some tools for example compare user objects, or generating DDL of a database object.
in the whole all tools are very similar - there is nothing new indeed. Some exception for example was Spotlight on Oracle with a very clean interface design. But from the same company there is a tool with thousands of menu points addressing all the options the database server has.
How should be designed a Database Tool for the Future? Some aspects I’ve seen in some products. For example Refactoring well known in the Java Eclipse Community and in the Visual C# Community is something upon the base functionality.
- Why not simple drag a single procedure to a package and drop it and it’s included in the package header and body.
- Why not drag a column and drop it to another table - a submenue opens if the column should be moved and a migration script is automatically generated or only the attributes of the column are copied to the target table.
- Why not simple copy a table from on instance to the other via drag and drop?
- Why not creating a materialized view definition when i drag and drop a query text to an Mview Symbol?
Yes - i am waiting for a sensational product giving comfort developing database side objects never seen before.
Karl
Posted in Personal | 1 Comment »