08-02-2013
|
|
Miguel A. Valero
|
|
Registrado: feb 2007
Ubicación: Bogotá - Colombia
Posts: 1.346
Reputación: 20
|
|
Una poco más de la noticia que da mas respuestas a la pregunta inicial del hilo.
Cita:
Empezado por Andreano Lanusse
The reason I say that it’s because AnyDAC really allows developers to target multiples database without the workarounds required by dbExpress, like: Field Mapping when you persist the TFields. For long time AnyDAC allowed developers that use Delphi/C++Builder Professional edition to connect their application to Enterprise databases like Oracle, SQL Server, Sybase, Informix and others, something that was only possible through Enterprise and Architect edition, and much more.
|
Y enumera algunas características por motor:
Cita:
Empezado por Andreano Lanusse
Beyond that, there is a lot of specific database features supported by AnyDAC, which I consider very helpful in any database development, here some examples per database: - For all databases
Automatic Connection Recovery
Unified DB Events Support
Simplified architecture, it means no more Query + ClientDataSet + Provider just for a bi-directional cursor
Much better performance when compared with dbExpress
TADMemTable – in memory dataset, faster than TClientDataSet
Much easier to migrate BDE applications to AnyDAC than the traditional dbExpress architecture
- Oracle
SELECT FOR UPDATE clause – no more workaround doing UPDATE just to lock the record
Query execution aborting – we always need that right?
ROWID columns for fast data editing and refreshing
RETURNING clause for fast data refreshing – no more select after the update to get a new value generated by trigger
and more…
- Firebird
RETURNING clause for fast data refreshing
Trusted authentication
DB services – backup, restore, validate, security, etc
Query execution aborting
- PostgreSQL
Yep, now you can connect natively with PostgreSQL
and more…
- SQL Server
Batch commands with multiple result sets – Now you can use that and improve your app performance
Query execution aborting
and more…
- MySQL
AUTO_INCREMENT columns and retrieving of last inserted value.
Drivers for several databases on Windows, Mac and iOS
|
|