Mertech is pleased to announce the availability of the next version of our Flex2SQL product, v14, as a Release Candidate.
This release candidate contains many enhancements that will improve the flexibility and productivity of DataFlex developers when using the Mertech drivers.
New features include:
- Improved API for LOB access: For BLOB and CLOB access, many new commands have been added to the API, and the size limitation for chunking has been increased to 16MB (previously 16kb), which enables developers to load larger binary files at an improved level of performance.
- Compatibility with DataFlex 18.0’s DD SQL Filter feature: This feature allows developers to optimize data-aware grid populations by having “constraints” executed on the server rather than being filtered on the client side, an approach that significantly reduces network traffic, reduces the load on the server and increases the speed of filling grids that may use very complex filtering.
- Support for DataFlex 18.0’s native type editing feature: This feature allows DataFlex developers to use the Studio Table Editor to set the native backend data type of table columns instead of being limited to using only the column mappings from DataFlex types to native types. For example, the Mertech driver natively supports GUID column types for some backends. Using the Studio Table Editor in DataFlex 18.0 with Flex2SQL v14 will enable developers to set a column type in the database to GUID even though DataFlex doesn’t have a native GUID type.
- Support for MS SQL Server 2014, which provides options for deploying database solutions in the cloud with Windows Azure & new in-memory transaction processing capabilities.
- Support for MYSQL 5.7, which has improved its ability to work with 64-core servers.
- Support for PostgreSQL 9.4, which includes many improvements such as better JSON functionality and writable external data.
Download a free trial of Flex2SQL