Context Database Extensions
Delphi component library with many usefull database-related components.
Download Trial
Buy Now
Version History

Why do we need extensions?

Here, at Contexts Software, we've been developing all sorts of database applications since the beginning of Delphi days, and while VCL may be regarded as one of the best database components library, since its conception it was lacking in several important areas.

These and lots of other issues prompted us to write our components, in most cases extending and commonizing (via the use of Interfaces) existing database access libraries.

After more than 10 years of development we are happy to present you with the set of components that addresses all of the above issues and more.

What's inside the package?

  • TDatabaseSchema - persistent storage for database schema definitions, including tables, indexes, RI constraints, triggers and incremental database version updates. It can be imported from DSD file produced by our Context Database Designer.
  • TDBSequence - implements generic sequences, that could be used as unque key generators (similar to Oracle's sequences). It is database independant and uses external SequenceTable (which could be any TDataSet descendant) to access a table, where each sequence must have a corresponding field.
  • TDBRecord - a simple TDataSet descendant, that represents a dataset with only one record of data. This component is usefull when implementing forms, using only data-aware controls.
  • TDBEnumeration, TDBSchemaEnum - enumerations are very much like enumerations defined in Pascal or C. Enumerations are very helpful, when you need to specify a set of limited choices (Order Statuses, User Types, etc.). Enumerations defined within database schema may be exposed using TDBEnumeration component, derived from TDataSet, allowing to produce simple lookup fields, that will display the full name or description of each value.
  • TDBEngineProfile - contains definitions for a particular type of database (e.g. MySQL, MS SQL, Oracle, Firebird, etc.), and allow to produce and reverse engineer database-specific SQL scripts. Many profiles come with our Context Database Designer product.
  • TCtxDataContainer - contains in-memory data tables, which could have PK, NOT NULL and RI constraints defined. Allows to work on a consistent snapshot of information (say, database object, like "Invoice") on a client side and then save it to the database (or disk file) all at once.
  • TCtxDataSet - TDataSet-descendand that works like a cursor on an in-memory data table contained in TCtxDataContainer. It could also work as a memory table on its own, without a container.
  • TCtxDBAdapter - stores SQL commands (typically CRUD) required to load, refresh and save data from and to the database connection. Uses data provider component, which could be any component, implementing ICtxDataProvider interface. This allows to isolate SQL from programming code.
  • TADOConnectionExt - a replacement for the standard TADOConnection component. It is extended to implement functionality required to support schema operations and cached updates. As all database access components implements ICtxDataProvider interface, which is required to execute commands, stored in TCtxDBAdapter. Additional adapters pack contains replacements of many other database access components (see below).
  • TCtxDataSetProvider - a basic implementation of ICtxDataProvider interface that adapts any TDataSet-descendand and could be used to fill TCtxDataContainer from any dataset.
  • Supported database access libraries

    As of right now it supports and extends the following database access libraries:

    However, even if you're not using any of the above libraries, you could still benefit from the advanced set of components and features that Context Database Extensions provides. You may also implement (or ask us to do so) our interfaces for the database access library of your choice and get access to the functionality that, we believe, required by most database applications.

    Pricing

    ItemPriceBuy Now
    Context Database Extensions Suite v.3
    Context Database Extensions Suite & Database Designer v.3 (upgrade from Context Database Designer v.3)$49
    Context Database Extensions Suite & Database Designer v.3 (upgrade from v.2)$69
    Context Database Extensions Suite & Database Designer v.3 (upgrade from v.1)$79
    Context Database Extensions Suite & Database Designer v.3 (upgrade from Context Database Designer v.2)$99
    Context Database Extensions Suite & Database Designer v.3$199 

    Downloads

    DescriptionFile sizeDownload
    Context Database Extensions Suite v.3
    Context Database Extensions Suite 3.42 (TRIAL VERSION)7.4 MbDownload
    Context Database Designer 3.42 (TRIAL VERSION) 3.1 MbDownload
    Context Database Extensions Suite 3.427.7 MbDownload
    Context Database Designer 3.423.1 MbDownload
    Additional Database Extensions Adapters Pack 3.42761.6 KbDownload
    Context Database Extensions Suite v.2
    Context Database Designer 2.153.3 MbDownload
    Context Database Extensions Suite 2.152.9 MbDownload
    Additional Database Extensions Adapters Pack 2.151.0 MbDownload
    Context Database Extensions Suite v.1
    Context Database Extensions Suite 1.7087.9 KbDownload