Among RDBMSs, I personally prefer Postgres too, for many of the reasons
mentioned - quality of build and add-ons, platform availability, SQL
compliance, optional commercial support, Oracle compatibility.
But another factor to consider is deployment on IaaS/PaaS options. Heroku
and OpenShift can
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
t
Also you should consider that DAL adapter are not all equal on quality,
quality for a given adapter is "correlated" to the user base for a given
(my interpretation) and since Postgres is largely used it adapter is really
good. Notice that there is two adapter for postgres psycopg2 and pg8000 the
fo
Thanks Richard.
Postgres
Pros: Many User in web2py, open source
Cons: Speed
MySQL
Pros: Speed
On Thursday, March 7, 2013 9:57:48 PM UTC+1, Richard wrote:
>
> Postgres, full open source, supported by a consortium, commercial support
> available (ex.: Enterprise DB), build-in Foreing key constra
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 he
5 matches
Mail list logo
