Using MySQL in GAE locally (is it actually possible?)

[webm...@trytha.com]

I've got MySQL working locally in GAE, but since GAE doesn't write to the file system, it can't touch /databases.  Am I doing something wrong?  Has anyone actually gotten GAE working with MySQL locally?  I can't find a single tutorial related to this.  If someone shows me this last step, I can put together a tutorial from fresh OSX install to fully-functional web dev environment with web2py on GAE in a Virtualbox VM (a tutorial web2py desperately needs).  I already have all the steps in an Evernote, just need to figure this last part out.

I even tried putting "folder='/home/www-data/web2py...'" in my DAL connection string, but nothing gets written in the /databases folder still.  GAE does all the MySQL creation and then hits me with a corrupted *.table error the first time I refresh because nothing is written in /databases.

Can I write the databases to memcache or datastore somehow?  How is GAE handling this on the server side without errors?

[webm...@trytha.com]

Ok, I went into the web2py_filesystem file that's being created in MySQL by GAE.  It shows a bunch of these .table files, but web2py (when run on local GAE) is still searching for the folders in the OS's filesystem.  Is this just a bug?

[webm...@trytha.com]

I narrowed the problem to pydal.  I could get things to work in web2py 2.12.2, but in 2.13.4, something has changed which makes GAE no longer work for me.  That appears to be the source of my problem.  But web2py is supposed to be backwards compatible, so.....

Just did a test.  Whatever broke happened on the update to 2.12.3.  I can literally install 2.13.4 (latest version), then replace gluon/packages/dal/pydal with the pydal folder from 2.12.2 and everything works fine.

I don't have anything fancy in my app.  I've only made edits to controllers and views (and of course defined my tables and menus in the models).

Can anyone get GAE to work with MySQL in version 2.12.3 or later?

[Massimo Di Pierro]

To my knowledge is was broken in 2.12 not in 2.13. I had tested it. Will test it again.