BLOGS

4D V11 SQL

Data Client

in
4D Client is optimized to reduce network traffic. As of 4D v11 SQL, only modified data is sent across the network.

SQL Server

in
Query any SQL database via a native ODBC Driver using 4D's integrated SQL server.

Web Services Client

in
Easily call on Web Services using 4D as a Web Services Client.

Query by Formula - Standalone

in
Speed improvements in Query By Formula under 4D v11 SQL.

 

In 4D 2004, a formula is calculated for each record sequentially. 4D v11 SQL analyzes formulas beforehand to optimize queries. The syntactic analyzer can identify parts of the formula that can be optimized to reduce the sequential parts of the query.

 

4D Server v11 SQL Scalability test

in
How many simultaneous, active clients can 4D Server handle? This laboratory scalability test examines the limits of a real application on 4D Server v11 SQL.

 

Since the recent announcements about scalability in 4D v11 SQL Release 3, especially in regards to those helped by improved management of multi-processor operations, many people have had questions about the number of simultaneous clients that can connect to 4D Server.

 

Resource Explorer

in
Manage your image and text resources for localization. Add, and distribute your resources to all your clients - live - without restarting the server.

The resource explorer allows you to manage from any node - client or server - resources whose implementation previously required the application be stopped. Whether they're files from your image library or, for example, XLIFF files for localization, you can simply manage all of your resources by dragging and dropping them on the resource explorer.

  

Index Explorer

in
View every index in your application at a glance.

Instantly view all indexes for maximum productivity
This explorer lets you see all your database indexes in one display. This is a useful maintenance tool that will help you increase your database performances and get the best from 4D.

 

Index List

 

Structure Editor

in
Analyze, model and design the structure of your database thanks to a high-level graphic interface.

Design and model the architecture of your database with ease using the 4D Structure Editor.

 

Structure Editor

 

Just one click
With just one mouse click and the Properties inspector, you can add tables, fields, relations, and change settings on the fly.

Integrated Database

in
A powerful relational database is fully integrated into 4D.

4D provides a true enterprise-class database, with the capacity to process massive databases while keeping the same responsiveness and performance you've come to expect in 4D. We've shattered all previous database size limits to give both new and existing databases much more breathing room.


It is up to the challenge of even the most demanding projects.
 

Bigger Size

Our expanded capacity lets you serve ever-increasing data storage requirements without a problem.

 

SQL Client

in
Integrate the power of SQL with 4D's application building tools. The SQL Client lets you have the best of both worlds in a client application.

Take advantage of the SQL engine
The native SQL engine in 4D allows developers to implement industry-standard SQL within their 4D applications. Learning the 4D language is no longer a requirement to building an application with 4D.


Manage all of your databases
4D natively supports all SQL 92 standards. This allows you to work with both database records (DDL) as well as the structure (DML).