[Seaside] does ROE work with MySQL

[C. David Shaffer]

Maybe this will help:

http://www.databasejournal.com/features/mysql/article.php/3288951

I read through it but can't personally attest to its accuracy.  "Way 
back when" I avoided MySQL because it didn't support much in the way of 
transactions and locking (just table level locking, as I recall) but I 
think it has improved since then.  Not really sure though...since I made 
the decision to use PostgreSQL I never looked back.  It has been a solid 
DB for me across about 11 substantial deployments (none using Smalltalk 
I'm sorry to say).

I can say that my students often have more experience with MySQL when 
they get to me so I would agree that it does seem to get most exposure.  
I think that the LAMP folks have really had a big positive impact on 
MySQL usage.  I also notice a lot of software which comes with MySQL 
"integrated" so if you want to ship a desktop product with a decent SQL 
backend, MySQL might be the right choice.  I also know several books 
(one of apache/PHP programming comes to mind) which come with MySQL on a CD.

David

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.
>


-- 
C. David Shaffer
http://www.cs.westminster.edu/~shaffer
http://www.shaffer-consulting.com