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?
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.
You'd be better to go somewhere like StackOverflow with these questions.