Hi! If your DB is so small and could be entirely placed in memory, you could have one yet web2py app on PythonAnywhere.com ( it's free) and use it as just data source. I mean - "every couple of months with 3 or 4 more" your GAE app reload all data from your PythonAnywhere app
On Friday, March 11, 2016 at 12:07:01 AM UTC+3, Brendan wrote: > > Hi > > I have a web2py app on GAE at the moment that takes some of its data by > parsing a hard coded string constant (at the moment, it has a half a dozen > rows each with half a dozen or so columns). > I plan to expand this to have dozens of rows and updated every couple of > months with 3 or 4 more. I was planning on doing this with a local sqlite > database but GAE doesn't seem to support it. > My question is: > > * if I import the db into the GAE datastore how do I update it? > > - If I have a local sqlite db then I can simply upload a new copy of the > db. > - Do I need to write a GAE interface to add entries (I'd rather do it > locally). > - Do I run a db restore from a local copy? > - if I add columns later does this cause GAE any heartache? > > I am thinking that using the datastore will be overkill and I should just > serialise the db (JSON? Configparser? yaml?) then deserialise/treat it as a > dictionary in memory at run time. > Advice? > > Thanks > > > Brendan > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
