RemObjects Data Abstract for Delphi v6.0.39.777 FullSource

Build scalable multi-tier database solutions. RemObjects Data Abstract for Delphi is an RAD tool for writing multi-tier solutions in Delphi. RemObjects Data Abstract allows you to create services that access any database, by providing a clear separation between data-access and business-logic. Data Abstract for Delphi will enable your applications to interface with different database systems, even simultaneously, instead of depending from any single one. RemObjects Data Abstract for Delphi supports a wide range of database back-ends, including Microsoft SQL Server, Oracle, DB2, Interbase/Firebird, Sybase, PostgreSQL, MySQL, SQLite, NexusDB, Paradox and many more.

What's New in Data Abstract 6?

New JSON data streamer for both platforms, that - working together with the JSON message in RO will make it easy to access Data Abstract servers from javascript.
Improved the IDE experience for DA LINQ, with new menus and a custom tool in Visual Studio to generate code.
New LoginEx method in the standard login services will provide new flexibility in implementing authentication where more parameters are needed.
New DA SQL Browser tool is provided in DA/.NET to explore and query DA SQL based servers.
What's New in Data Abstract for Delphi 5?

Features in all editions of Data Abstract

New AnyDac driver
AutoSQL lets Data Abstract generate SELECT statements on the fly, when needed
Dynamic Select allows clients to retrieve subsets of fields, optimizes network traffic and reduces client side memory load
Reduced Deltas feature for reducing network bandwidth when applying updates to tables with many fields or large blobs
Dynamic Where allows clients to supply custom conditions for filtering data server-side, and apply those securely without risk of SQL injection attacks
New Connection Types provide more flexibility for matching up statements in multi-database scenarios
New expandable Reconcile Dialog architecture to easily provide end-users with feedback about failed updates
Transparent support for Data Table Unions to publish combined data from multiple data tables as a single entity
New Bin2DataStreamer for improved and more efficient streaming of data between client and servers
Native support has been added for new XML, GUID and Decimal data types.
New driver support is being provided for the open source SQLite embedded database
Support for versioning of schema files.
New Welcome Page displayed after the first install to assist new users with getting acquainted with the product.
Features specific to Data Abstract for Delphi

Data Abstract for Delphi now supports Free Pascal, allowing you to compile your applications for 64-bit Windows and the Linux platform
Easier setup of client-side Master/Detail relationships based on Dynamic Where
All new TDAMemDataTable component for client-side data storage, providing much more efficient and streamlined data access.
New TDARemoteCommand component for easier execution of published database commands from the client.
New Borland Database Engine (BDE) Driver for access to legacy database systems and easer migration from desktop databases such as DBase and Paradox to multi-tier.
New cross platform ZEOS driver to access a variety of database systems from both Delphi and Free Pascal projects.
NexusDB drier

RemObjects Data Abstract for Delphi is a RAD multi-tier solution that allows you to easily build distributed applications accessing different databases, providing a clear separation between data-access and business-logic.

RemObjects Data Abstract Core Features

Build scalable multi-tier cross platform database applications.
Target different database back-ends using a common code base
Use Schema Modeler to design the interface of your data
Leverage the new wizards and IDE enhancements to build DA applications even easier than with previous versions
Support for a wide range of database back-ends, including Microsoft SQL Server, Oracle, DB2, Interbase/Firebird, Sybase, PostgreSQL, MySQL, SQLite, NexusDB and many more
RemObjects Data Abstract for Delphi Features

Complete abstraction of different databases: use the same code for Microsoft SQL Server, InterBase, Oracle, MySQL, DBISAM, DB/2, etc.
Build your applications with a "stateless" focus for maximum scalability and seamless cluster integration
Stream data all at once, on demand, paged or any combination of those
Re-synch fields automatically with the remote data source
Use update rules to design complex update sequences without a single line of code
Enhanced Business Processors give you more control on your business updates
Cross-database autoincrement and generator-based field support
Work with either auto-generated SQL or proprietary dialects, whenever higher performance or access to RDBMS specific features is required
Full support for stateless Master/Detail transactional updates
Update Rules: create complex update sequences without a single line of code
Design your data-access layer in an innovative RAD way using the Schema Modeler
Minimize SQL dialect differences using Data Abstract's macro processor
Easily create your own data access driver to extend the list that comes with the product
Support for regular expressions for client-side data-validation
No deployment license costs
Supported Database Systems

Database systems supported by Data Abstract include:

Microsoft SQL Server
Microsoft SQL Server Compact Edition
Oracle
DB2
InterBase/Firebird
Sybase
PostgreSQL
MySQL
New: SQLite
NexusDB
New: Borland Database Engine for dBase, Paradox, etc.
Supported Third Party Data Access Components in Data Abstract for Delphi

dbGo (ADO Express)
DBX
DBX4 (Delphi 2007 and up)
IBX
SDAC, ODAC, MyDAC and IBDAC by CoreLabs*
MySQLDAC and PostresDAC by microOLAP*
IBObjects*
DBISAM*
New: ZEOS