[web2py] Re: Migrating Postgres to MySql

2016-10-12 Thread Ben Lawrence
For anyone using raspberry pi, postgresql can't be used with the scheduler, due to incompatibility in one of the JSON fields. I have had no trouble using scheduler with mysql on raspberry pi. On Sunday, September 18, 2016 at 12:10:45 AM UTC-7, Joe Barnhart wrote: > > When I first started using

[web2py] Re: Migrating Postgres to MySql

2016-09-18 Thread Joe Barnhart
When I first started using MySql awhile ago (after having used Postgres longer) I was screaming mad all the time. I absolutely hated MySql and the crap it put me through. That was a few years back, and I can't quite remember what made me so mad. Other than performance, of course. I feel

[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: 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: Migrating Postgres to MySql

2016-09-16 Thread Joe Barnhart
Huh. Just tried db.export_to_csv_file() again and it wasn't nearly as slow as I thought before. It took about 2 minutes for a largish (but not my biggest) database, exported from Postgres. As a fun thing to try, I ran the same command under the most recent pypy and the same export took only