Hello everyone! I was facing trouble integrating my Postgres SQL databases with my app on Softr. I am trying to configure the Postgres database as my data source, but I keep getting an error. I am using my IPV4 address as the host name and the default port. Please advice.
Hey @Ahmed.Yasser,
Updating here as well, it may help others. The reason for the issue was using local IP. To be able to connect smoothly one should use publicly accessible IP.
2 Likes
Thanks for your collaboration. Are there any conventional websites that can be used to host the Postgres SQL database?
Hi Suzie, I’m looking into developing projects in SQL but I never faced this IP issue. Just in case this happens to me too, where should IP to publicly acessible?
I used Neon.Tech to host my PostgreSQL database online for free. I am not sure if they offer paid plans for bugger databases.
@Ahmed.Yasser you can get your connection details from a screen like this below. I took this from my example project in Neon
1 Like
@gfranco, if you face issues, let us know, and we will help to identify connection credentials and IPs… it’s different from a provider to provider but essentially all of them have it listed somewhere in their UIs
@artur Yes, I did that in my project. Thanks alot!
I see then would be good to know because I manage my own servers. There is something else to consider when having publicly accessible IP?
@gfranco just make sure you have security in place and also you can enable access for our IPs only…