Overview
4D Products
4D Maintenance
Features
Getting Started with 4D
Resources
Discover what’s new in 4D v11 SQL Release 3 (11.3). For more details, consult the 4D v11 SQL Addendum 11.3 on the documentation page.
For a full review of what's new in the 4D v11 SQL product line, please visit our brochures page for "4D v11 SQL: Breaking the Limits" and "4D Server v11 SQL: Beyond the Limits," which you may download or read online.
4D v11 SQL Release 3 allows you to take advantage of the latest and greatest hardware, with new parallelization algorithms that utilise every processor core on your machine. Your code will simply execute much faster. From dual core machines to those with dozens of processors, 4D lets your hardware live up to its full potential, and gives your applications the ability to scale according to the number of users and their needs.
Communications between 4D databases using SOAP-based Web Services have been optimized, thanks to specific new compression algorithms that greatly accelerate data exchange. New parameters allow you to activate or deactivate the compression programmatically.
Reduce your dependence on ODBC. 4D v11 SQL Release 3 (v11.3) allows a 4D application to connect to and exchange data with another 4D database via SQL directly. In prior versions, such operations passed through the ODBC protocol. By making direct SQL connections, the exchanges are three to ten times faster.
*4D Standalone can be used as a SQL server in two cases: For development purposes under 4D Developer Professional with 1 local + 1 external IP connection, and for deployment purposes under 4D OEM Desktop with SQL Server option. To see detailed licensing options, please visit the product comparison page.
4D v11 SQL's integrated SQL engine now supports schemas, allowing more granular control over access rights for all remote SQL access. Schemas are created, modified, and deleted via SQL commands. (Also available: A new 4D Pop component that facilitates schema management.)
A schema is a virtual object that contains one or more database tables. They assign access rights (no access, read only, read/write) to each object independently, dividing the phiysical data structure into distinct entities.
Programmatic error management has been simplified, using a single command - GET LAST ERROR STACK - to get all information about errors intercepted from the 4D engine. Called from within error-handling methods, it can be used to process all types of errors, regardless of context.
Migrating to 4D v11 SQL just got easier. The mechanism for converting 4D databases from version 2004 to v11 has been modified, facilitating successive conversions of the same structure file.
This new feature applies in the case, for example, of a 4D 2004 structure and its data initially being converted, then continued to be modified and converted, all the while with the v11 application being used since its first conversion. The data file can be read with each updated version of the structure file.
4D v11 SQL Release 3 is certified for Windows Server 2008.
4D for OCI is now fully compatible with Intel-based Macs.
New 4D SVG Component 4D v11 SQL Release 3 (11.3) now includes 4D SVG, a component facilitating the use of 4D's integrated SVG rendering engine.
