Database Access for Cloud/Hosted accounts?

My current POS is going EOL at the end of May. I have liked everything about PHP POS in my testing thus far and I am setting up a roadmap to convert to this system in the next few months.

One of the decisions I need to make is whether to purchase the source code and host it myself on my own web server vs. using the cloud version. One of the advantages of hosting it myself is that my shop's website is also run on a LAMP stack. Since the Databases would be side-by-side, I have played with some custom integrations between the two and I have found its' relatively easy for my website to run query's on the POS's database. This would allow me to exchange information (ex., gift cards, customer rewards, order status, etc.).

If we were to purchase the cloud/hosted version, do you guys allow remote connections directly to the MySQL database so I could utilize this kind of functionality? I am *not* running a Wordpress or WooCommerce website so the existing integration offered isn't an option for me. Thanks, just let me know guys. Obviously there are pros and cons to self-hosting vs. going with your hosting and I just need to decide on one.

Official comment

Chris Muench

March 06, 2018 19:27

We do not offer access to mysql database on cloud for security and reliability. We are developing an API for version 16.1 so you will be able to programmatically get/add/update various parts of system.

Tynan Fox

March 06, 2018 19:38

I figured as much but also figured I would ask. Thanks for letting me know!

And I like the idea. Since 16.0 was just released though I am *not* going to pester about when we can expect 16.1. :) Thank you!

March 06, 2018 19:44

4-6 weeks

Martin Roy

December 14, 2018 20:27

huh with hosting you could access your php database through cpanel. Thats how i do it on our hosting company www.yourwebhost.website I had phppos installed on their server in 30 minutes Took longer to upload all files then doing the initial setup.

December 14, 2018 20:32

I believe they were asking about accessing data from our cloud solution (Not our download). We do NOT give direct access to our databases for security and performance reasons. (We don't want our customers running queries to affect our stability)

Database Access for Cloud/Hosted accounts?

Comments

Didn't find what you were looking for?