HFSQL

• Saving and restoring the data • Viewing the structure of the tables • Automate common functions • Monitoring • Managing users and groups of users, as well as their rights • Managing connected users • User disconnection • Server usage statistics: computers, queries, logs, parameters, … • Viewing row locks • Managing cluster nodes • Defining the settings for server replica- tions • Connecting and visualizing data from third-party databases (the native plugin must be installed) • Managing notifications returned by the HFSQL servers • Displaying server logs: most used queries, longest ones, most draining ones, etc. • Real time activity statistics: CPU, memory and network bandwidth consumption • ... TOOLS WDMAP: DATA VIEWER The WDMAP tool lets you view, edit and modify data in a table. WDMAP is very useful in the test and de- bugging phase. WDMAP is used to filter and sort data, perform immediate export (to Words, Excel, OpenOffice, XML, ...) WDHFDIFF: DATA COMPARISON TOOL The WDHFDiff tool lets you compare: • the structure of 2 tables • the data of 2 tables. This can be very useful in the implementa- tion step. MONITORING ROBOT The monitoring engine (which can be re- distributed with your applications) lets you secure your servers. The monitoring engine always monitors, and instantly detects new unauthorized connections with the server. The server notifies you by: • sending a configurable email message to the specified addresses (up to 20 ad- dresses) • message sent to a specific application (internal messaging,...) • message sent to the integrated messag- ing system • control screen (visual warning and/or sound) • starting a WLanguage procedure • third-party program (this program can for instance, send a configurable mes- sage via SMS to chosen numbers). Among the monitoring parameters that can be specified, you’ll find: • the frequency: test interval, from 2 min- utes to 1 day • repetition: in case there’s no answer from the monitored element, how often to retry and how long before triggering the warning • text of the message to send • the message’s medium (SMS, e-mail, …) HFSQL • www.windev.com 12 In this case, 2 users are trying to modify the same record at the same time! If the case is not supported by programming (locked row), a window automati- cally comes up and requests the value to use. USER ASSISTANCE FOR UNEXPECTED ERRORS In a WINDEV application, the assistance to the end user is automatically provided on HFSQL aspects in the case of the follow- ing errors: • detection of the non-protected concur- rent accesses • duplicates • non respect of the integrity constraints • wrong password • disconnection • lock. if one of these errors occurs, the applica- tion automatically displays a relevant help window.