Required versions

• WINDEV or WEBDEV 2025.
• MariaDB client library (libmariadb.DLL file)
  • 32-bit client library to use the 32-bit Native MariaDB Connector (version 3.x.x to 10.x.x tested).
  • 64-bit client library to use the 64-bit Native MariaDB Connector (version 10.x.x tested).
• The LibMariaDB.DLL DLL must be:
  • On the development computer:
    • in the "\Programs\Framework\Win32x86" directory of the installation directory of WINDEV or WEBDEV (32-bit).
    • in the "\Programs\Framework\Win64x86" directory of the installation directory of WINDEV or WEBDEV (64-bit).
  • On the deployment computer, in the executable directory or in the Windows directory. For a deployment on a Web server, the DLL must be found in the directory of the Native Connector or in the Windows directory.

Using WLanguage commands in SQL queries

Limitations of MariaDB version 3.23x

• the Partial Fetch. The use of Partial Fetch with the SQL functions of WLanguage has the same effect as if no Partial Fetch was used.
• the Unions.

Managing large data files

• apply a filter (using HFilter) before starting a read operation (with HReadFirst/HReadLast, etc.).
• use queries whose selection conditions are selective enough.
• avoid performing searches.

INSERT queries and automatic identifier

Creating a table with HCreation

Support for Unicode

Connection with SSL certificates

1. Install a version of the MariaDB server that supports the SSL connections. For more details, see the MariaDB documentation.
2. Create the necessary certificates.
3. Establish a connection by using the following keywords in the advanced information of the connection:
   

   Keyword	Use
   SSL Key	Path of key file.
   SSL Cert	Path of certificate file.
   SSL CA	Path of certification authority file.
   SSL CAPath	Path of the directory containing the certificates of the recognized SLL certification authorities, in PEM format.
   SSL Cipher	List of authorized ciphers.

MyConnection is Connection
// Describe the connection
MyConnection.User = "root"
MyConnection.Password = "secret"
MyConnection.Server = "mariadbserver.domain.fr"
MyConnection.Database = "CRM"
MyConnection.Provider = hNativeAccessMariaDB
MyConnection.Access = hOReadWrite
// Describe the extended information for an SSL connection
MyConnection.ExtendedInfo = [
SSL KEY = E:\MySSLCertificates\mariadb.key;
SSL CERT = E:\MySSLCertificates\mariadb_cert.pem;
SSL CA = E:\MySSLCertificates\ca-cert.pem;
SSL CAPATH = E:\MySSLCertificates\CA\
]
// Open the connection
HOpenConnection(MyConnection)

Locking records

Identical records

Transactions

SET or ENUM items

xBlob items

• the BLOB items are imported as binary memo items.
• the LONGTEXT items are imported as text memo items.

Array items

Using INSERT/UPDATE queries to insert text into a LONGBLOB item (binary memo) on MariaDB

• if the connection is in ANSI format, the inserted text value is in ANSI format.
• if the connection is in UTF8 format, the inserted text value is in UTF8 format; in this case, a compatibility problem may occur.

• force the use of an ANSI connection by using the following parameter: "WD Unicode Support = 0" in the extended information of the connection (HDescribeConnection or HOpenConnection functions). For more details, see Programming a MariaDB database with the HFSQL functions.
• change the type of the item from LONGBLOB to LONGTEXT on the MariaDB database.

Partial indexing of memos and full-text indexing

• when importing MariaDB tables into the analysis.
• when HCreation is used.