[web2py] Re: Migrating Postgres to MySql

2016-09-17 Thread junderhill
Joe, I'd be curious to know how you feel MySql performs in comparison to Postgres. On Friday, September 16, 2016 at 2:28:09 PM UTC-7, Joe Barnhart wrote: > > I've been using PostgresSQL for my production site for quite awhile. My > future improved site, however, will feature MySql for its

[web2py] Re: web2py on android

2016-09-17 Thread JorgeH
what if I need to store data in the mobile when there is no internet connection and sync with the webserver when there is connection? what db or sqlite, can I use? On Saturday, July 23, 2016 at 1:03:24 AM UTC-5, eric cuver wrote: > > you can use cordova wbeview and used side client brython(

[web2py] Re: Migrating Postgres to MySql

2016-09-17 Thread Joe Barnhart
Ha. Looks like I'm going to have to write the two-db app regardless. The surprising thing is, Postgres allowed me to put in strings that only differ in case into tables where the string was declared "unique". MySql, however, considers them the same and throws an IntegrityError exception

[web2py] Re: Fetching rows with st_asgeojson()

2016-09-17 Thread Gael Princivalle
Someone have an idea? Here is the code that works: features= [{"type": "Feature", "properties": { "popupContent": "" + event[db.events.title] + "", "track_quotation": str(event[db.events.track_quotation]) },

[web2py] Re: sqlite3 driver not found ((

2016-09-17 Thread Dmitri Ermolaev
пятница, 16 сентября 2016 г., 21:34:57 UTC+3 пользователь Dmitri Ermolaev написал: > > I try to install on Unix server - unpack .zip > and run apps - error: > Failure to connect, tried 5 times: Traceback (most recent call last): > File >

[web2py] scheduler and long tasks

2016-09-17 Thread Pierre
Hi, right now I have a single task that runs once a day and am wondering if it would be a good idea to split it into "atoms"/ smaller bits soas to take advantage of work division ( use several workers instead of just one). I can't figure out how to do this since all the work to do depends on a

[web2py] Re: Is it safe to use plain XMLHttpRequest instead of ajax() function?

2016-09-17 Thread Przemysław Loesch
Anthony thank you very much for your hints. I've started to learn the web2py workflow from the Book and directly from the web2py source but your advises are priceless and save a lot of my time. Przemek -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -