Tuto WEBDEV 25

Part 2: My first database 69 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), on networks of any size and type, and it automatically manages hundreds of concurrent accesses. HFSQL is available in Classic version and in Client/Server version. HFSQL can be freely distributed with your WEBDEV sites. 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 WEBDEV, 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). For any question regarding the Native Connectors, contact our sales department! The WLanguage SQL* and HRead* functions can be used with this type of access. The code is portable and independent of the database.