Skip to main content

Set Up Custom Database

  1. In the ezsite, enter your project and click the Settings button in the top right corner.
  2. Click the Database tab.
  3. In the Database Type section, you can select Custom DB, and then select the database type from the dropdown menu. Support MySQL, PostgreSQL, SQL Server and Oracle.

set custom db

  1. You can configure the custom database connection string.
  • Here's an PostgreSQL example:
Server=yourPGDBServer;Port=5432;Database=yourDBName;User Id=yourUserName;Password=yourPassword;MaxPoolSize=100;
  • Here's an MySQL example:
Server=yourMySQLDBServer;Port=3306;Database=yourDBName;User Id=yourUserName;Password=yourPassword;MaxPoolSize=100;
  • Here's an SQL Server example:
Server=yourSQLServerDBServer,1433;Database=yourDBName;User Id=yourUserName;Password=yourPassword;TrustServerCertificate=true
  • Here's an Oracle example:
Server=yourOracleDBServer;Port=1521;Database=yourDBName;User Id=yourUserName;Password=yourPassword;MaxPoolSize=100;

Use Custom Database​

After setting up the custom database, you can use it in the project. Suppose you have a game project and you want to save the game results to a database, you can use the following prompt:

Save game results to the database

IP Whitelist

For the complete list of IP addresses that can access your custom database, please refer to our IP Whitelist documentation.