|
Variety is the spice of life. However, when a company needs to manage data or offer its products to prospective customers they are often confronted with various types of database servers which may be employed. This is a problem which is not easy to overcome.
SQL codes differ greatly from one database to the next, be they free databases such as Postgres and MySQL or other types (Oracle, SQL Server, BD2). Furthermore, each database requires its own management console which is needed to create or edit tables, views, triggers and stored procedures.
Getting acquainted with all databases is expensive, as is creating independent applications. Historically, database administrators have employed tools such as Er-win which were able to ensure a certain level of compatibility over various database types, although their usefulness was limited to schema management and had no impact on application development.
Instant Developer gives you total freedom. The database management integration module ensures definition and modification of E/R schemas as well as of the other database objects, e.g. views, stored procedures and triggers and automatically creates specific SQL code optimized for each database type.
A further advantage is that database schemas can be modified without adjusting applications beforehand thus saving a lot of time. Thanks to the benefits of relational programming In.de automatically propagates modifications to all applications using the modified objects without any manual interference from the developer.
You can learn more on the database management module functions or download the free Express version and try creating your own databases and applications.
|