Database Extensions Suite provides following additional functionality:

• Persistent Database Schema. Database Schema contains the description of tables, relations between them as well as triggers and SQL statements that could be used to update a database to the version required by the current version of application. Database Schema may be stored within application or in the database (System tables) or as an external file.
• RI Constraints. Relations between tables, defined within database schema, allows to implement various types of referential integrity (RI) constrains (Error, Cascade and Nullify for delete & update operations). Please, note, that processing of RI constraints might sometimes considerably slow down some delete and update operations.
• Replications. All changes made to records can be automatically written into a separate table ("Objects" tables) and used for database replications. TxxDatabaseExt provides methods, that could be used to create & synchronize snapshots with the main database.
• Additional events and properties provided for database, table and query components.

Database Extensions Suite comes with Context Database Designer (included in the license price), which is used as a component editor for TDatabaseSchema component, which allows to draw great looking diagrams, manage schema versions (Version Control feature), automatically produce update SQL DDL scripts for various database engines and more.
 
Trial (work while IDE is running)
Source: On purchase/registration
Price: $129

DObject O/R Mapping suite supports a variety of databases and transparent to users and needn't to alter code when switching to different database. At the same time, DObject O/R Mapping provides XObject XML, a database engine with high performance.

DObject O/R Mapping suite allows you to access database completely in the mode of object-oriented. It includes OQL.Delphi, which is a strong-typed OQL (Object Query Language) based on native Delphi language, even you needn't to write a single line of SQL statement based on string.

DObject O/R Mapping suite can help reduce 30%~40% of codes and 90% of time to debug query statements, shorten 50% of development time. To a large extent, cut down the costs of development and maintenance and improve the system's robustness.

DObject O/R Mapping suite is only used in the development with Win32. If you want to use with Delphi.NET, please choose Macrobject NObject O/R Mapping framework.

DObject includes CodeAuto, which can be used to generate DObject persistence layer. Macrobject CodeAuto is a code generator that is template-based and can generate different types of text files accordingly from database schema, data, XML and other data source.

Features:

• Object-Relation Mapping
• Accessing database in the manner of object-oriented
• Related Object/ObjectSet lazy-load
• Supports field/property lazy-load
• Supports transaction processing and object state rollback
• Object-set cache can maximally improve the performance
• Supports a Variety of Databases
• Migrate to another database without altering code
• Migrate to another database without recompile
• XObject XML Database
• High performance
• Switch to other database without changing code
• Supports object query language
• Object Query Language (OQL) Based on Native Delphi Language
• Based on native language but not string
• Context tips (CodeInsight) during editing
• Syntax check while compiling
• More readable and maintainable
• Convenient and Easy-to-use Object-Filter
• Be used for database's query, update and delete operations
• Be used for object-sets' select, update and delete operations
• More simple to query and select objects
• More simple to update and delete objects in batches
• Powerful ObjectSet
• Multiple sort modes, including OQL
• Multiple filter modes, including OQL and object-filter
• Multiple update modes, including OQL and object-filter
• Export to XObject XML database
• Import from XObject XML database

This package gives you the following advantages:

• The filtration and search for the required data can be of any level of difficulty.
• Optimization of search taking into account a current index.
• Support of BDE, ADO, dbExpress, InterBase Express, etc.
• Development of VCL and CLX applications.
• A broad set of visual components designed for data input by an end-user for the search and filtration of data.
• Simple integration with any other visual components designed for data input.
• Simple integration with any dataset components developed by other producers.

Features:

• Query and filter builder, user-defined queries, auto substitution of a dataset and vice versa.
• Sorting of datasets, including SQL datasets (such as TQuery).
• Search for records by sorting fields, including SQL datasets.
• Multi-function popup menus for design- and run-time.
• Editing data in design-time.
• Controls for db fields and User controls substitution into the pack.
• Automatic opening/refreshing datasets in run-time.
• Records cloning.

InfoPower Studio 2006 is the most popular and useful component suite for building database front-ends for Delphi and C++ Builder.

InfoPower's masterpiece grid is one of the most powerful components in the InfoPower library, supporting master-detail relationships, embedded controls, lookups, images, formatted text, etc. Also included is a flexible transposed grid to display your rows across columns instead of rows.

Also included are filtering dialogs, advanced lookupcombos, the most capable RTF editor, transparent controls, and the most powerful validation language for validating and assisting your user during data entry.

Delphi Informant says, "If I could only have one component suite for Delphi, it would be InfoPower. It will reduce the amount of code you have to write, and provide your users with a much more attractive, powerful, and functional user interface than any you could create using the standard Delphi components alone. InfoPower continues to be the must-have add-in for Delphi developers."
 
Trial (work while IDE is running)
Source: None
Price: $599