Authentication via Active Directory Kerberos is an authentication mode based on the use of tickets and secret keys... Automatic data masking Data masking is a process that transforms the data in an item that will be displayed to the user... Client/Server: Connecting client computers to the server In order for the application to be able to handle the data files found on the HFSQL server, the connection that will be used by the application must be defined in the project... Converting an HFSQL Classic database into HFSQL Client/Server There are two methods to convert HFSQL Classic databases to HFSQL Client/Server in WINDEV, WEBDEV and WINDEV Mobile... Differences and specific features of an HFSQL Client/Server application The management mode of data files may have to be adapted when using an HFSQL Client/Server application... Docker image of the HFSQL server A Docker container with the HFSQL server is available on Docker Hub... HClient structure The HClient structure is used to... HFConf.Ini file The HFConf.INI file is found at server root. This file is used to define several characteristics of HFSQL Client/Server server. HFSQL and Docker Docker is a software platform that allows you to run applications in software containers on Linux (Docker runs like a daemon)... HFSQL Client/Server: Backing up databases Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis... HFSQL Client/Server database: Recommendations This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features... HFSQL Client/Server: Overview You have the ability to create applications that access the HFSQL Client/Server databases... HFSQL Client/Server: Port management The ports used by the HFSQL Client/Server server... HFSQL Client/Server: Scheduled tasks The scheduled tasks are used to schedule automatic tasks... HFSQL Client/Server: Setting up data files on the server HFSQL Client/Server: Setting up the server How to backup HFSQL Client/Server databases? The backup of the HFSQL Client/Server databases can be performed... Keep-alive on connection A connection to the database can be interrupted at any time at "hardware" level... Managing rights on HFSQL Client/Server To ensure data security and confidentiality, some actions may be restricted to a group of users... Managing the groups and users (HFSQL Client/Server) To simplify the management of users and groups of users, the HFSQL Client/Server engine uses several variables allowing you to easily define the characteristics of groups and users... Managing the load balancing (dynamic load balancing on server) The server that is hosting a HFSQL database engine can be very busy... Materialized view A materialized view is a physical data source defined by an SQL query. Notifications of an HFSQL server A server may encounter problems without any user (or developer) noticing anything. For example: a scheduled task may fail, an automatic backup may fail, a node may become inactive in an HFSQL cluster, ... Operating mode of HFSQL application An HFSQL application can operate in network mode or in Client/Server mode... Optimizing the connection times to the HFSQL Client/Server databases This help page explains how to optimize the connection times to the HFSQL Client/Server databases by limiting the network traffic... Optional connection information When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information... Pattern compression (ADSL, 3G, Edge, VPN, etc.) A frame is a packet ot data that flows through the network... Restoring an HFSQL Client/Server database A backup of an HFSQL Client/Server database can be restored at any time... Spare server A "spare" server is a target server in a unidirectional automatic replication... SQL view An SQL view is a virtual data source defined by an SQL query... Stored procedures and queries (HFSQL Client/Server) The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code...