You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Akmal Sarhan <as...@byteaction.de> on 2003/12/08 11:40:30 UTC
Mysql vs. PostgreSQL
Hello,
we are in the process of migrating our Turbine applications from MySql to PostgreSQL and we would like to ask those who had some experience with them to highlight the pros and cons if possible.
thanks
Akmal
Re: Mysql vs. PostgreSQL
Posted by Loïc QUERAN <lo...@gicm.fr>.
Transactions and foreign keys can be used with mysql. InnoDB tables make it
possible. They are optional in mysql version 3 (mysql-max), but are shipped
with mysql version 4.
As regards subselects, I think they should be supported starting at version
4.1, which is today at an alpha stage.
The problem is rather a Torque problem than a MySQL problem.
Is there any plan to have Torque use InnoDB tables ?
As regards the encoding problem, I personally use ISO-8859-1 or UTF-8 encoding
with MySQL with no problem. My first name for example contains a 'ï' which is
stored and rendered correctly. My OS is Linux RH 9.
Loïc
On Monday 08 December 2003 12:07 pm, Scott Eade wrote:
> Akmal Sarhan wrote:
> >we are in the process of migrating our Turbine applications from MySql to
> > PostgreSQL and we would like to ask those who had some experience with
> > them to highlight the pros and cons if possible.
>
> I have just gone through this exercise - quite a difficult task, but
> IMHO worth it.
>
> The big pros are:
> + Transactions (though you can get this working in MySQL)
> + Enforcement of referential integrity
> + Support for subselects (though not via Criteria)
>
> For some good information see:
> http://nagoya.apache.org/wiki/apachewiki.cgi?TorqueProjectPages/PostgreSQLF
>AQ
>
> Scott
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Mysql vs. PostgreSQL
Posted by Akmal Sarhan <as...@byteaction.de>.
very interesting, was very helpfull. thanks for all those who replied.
regards
Akmal
----- Original Message -----
From: "Scott Eade" <se...@backstagetech.com.au>
To: "Turbine Users List" <tu...@jakarta.apache.org>
Sent: Monday, December 08, 2003 12:07 PM
Subject: Re: Mysql vs. PostgreSQL
> Akmal Sarhan wrote:
>
> >we are in the process of migrating our Turbine applications from MySql to
PostgreSQL and we would like to ask those who had some experience with them
to highlight the pros and cons if possible.
> >
> >
> I have just gone through this exercise - quite a difficult task, but
> IMHO worth it.
>
> The big pros are:
> + Transactions (though you can get this working in MySQL)
> + Enforcement of referential integrity
> + Support for subselects (though not via Criteria)
>
> For some good information see:
>
http://nagoya.apache.org/wiki/apachewiki.cgi?TorqueProjectPages/PostgreSQLFAQ
>
> Scott
>
> --
> Scott Eade
> Backstage Technologies Pty. Ltd.
> http://www.backstagetech.com.au
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Mysql vs. PostgreSQL
Posted by Scott Eade <se...@backstagetech.com.au>.
Akmal Sarhan wrote:
>we are in the process of migrating our Turbine applications from MySql to PostgreSQL and we would like to ask those who had some experience with them to highlight the pros and cons if possible.
>
>
I have just gone through this exercise - quite a difficult task, but
IMHO worth it.
The big pros are:
+ Transactions (though you can get this working in MySQL)
+ Enforcement of referential integrity
+ Support for subselects (though not via Criteria)
For some good information see:
http://nagoya.apache.org/wiki/apachewiki.cgi?TorqueProjectPages/PostgreSQLFAQ
Scott
--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Mysql vs. PostgreSQL
Posted by ilfrin <il...@poczta.onet.pl>.
Hi Akmal,
8 grudnia 2003, 11:40:30, zastalo napisane:
AS> Hello,
AS> we are in the process of migrating our Turbine applications from
AS> MySql to PostgreSQL and we would like to ask those who had some
AS> experience with them to highlight the pros and cons if possible.
if you consider using UTF-8 and foreign charactes forget about MySQL..
use Postgres
--
Bye,
ilfrin mailto:ilfrin@poczta.onet.pl
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org