Use SGBDs, MySQL libraries, etc.

This guide covers the database management features available on Infomaniak servers.

MySQL, SQLite, MariaDB, PostgreSQL...

At the level Basic Data Management System, Infomaniak servers support...

... MySQL databases via PHP MySQL access or via Perl DBI+DBD::mysql
- You can use MySQL as a database management system (DBMS) on Infomaniak servers.
- You can access it either via PHP using the MySQL database functions built into PHP or via Perl using the DBI and DBD modules::mysql
... MySQLI, the native MySQL access interface (PHP5)
- MySQLI is an extension of PHP that allows access to a MySQL database.
- This is an improved and more recent version of the old MySQL extension of PHP, offering enhanced functionality and performance.
... SQLite 3.x
- SQLite is a lightweight, stand-alone, server-free SQL database engine.
- Infomaniak servers support SQLite version 3.x, which means you can use SQLite to store data on these servers.
... MariaDB
- MariaDB is a fork from MySQL and is often used as an alternative to MySQL
- So you can use MariaDB as a database management system on Infomaniak servers
... the PGSQL module
- PGSQL is a PHP module that connects to a PostgreSQL database
- This specific feature allows you to connect to a PostgreSQL DISTANTE database via PHP; this requires opening the appropriate port to the precise IP of the PostgreSQL database from the Infomaniak manager.

Dba, dbm, db2, sqlite are not supported, SQL Server Nor (it is a database server that requires a Microsoft architecture).

Link to this FAQ:

Display all FAQs for this product