Re: DB Preferences (Postgresql vs. MySQL)

On Saturday 12 March 2005 23:15, Rick Handrich wrote:
> Thanks for the help on my previous problem with Text formatting in a Form.
>
> I am just beginning what will be a couple ongoing conversion efforts
> from MS Access to a Linux DB.  I first converted the tables to
> Postgresql, for no real reason except that it was already installed on
> my Linux box.
>
> Have been doing a little reading, and it occurs to me that MySQL may
> have some advantages.  It's not to late for me to drop back and punt
> here.  Anyone have suggestions re. the advantages of one over the other.
>
> Considerations for me would include:
>     Portability between boxes.  (Can I pick up the entire db, with
> ReKall, and install it on another box.)
>     Compatibility issues with ReKall.
>     Easy, active on line support.
>     Run-time system availability.
>     Anything else that you think an unprofessional DBA should consider.

My preference at the DB level has been postgres, on account of stuff like 
transactions and views, but then again mysql is catching up.

The biggest ball-ache with postgres is that it doesn't have real 
"auto-increment" columns. It does have "serial" columns but these are just 
syntactic sugar for columns whose default value comes from a sequence (i 
guess this is the "proper" sql mechanism). This can cause real problems if 
you need to rename a table and create a new one with the same name - which is 
what rekall does if yiu change table design as is currently doesn't know 
about stuff like "alter table ..."

Regards
Mike

> _______________________________________________
> Rekall mailing list
> Rekall-TvUNdCdnGOiN0BpGcQGnph2eb7JE58TQ@xxxxxxxxxxxxxxxx
> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall

-- 
Regards
Mike

http://www.rekallrevealed.org
*THE* GPL/Open Source database front end for Linux and Windows.