Can I use Wamp server as a MySQL database ?
https://github.com/dmccuskey/dmc-wamp?files=1
https://github.com/dmccuskey/DMC-Corona-Library?files=1
https://forums.coronalabs.com/topic/64987-mysql/
https://coronalabs.com/blog/2015/06/02/tutorial-connecting-to-restful-api-services/
http://omnigeek.robmiracle.com/2012/04/15/using-corona-sdk-with-rest-api-services/
WAMP stands for Windows + Apache + MySQL + PHP. It’s a Windows setup that mimics LAMP (Linux, …) or MAMP (Mac, …) All of them produce an out-of-the-box setup where the computer will act as a webserver (Apache running on port 80) that knows how to process PHP scripts. PHP can talk to multiple database types, but the setup will usually install MySQL as the database for it.
If you install WAMP on your personal computer, it’s great for development, but it’s not great for serving data to the public. You may have to modify your home firewall/router to put your computer into a DMZ or area that the general internet can connect to. This opens your personal computer to to being hacked as you allow people to open connections to your computer (normally your firewall/router would block those connections). Also when you run high memory apps like Photoshop, you will likely impact performance of your WAMP server or if you have a lot of connections to your server from the outside, it will hurt your performance. You can setup a dedicated box this way, but you have to be able to get it into an open area of your network. If you internet provider manages your router, you may not get public access to a machine on your network.
This is what web hosts are for. You pay them a small monthly fee and they manage the network and hardware for you. You just have to write your scripts, HTML, CSS and such and manage your database.
Rob
Oh okay thanks . I am still writing my app which means I don’t need to pay for web hosting right now . Do you know what web hosting services are give free hosting for a certain amount of GB’s ?
Digital ocean give you two month for free and Amazon give you free year of service. I use digital ocean which is more open and easier to hack.
I am using 000webhost . Do you think it’s safe ?
are you using free or paid?
free because i’m still testing/creating my app
Free sucks, no ssl(required for Apple) and if you have inactivity it will shut down. You cannot use your own domain and closed system. Since there is no ssl it is not secure.
I honestly cannot recommend them.
It is also not scalable.
Okay so … What if I use it now . And when I’m ready to go live switch to GoDaddy ?
You can use who every you want. You may want to use lets encrypt with your site.
I know that , but I want something very safe for users .
A site is only secure as you make it. Use a good ssl certificate.
So would godaddy be good ?
I think godaddy is a great option. When looking for a host you want to look at value per gb and bandwidth, make sure it is scalable, does it offer ssl which makes a site secure, and is it someone I trust
Okay thanks
There are two types of hosting:
-
Web hosting. You share servers with other customers. Most decent hosting companies will allow you to have multiple domain names, unlimited subdomains. You generally get access to the webserver and databases, but you can’t run your own servers. You will get Apache for the web server. You get the PHP version they have installed and will have limited configuration ability. Usually they give unlimited data storage, pretty high limits on bandwidth and you’re not measured by CPU usage since you’re sharing servers. These providers run in the $5-$15 USD per month in most cases. GoDaddy’s services fall into this category.
-
Virtual Dedicated hosting. With this you get a server and you’re handed the keys to the full admin of it. This means you can choose to use the database of your choosing, the web server of your choosing and if you need to run a dedicated service you can. You generally have to setup your own web server, manage your domains and such yourself. These tend to bill more by how much CPU you use and how much data you transfer. But they can be affordable. But you need to have some understanding of server management before you go here. Many web hosts also offer virtual dedicated hosting.
2b. A variant of Virtual Dedciated hosting has Cloud services built in. The servers can scale as your needs grow. They take advantage of multiple servers around the world and caching to make your files deliver quicker and so on. Scott’s references to Digital Ocean and Amazon’s AWS service are examples of this.
You may or may not get free SSL certificates with some hosts. Normally its a lot of paper work and $300 per domain name per year to get an SSL certificate. There is a new group with some serious big names behind it that believe all websites should be secure. The project is called “LetsEncrypt” (https://letsencrypt.org/). With LE, SSL Certificates are free, and its easy to install and you don’t have the huge identification restrictions.
I was hosting at a hosting provider and they wanted expensive fees to setup and maintain SSL and for me where I have a dozen websites and even more sub-domains, it would be very cost prohibitive. So I found a new hosting company that would transfer my whole site to their site and they supported letsencrypt. There were some hiccups in getting my site transferred because the original site wasn’t following standards. But now that I’m up, every site is https: capable and I’m saving $6 a month.
As for cloud/virtual hosting, I do like Digital Ocean.
Rob
So would 'web hosting ’ be good for hosting a social app ?
You could use either