»Connecting your app to your database
Adaptable Deploy Templates provision a database along with your app, then automatically provide database connection information to your app via environment variables. Depending on the Deploy Template and database type you selected for your app, different environment variables may be available to your app.
Detailed instructions and examples for connecting your app to the Adaptable database can be found in our App Guides:
- Deploying an Express App
- Deploying a Feathers.js API App
- Deploying a Flask App
- Deploying a Gin App
- Deploying a Golang App
- Deploying a Laravel App
- Deploying a NestJS App
- Deploying a Node.js App
- Deploying a PHP App
- Deploying a Python App
- Deploying with a Dockerfile
To view the Deploy Template documentation for your app, go to your App Dashboard and choose the app you wish to view.
On the App Status page, click the link next to the words Deploying with.
»Connecting with other tools
Adaptable databases can be managed with standard database tools, including command line interfaces and graphical tools from the database vendor as well as 3rd party tools.
See Database connection information below to find all the information needed to connect to your Adaptable database, including hostname, port, username, and credentials.
Commonly used management tools for supported Adaptable database types are listed below.
»MongoDB
»PostgreSQL
»Microsoft SQL Server
»Database connection information
To view all the information needed to connect to your Adaptable database, including hostname, port, username, and credentials, go to your App Dashboard and select the app you wish to view.
Then, click on the Resources tab.
Now click Connection Information for the database you wish to connect to.
»Connection String (URL)
The Connection String includes all information needed to connect to your database in URL format. Some database tools can use this format, but others may require you to enter the individual components such as Database Host and Username separately.
»Viewing the Password
The database Password is hidden with asterisks (*) by default.
Click the Eye icon next to the Connection String or Password to toggle revealing and hiding the Password.
important
The database Password may contain special characters. In some cases, especially in command line interfaces, you may need to do special quoting or escaping of those characters to use the Password.
Using the Password in a URL format requires certain special characters in the Password to be URL-encoded. The Connection String on this page has already been correctly URL-encoded.
»Copying Connection String or Password to the clipboard
Click the Copy icon next to the Connection String or Password to copy the corresponding value to your system's clipboard so that you can paste it into another application.