Read more about PostgreSQL Integration in Glide docs.
Accessing PostgreSQL in Glide
PostgreSQL as a data source is available to Business and Enterprise customers only.
PostgreSQL Version Support
Glide is designed to be compatible with all versions of PostgreSQL. To ensure the best performance and avoid compatibility issues, Glide recommends using the latest version of PostgreSQL.
Locating Configuration Credentials
When setting up PostgreSQL with Glide, you will need the correct configuration credentials, which include the username, password, host, and database name. These are typically found within your hosting platform’s database access settings or provided as a connection string.
SQL and Updates Consumption
SQL data sources consume updates only when you actively modify data within your Glide app (add, edit, or delete operations). Routine syncing and querying operations do not use up your Glide app's allotted updates. Changes that result in adding, editing, or deleting data from either Glide or the connected SQL database will accrue updates.
Read more about Updates.
Configuring IP Allowlist for PostgreSQL
If your host platform requires an IP address to be added to the allowlist for security reasons, you should add Glide’s IP address: 34.133.75.11.
PostgreSQL Security and Glide
Glide supports TLS (Transport Layer Security) and SSH (Secure Shell) tunnels to encrypt data transmitted between your PostgreSQL database and Glide app. This encryption prevents unauthorized access and protects your data during transmission.
Glide supports certification verification for globally trusted certificates and Amazon RDS certificates. This ensures that only verified and trusted connections are established with your PostgreSQL database.
Most hosted platforms use certificates that have been signed by trusted root certificate authorities. Glides platform supports such certificates in addition to certificates issued by AWS RDS service.
Users of Google CloudSQL should utilise the CloudSQL specific integration as it will make use of Google Cloud Platform APIs in order to connect using secure ephemeral certificates.
If you are self-hosting your database and don't have the ability to acquire a root signed certificate (or your host doesn't provide one) you will need to disable TLS certificate verification at this time.
Adding Multiple Instances of PostgreSQL
Glide allows the integration of multiple PostgreSQL databases within your app. This can be done through the App Settings under the Integrations menu, where you can add additional databases as needed. To add an additional database:
Navigate to the App Settings menu.
Select “Integrations.”
Select "PostgreSQL" under Integrations.
Click "Add" and fill out the configuration details.