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

MySQL, SQLite, MariaDB, PostgreSQL…

At the level of Database Management System, Infomaniak servers support…

1. … 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 built-in MySQL database functions of PHP, or via Perl using the DBI and DBD::mysql modules
2. … MySQLI, the native MySQL access interface (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 of PHP, offering enhanced features and performance.
3. … SQLite 3.x
   • SQLite is a lightweight, self-contained, 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 a 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 feature allows you to connect to a REMOTE PostgreSQL database via PHP; this requires opening the appropriate port to the precise IP of the PostgreSQL database from the Infomaniak manager.