I would like to move my database to the cloud as it is too big for OTA updates even tho carrier data plan prices are coming down. Plus I want to separate updates to the software from updates to the database (transit schedules).
First of all, any recommendations for low cost hosting (its a free app). Amazon's offerings at first look are very confusing and their calculator uses language I don't even understand.
Database will about 50-60 megs since I plan on adding many more indexes than the current SQLITE version has. I have no idea on the usage traffic as its a local transit app that will probably take a while to even have 500 users (its a port to the Blackberry Z10).
Secondly since its a read only database I would like to create and populate it on my PC and then upload it. Is this possible?
Any easy way to locally host a MYSQL database on my PC for testing before making the big jump?
First of all, any recommendations for low cost hosting (its a free app). Amazon's offerings at first look are very confusing and their calculator uses language I don't even understand.
Database will about 50-60 megs since I plan on adding many more indexes than the current SQLITE version has. I have no idea on the usage traffic as its a local transit app that will probably take a while to even have 500 users (its a port to the Blackberry Z10).
Secondly since its a read only database I would like to create and populate it on my PC and then upload it. Is this possible?
Any easy way to locally host a MYSQL database on my PC for testing before making the big jump?