So far, I have been developing my app locally on my laptop (I am just using
the built in rocket server with sqlite on my windows laptop and it is
working great!!)
However, I am now trying to get my app uploaded to the google app engine
using SQL , instead of using noSQL. I have my db set up this way
if not request.env.web2py_runtime_gae:
## if NOT running on Google App Engine use SQLite or other DB
db = DAL('sqlite://storage.sqlite')
else:
## connect to Google BigTable (optional 'google:datastore://namespace')
#db = DAL('google:datastore') #for no SQL
db= DAL('google:sqlstore') #for SQL
## store sessions and tickets there
session.connect(request, response, db = db)
When I use the db=DAL('google:sqlstore') option to use SQL, and when I try
to access my app through google app engine, it sends me to a page that just
says "Internal error, ticket issued unknown"(it is not the typical web2py
error message, seems to be coming from google app engine). And when I click
on the link "unknown" it sends me to the web2py administration site. The
example , and welcome apps seems to be working fine on my google app engine
instance so I figured I am doing something wrong in my app. I tried using
the noSQL option, and if I do that, it at least sends me to a web2py error
page because I am using join related commands to access my database (hence
the reason I want to use SQL).
I looked through the documentation and it seems like google's sql can do
everything that sqlite can do. I also believe I'm not performing any writes
or reads into the filesystem since google app engine prohibits it. Is there
anything crucial I am missing?
Is there somethign
