Tuto WINDEV 25

Part 3: My first database 93 HFSQL HFSQL is a database that is very powerful, very fast and very reliable. HFSQL operates in Windows and Linux, on mobile devices (iOS, Android, Windows CE, Windows 10), on networks of any size and type, and it automatically manages hundreds of concurrent accesses. HFSQL can be freely distributed with your WINDEV applications. HFSQL proposes all database features, especially: • the log process, • the transactions, • the replication, • the triggers. See the online help for more details about implementing these features. In the different sections of this tutorial, we will be using a HFSQL Classic database then a HFSQL Client/Server database. The different modes for accessing the databases Native Connector (Native Access) A Native Connector is using a database format directly and exclusively. This optimized type of access is developed specifically for each database format. In WINDEV, a Native Connector is available for the following databases: • HFSQL Classic or Client/Server (standard). • xBase (standard). • Access (standard). • XML (standard). • SQLite (standard). • Oracle (optional). • AS/400 (optional). • SQL Server (optional). • Sybase (optional). • Informix (optional). • DB2 (optional). • Progress (optional). • MySQL (optional and free). • PostgreSQL (optional and free). • MariaDB (optional and free). • SQL Azure (optional and free). Other Native Connectors will be available soon, contact our sales department for more details! The WLanguage SQL* and HRead* functions can be used with this type of access. The code is portable and independent of the database.