MySQL, PostgreSQL and irev

[Michael Kann]

Pierre,

Thanks for the great information. You are the Andre the Giant of database design.

Mike

--- On Sat, 7/31/10, Pierre Sahores <psahores at free.fr> wrote:

> From: Pierre Sahores <psahores at free.fr>
> Subject: MySQL, PostgreSQL and irev
> To: "How to use Revolution" <use-revolution at lists.runrev.com>
> Date: Saturday, July 31, 2010, 5:25 PM
> In betwin us, ....
> 
> One year ago, i could'nt start my first irev project in
> binding it to my prefered RDBMS ever : PostgreSQL but ...
> MySQL 5 was available and configured for production state
> use and i started to work with it and got what i needed from
> it ...
> 
> I'm yet working on an other project that i firstly choosed
> to bind to MySQL but, i discovered inbetwin that PostgreSQL
> is yet configured to work as expected with on-rev ! Because
> the current project is still in its early stage, i'm yet
> switching it from MySQL to PG and you know what : PG is
> realy, realy more reliable than MySQL ...
> 
> Less, cleaner and clear SQL statments are what we get in
> choosing the BSD licensied PG against MySQL. The main
> advantage : less time is needed to setup a rock solid
> (acid-complient) SQL backend. Best, i had to use the PostGIS
> components in an AJAX (kmap) GIS project, some years ago for
> the french CNRS and you know what : it's as cool as the rest
> of the PostgreSQL core components !
> 
> Just to say : you are tied to compose with the MySQL
> "caprices" ? Just try PG and you will love it and switch to
> it in understanding all the precious working time you will
> get back in avoiding to have to compose with the Oracle's
> MySQL "semi-calamiteuse" solution anymore ;-)
> 
> Best,
> --
> Pierre Sahores
> mobile : 06 03 95 77 70
> www.sahores-conseil.com
> 
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage
> your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>