[[movorack]]

Una poco más de la noticia que da mas respuestas a la pregunta inicial del hilo.

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:

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