I have not run my own tests but as I understand it the claim that MySQL is speedier is only true when using it without transactions. If one looks at the web2py dal adapters one can see that the PostgreSQL adapter is the smallest. that is because it is the closest with the standard SQL and has the few gotchas to deal with. It also provide JSON support and geospatial APIs.
On Thursday, 7 March 2013 14:57:48 UTC-6, Richard wrote: > > Postgres, full open source, supported by a consortium, commercial support > available (ex.: Enterprise DB), build-in Foreing key constraint, PL SQL (so > you can migrate to Oracle), Still with commercial build you are still at > one/ten the price of Oracle DB... > > Also, I think many serious web2py user here are using Postgres. > > You will have Cons about speed... And Pros for MySQL for the inverse > (MySQL speedier). > > The rule of thumd is, if you need speed on retreiving information (you > mostly do select query) go with MySQL. It is reputed faster on select. > > Richard > > > > > > > On Thu, Mar 7, 2013 at 3:41 PM, BlueShadow <[email protected]<javascript:> > > wrote: > >> Hi guys so I learned that using SQLlite for me wasn't a great >> choice(thanks Niphlod). But since I started using databases when I started >> to use web2py. I got no clue what database to use. I used sqllite because >> it was in the welcome app and it worked while having my site offline and >> with me being the only user. I know the choice is mostly personal prefrence >> but I thought give it a trail and ask you guys why you chose your >> particular database. >> It would be really nice if you could tell me a few pros and cons. >> I researched a little on PostgreSQL, MySQL and SQLite the informations I >> got were sometimes contradicting. >> I got about 2 times a writing command per page per visit. (keeping track >> of views for articles) but apparently thats already too much for SQLite. >> >> -- >> >> --- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- --- 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/groups/opt_out.
