Home | Sign in | English UK
  • This lesson will teach you the following concepts
  • The available databases
  • Overview
  • HFSQL database
  • The synchronization
  • Accessing data via a Webservice
Lesson 6.3. Databases
This lesson will teach you the following concepts
  • Available databases
  • Synchronization

Estimated time: 20 mn


Creating and generating a Universal Windows project is not available in Express version.

Previous LessonTable of contentsNext Lesson
The available databases


In the Universal Windows 10 applications, only the HFSQL database is accessible in native mode. Both the Classic mode and the Client/Server mode are available.

HFSQL database

HFSQL Classic
In HFSQL Classic mode, the data files are stored on the device.
In this case, the application is stand-alone. No Wi-Fi or 4G connection is required.
The data is stored in the device memory. The maximum storage size depends on the amount of memory on the device.
HFSQL Client/Server
In HFSQL Client/Server mode, no data is stored on the device. The data is stored on a computer on which a HFSQL server is installed.
To access this computer and this database, a method for communicating with the server must be enabled in the mobile application (Wi-Fi or 4G) in order to connect via the network or Internet.
The response times depend on the quality of the WiFi or Internet network and on the volume of requested data.
The access to the data will be performed by the Hxxx functions of WLanguage and/or by SQL queries.
The synchronization
The synchronization mechanism is used to "synchronize" the data stored on a mobile device with the data stored on a server. The synchronization uses the mechanism of "universal replication".
This technique is available in WINDEV, WEBDEV and WINDEV Mobile.
See Universal replication for more details.
Accessing data via a Webservice
Another method can also be used to access data on a server from a mobile device: the call to a WebService.
In this case, the mobile device must be equipped with a Wi-Fi or 3G connection to connect to the Webservice.
The mobile application does not directly access the database. The application calls the functions of the Webservice. These functions return the data.
It is the Webservice that accesses the database.
This technique is used to have a business layer (the Webservice) common to several types of applications and interfaces (WINDEV, WEBDEV or WINDEV Mobile) and different types of operating systems (Windows, Android, iOS, ...).
Previous LessonTable of contentsNext Lesson
Minimum version required
  • Version 24
Click [Add] to post a comment