Thread tagged as: Question, Forum

SQL Database Connection

Hi all,

This isn't a Perch related question necessarily but I was wondering if anyone had any ideas...

I have a SQL Database which serves as the backend for a piece of software I have written. I have this hosted on a 'server' machine which also serves the other computers on our network.

Now... I was wondering if there was any way to connect this locally hosted database to my website so that I can pull content from the database to be displayed on the website. Is this possible?

Conor Harkins

Conor Harkins 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

It's possible, but the latency would be horrendous, so your queries would be very slow.

Thanks for the reply.

Great! Would you happen to know of any tutorials or articles that would detail the steps?

Is there an alternative method that would speed things up?

I currently access the database using a VPN from outside the network which can sometimes be slow too depending on the strength of the wifi.

Drew McLellan

Drew McLellan 2638 points
Perch Support

You'd be better to go somewhere like StackOverflow with these questions.