[Seaside] does ROE work with MySQL

[Avi Bryant]

On Apr 5, 2004, at 11:04 AM, Travis Griggs wrote:

> Nils Kassube wrote:
>> On Mon, Apr 05, 2004 at 08:02:20AM -0700, ld wrote:
>>  > I plan on using seaside with  MySQL.  Is ROE the tool to use to 
>> talk to
>>  > it? ( I am using MySQL because I need a relational database that 
>> will
>>  > run on Linux, MAC, and Windows.  )
>> PostgreSQL works fine on Linux, Mac OS X and Microsoft Windows 
>> platforms.
>> There's simply no good reason anymore to use MySQL. PostgreSQL rocks!
>
> Nils,
>
> Without starting a flamefest here or anything... why do you say this? 
> I am asking from ignorance. I don't do much databases myself, but we 
> used to have a guy here, who had an obvious preference for PostgreSQL. 
> But when I was talking to another Linux neophyte the other day, he 
> didn't know either, but he got the impression that he read and saw 
> more of MySQL. Which left us both asking each other, "so if we had to 
> set something up ourselves, which would we choose" for which both of 
> us had to admit ignorance.

Well, for a long time MySQL had neither transactions nor subselects.  I 
believe in recent versions it has both, so the reasons not to use it 
are getting fewer.  If the subselect implementation is any good, you 
should be able to use ROE with it, but I've never tried.