Pavol Kakačka

cross

KDatabaseStudio

A database administration tool for developers. Includes an amount of efficient features.

KDatabaseStudio

For developers

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".

For developers
Clear design

Clear design

The emphasis was placed on uncluttered design. There was also colored syntax of SQL code and color differentiation of the data in tables.

Clear design

'The Whisperer'

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.

'The Whisperer'
History of commands

History of commands

Each of the performed SQL queries was possible to find and run again without any need of writing it again.

History of commands

Comparison of metadata

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.

Comparison of metadata
Maximization of the performance

Maximization of the performance

A tool was used for increasing of the speed of queries (optimization). That tool displayed how and how quickly the database performs the query.

Maximization of the performance

Automation

This is how a generated SQL script for a database 'trigger' looks like.

Automation

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)