|
 Today there are many database types available on the marketplace: Microsoft SQL Server, Oracle, DB2, MySql, Posgres, AS400... Each has their own peculiarities and features. Unfortunately, however, each is scripted with their own syntax. For instance, different commands are needed to extract the first three characters from a string field:
Oracle |
SUBSTR(‘ABCDEF’, 1, 3) = ‘ABC’ |
DB2, MySql, Access |
LEFT(‘ABCDEF’, 3) = ‘ABC’ |
Postgres |
SUBSTRING(‘ABCDEF’ from 1 for 3) = ‘ABC’ |
SQL Server |
SUBSTRING(‘ABCDEF’, 1, 3) = ‘ABC’ |
This gives a rough idea of what it is like to develop a state-of-the-art application which can use virtually any database type in the most efficient way.
With Instant Developer the type of database used by the application can be changed at any time with the following simple operation: open the database properties window, change the database type and recompile the application. Instant Developer will automatically reconfigure all expressions used in the query so that the syntax employed matches up with that requested by the type of database selected. Thus, the same type of application will run on Oracle, SQL Server, DB2 and, why not, on Postgres free database.
In addition, triggers or stored procedures can be created from within the development environment. At compile time Instant Developer will generate a list of SQL instructions needed for the creation of triggers and stored procedures in the selected database. If the type of database is changed, Instant Developer will automatically recompute the SQL code needed for the creation and/or update of views, triggers and stored procedures in the new database.
Learn more on the independence from languages and technologies, or find out In.de functionalities for managing E/R schemas.
|
