Hi Joe,
PythonAnywhere dev here (glenn on the Forums). Are you the guy I was
talking to in the forum thread titled "Web2py app connecting to mysql
database"? If you are, do you mind if I chime in to this with some of the
details we worked out to give the web2py guys a little more to work on?
On Sunday, 16 August 2015 23:50:03 UTC+1, Massimo Di Pierro wrote:
>
> I would talk to them. They are very supporting. Anyway that said. You can
> use any hosting you want. I use Python Anywhere, Digital Ocean, Google App
> Engine, and Google Managed VM (with Docker) for different projects.
>
> On Sunday, 16 August 2015 15:43:21 UTC-5, DaneW wrote:
>>
>> I've been using PythonAnywhere happily for over 2 years. The database
>> (now with over 12m records) has worked perfectly under SQLite and later
>> MySQL - although I do get error 1226 about exceeding max_user_connections
>> every so often.
>>
>> In the db.py model I have db =
>> DAL('mysql://aaa:[email protected]/ccc$db1',pool_size=0,lazy_tables=True,check_reserved=['all'])
>>
>> - where aaa is my user name, bbb is my MySQL password and ccc$db1 is my
>> database name.
>>
>> I used to have pool_size=1 but in the light of Annet's suggestion I've
>> changed it to 0 and it seems to be working ok. Also PythonAnywhere are
>> saying that recent infrastructure changes mean that we should alter
>> mysql.server to *yourusername*.mysql.pythonanywhere-services.com but
>> that results in my website crashing immediately so I've left it as it used
>> to be for the time being.
>>
>>
>>>
>>>
--
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.