I'm building a Facebook game in Flash, and right now I'm running it off a normal (not cloudy) web server and talking to a MySQL database via php. It works great, but I'm afraid it's not gonna be scalable. So I built a sample php Facebook app on Heroku, which also works great, but I'm running into trouble figuring out what kind of database to use. Since the game isn't finished yet, I'm open to switching to a non- MySQL DB, but I'm not sure which is best. As far as I can tell, my options are:
1. Use the PostgreSQL DB that comes standard with Heroku - this is appealing b/c it seems like the most straightforward 2. Use an add-on that lets me use a MySQL DB - this is also appealing b/c it means I don't have to do much more work 3. Use Cloudant 4. Figure out how to use Couchbase #3 and #4 seem like the right way to go, b/c my data is really simple -- a users table, and maybe an achievements and organizations table -- and all the research I've done points to CouchDB as being the most appropriate technology for me. It really seems like Couchbase is the way to go. But I'm at a loss as to how to get it running on Heroku. Does anyone have any experience with it? Specifically, accessing it through php, since I'm not sure I can talk to rails from Flash (and I don't know rails anyway)? Is that even possible? Or am I barking up the wrong tree? Should I be going with Cloudant? Or PostgreSQL? thanks in advance for your advice, Josh -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
