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

MySQL, SQLite, MariaDB, PostgreSQL…

At the Database Management System level, Infomaniak servers support:

1. MySQL databases via PHP MySQL access or via Perl DBI+DBD::mysql
   • You can use MySQL as the database management system (DBMS) on Infomaniak servers.
   • You can access it either through PHP using the built-in MySQL database functions in PHP or through Perl using the DBI and DBD::mysql modules.
2. MySQLI, the native access interface to MySQL (PHP5)
   • MySQLI is a PHP extension that allows access to a MySQL database.
   • It is an improved and more recent version of the old MySQL extension in PHP, offering enhanced features and performance.
3. SQLite 3.x
   • SQLite is a lightweight, standalone, serverless SQL database engine.
   • Infomaniak servers support SQLite version 3.x, which means you can use SQLite to store data on these servers.
4. MariaDB
   • MariaDB is a fork of MySQL and is often used as an alternative to MySQL.
   • You can therefore use MariaDB as the database management system on Infomaniak servers.
5. the PGSQL module
   • PGSQL is a PHP module that allows you to connect to a PostgreSQL database.
   • This specific functionality allows you to connect to a REMOTE PostgreSQL database via PHP; this requires opening the appropriate port to the specific IP of the PostgreSQL database from the Infomaniak manager.

‍