🪄Once your server is ready, follow these steps to deploy and host your app🚀

NB: if you have not already, choose your plan to host your app for free we will send you the instructions

1) Host, Username, and Password

We will send you the following informations:

Host: XXX.datapage.app
Username: XXX
Password: your password

You can use these identifiers to connect to your SQLPage cloud server via SFTP.

2) How to Connect to the Server

It is an SFTP connection.
We recommend Filezilla to access the server. Here is how you can configure Filezilla:

3) What is Currently on the Server?

You have 2 folders:

sqlpage_config: contains a YAML file to configure your connection to your database.
website: currently contains the default index.sql file that generates the welcome page. This is where you will put your SQL files for your app (such as your own index.sql file).

4) What is the YAML File in the Folder `sqlpage_config`?

You have the link to the default PostgreSQL database hosted on the server. You can use this database or connect to your database directly by changing the database URL. For instance, if you have a MySQL connection, you need to change the database_url to point to your MySQL database.

Here is an example for a MySQL database_url:

mysql://username:password@host:port/database

5) What You Will See When Connecting to https://XXX.datapage.app/

Before you put any SQL files in the website folder, you can see by default this page:

Once you start putting your SQL files in the website folder on the server, your SQLPage app will appear at this address.