In order to connect to your source database, Snaplet needs read-only database credentials in the form of a connection string, or connection URL.
A PostgreSQL connection URL specifies the following parameters:
- username (the username used to connect to the database)
- password (the password used in the "user" parameter)
- hostname (the IP address or domain name of the machine where the server is running)
- port (port number on which the server is listening on)
- database (name of the database to connect to)
This connection string may also include a collection of optional parameter keywords that allow adjustments of various aspects of the URL (e.g. SSL, timeouts, etc).
Here's an example connection string:
When passing in a connection string to Snaplet, we will attempt to validate and encode the connection string, however you may still have problems with database names or passwords and special characters
(%&/:=?@), in this case you may have to URI encode your username and/or your password.
Let's take an example in which your database password is
You can then paste the encoded password into your connection string: