Open-world, windows, camera-lock, and MySQL?

So a few newbie questions.  I took some great tutorials but I feel like I’m somehow skipping over/missing some key information.

  1. Open world movement with the camera locked on the main character, is this something that there are add-ons for?  More than anything, think of the classic Pokemon games where the camera was locked on the player.  Only difference is I’d need where you click where to move the champ on the screen.  Does an add-on code for this exist already?

  2. How do you create more than one ‘window?’  Is this a thing, or no?  I saw a mention of groups (which seemed to be a group of items that you can manipulate together), but no mention of actually windows.  So example, you press a button to open a new window, then press back to go to the previous button.  Are there commands for this or do you manually register the back button and take actions on your own to re-create the previous screen?

  3. Is MySQL possible for use w/ Corona?  I’ve used MySQL all my life and love it.  I’m going way out of my comfort zone for Corona SDK, so if not, I don’t see what’s stopping me from learning even more new tools.  So if MySQL is not an option, what is recommended most by Corona SDK developers?  I’d use it for user register/login, character save data, and general information.

Hope I’m not asking too much, I’m just a bit lost… ):

Thanks!

-Chris

#3 - You’ll be using SQLite with Corona SDK and if you’re comfortable with mySQL you won’t have any problem switching over.

Here’s a link to the docs on it: http://docs.coronalabs.com/api/library/sqlite3/index.html

Jay

Thanks Jay!  I think more or less I’m trying to get ahead of myself.  If anything else, I’ll definitely look into that (:

-Chris

#3 - You’ll be using SQLite with Corona SDK and if you’re comfortable with mySQL you won’t have any problem switching over.

Here’s a link to the docs on it: http://docs.coronalabs.com/api/library/sqlite3/index.html

Jay

Thanks Jay!  I think more or less I’m trying to get ahead of myself.  If anything else, I’ll definitely look into that (:

-Chris