KDatabaseStudio
A database administration tool for developers. Includes an amount of efficient features.
A database administration tool for developers. Includes an amount of efficient features.
KDatabaseStudio is a tool for developers. It allowed to design, create and manage a different types of databases.
Its advantages were a variety of nifty functions that dramatically increased the efficiency of the development of database applications. For example the ability to find data only in the columns that start with the word "Date" and in all of the tables that start with the word "Firm".
The emphasis was placed on uncluttered design. There was also colored syntax of SQL code and color differentiation of the data in tables.
When a programmer needed to write the code it was enough only to write one or two letters and the program "predicted" and offered the possibilities for the programmer to write. These search whisperers are commonly known from Google search or smartphones.
Each of the performed SQL queries was possible to find and run again without any need of writing it again.
Comparisons of the database entities became as a great helper. You can see here a comparison of the differences between selected tables. The different columns (fields) are marked by color.
A tool was used for increasing of the speed of queries (optimization). That tool displayed how and how quickly the database performs the query.
This is how a generated SQL script for a database 'trigger' looks like.
Here's depicted a development tool in which was the application developed along with part of the code.
A form in the right part shows how the main window of the application is seen by the programmer. Just before the compilation of the program to the executable form for the end user.
(Note: the images corresponds to the application state of 2001)