Database updates in RAD Studio XE8
With RAD Studio XE8 there have been a number of database updates to expand connectivity, and improve and introduce functionality for us programmers.
FireDAC & IBX support for Change Views
FireDAC has introduced new support for Change Views – enabling rapid identification of what has changed on the server side data and updating of client side stored data. See this <2min video for how these work.
Source code for the example ships in the samples directory:
<Samples><language>Database\FireDAC\Samples\DBMS Specific\InterBase\ChangeView
IBX has also introduced new components to make it easier to work with change views and subscriptions.
New Platform – Teradata
FireDAC now includes support for Teradata, using the driver name TData.
An example of how to set the driver properties is shown on the docwiki help for connecting to Teradata with Delphi.
DriverID=TData Server=192.168.43.140 Database=MyDatabase User_Name=dbc Password=dbc
TDataSet TField speed up.
Marco Cantu mentioned on the Launch webinar Q&A a customer was claiming seen a speed up of around 25% on a TClientDataSet application due to the refactoring at the base of how TField is used at the core layer. 🙂 This is really cool for both VCL and also FMX developers.
64bit support for iOS
With the new platform for iOS 64bit, the database layer is also seamlessly available, just recompile and run 🙂
Other updates
There are updates for EMS including push notification. EMS is a great way to access central data from mobile devices. EMS now is updated to include InterBase XE7 for both the server and ToGo side, allowing you to use Change Views on both Server and Clients.
Where FireDAC uses SQLite, it has been updated to a newer driver.
For more of whats new in RAD Studio XE8, including EMS updates, please click here Whats new in Delphi XE8 and C++ Builder XE8
3 cheers for TClientDataSet / TField speed increase – a compelling reason to upgrade to Delphi XE8 for those with database heavy projects.