Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Using DBMS, MySQL libraries, etc.
This guide covers the database management features available with Infomaniak hosting.
Discover also the high-availability managed database solution (DBaaS) hosted in Switzerland, allowing you to easily deploy performant and secure clusters (MySQL, MariaDB, PostgreSQL) without having to manage the underlying infrastructure.
MySQL, SQLite, MariaDB, PostgreSQL…
At the Database Management System, the hosting supports…
- … 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, or via Perl using the DBI and DBD::mysql modules
- … 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 improved features and performance.
- … SQLite 3.x
- SQLite is a lightweight, standalone, and serverless 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 of MySQL and is often used as an alternative to MySQL
- You can therefore use MariaDB as a database management system on Infomaniak servers
- … 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 specific IP of the PostgreSQL database from the Infomaniak manager.
Dba, dbm, db2, sqlite are not supported, SQL Server either (it is a database server that requires a Microsoft architecture).
Link to this FAQ: