• To decode: set digits, decimals, signed and call LoadFromByteArray or LoadFromStream. Access data decoded from AsDouble or AsString.
• To encode: set digits, decimals, signed and AsDouble. After that, call SaveToByteArray or SaveToStream to encode.

These components allow you to compare and synchronize SQL database objects and table records for many popular databases. You can view all the differences between databases and execute an automatically generated script to eliminate all or selected only differences.

The library includes more than 25 components for Database development and its code is constantly being refined and improved.

Features at a glance:

• Compare two databases, database and SQL/DDL script, two SQL/DDL scripts
• Synchronize data between two database tables
• Extract database structure
• Compare specific database objects or entire databases
• Royalty free licensing. Free Unlimited Email support
• Fully-indexed help documentation. Delphi and C++Builder demos code.

Most popular database libraries such as ADO, BDE, InterBase Express, FIBPlus, IBObjects and ZeosLib supported directly. MyDAC, ODAC and AnyDAC are also supported.
 
Trial (work while IDE is running)
Source: On purchase/registration
Price: $282
Source Price: $282

Realised functions: ALLTRIM, RTRIM, LTRIM, SPACE, FLEFT, FRIGHT, YEAR, DTOC, PADR, PADL, PADC, AT, LEN, STR, SUBSTR, TRIM, REPLICATE, EMPTY.
 
Fully functional
Source: Included

The classic way to fecth a generator value from a IB server is to define a stored procedure on the server and fetch the value by executing a IBStoredProc on the client.

This has 2 disadvantages:

• For every generator a stored procedure must be defined on the server.
• IBStoredproc needs a lot of resources on the client.

• TSchemaDesignArea - visual design pane to draw the model
• TSQLBuilderDialog - Visual Query Builder to construct the SQL-statement
• TSchemaCustomDataEngine, TSchemaBDEDataEngine - Custom engines for databases allow to use any data source (BDE, ADO, dbExpress, memory etc)

In this case you can do migration of your application very fast to other RDBMS.
 
Fully functional
Source: On purchase/registration
Source Price: $10
Exe-Demo Included

The package contain two components TSnapVirtualDataset and TSnapObjectDataset and one editor for use of this components in a true RAD way. These components are completely free with source and demos, and with the editor you can create automatically for every properties of your business classes the associated TField descendent.
 
Fully functional
Source: Included
Exe-Demo Included

It provides an Open Source self-sufficient set of units (even Delphi starter edition is enough) for creating any application, up to the most complex Domain-Driven design:

• Presentation layer featuring MVC UI generation with i18n and reporting for rich Delphi clients, or rich AJAX clients;
• Application layer implementing Service Oriented Architecture via interface-based services (like WCF) and Client-Server ORM - following a RESTful model using JSON over several communication protocols (including HTTP/1.1);
• Domain Model layer handling all the needed business logic in plain Delphi objects, including high-level managed types like dynamic arrays or records for Value Objects, or dedicated classes for entities or aggregates;
• Data persistence infrastructure layer with ORM persistence over Oracle, MS SQL, OleDB, with a powerful SQLite3 kernel (direct link to DB);
• Cross-Cutting infrastructure layers for handling data filtering and validation, security, caching, logging and testing (framework uses test-driven approach).

• TjlDbXScript - Execute multiple statements in file or TStrings.
• TjlDbxMetaData - Metadata for tables and Stored procedures.