[H-GEN] databases for linux

[Johann Kwiatkowski]

[ Humbug *General* list - semi-serious discussions about Humbug and  ]
[ Unix-related topics.  Please observe the list's charter.           ]
[ Worthwhile understanding: http://www.humbug.org.au/netiquette.html ]

Thanks for the reply, that answers one of my questions, which was what was the difference between the
two. However I don't yet understand what Tranactions, triggers, etc.  are. Any advice on where I
could get a crash course on database terminology then? Once I've worked out that, then I think I can
work on which I should be learning.

cheers

Johann

"Opec Kemp ( Ozemail )" wrote:

> [ Humbug *General* list - semi-serious discussions about Humbug and  ]
> [ Unix-related topics.  Please observe the list's charter.           ]
> [ Worthwhile understanding: http://www.humbug.org.au/netiquette.html ]
>
> Hi,
>
> Depending on how your application will use the database and what your application will be use for.
> Basic rule of thumb are:
>
> Use MySQL if:
> - You don't need to use Transaction
> - You don't need to use Triggers
> - You don't need to use Store Procedues
> - You don't need to use Foreign Keys
> - You're doing lots of read (more than writes ie updates, delete etc)
> - Yo need lots of speed :)
>
> Use Postgres if:
> - You need to use Transaction
> - You need to use Triggers
> - You need to use Store Procedues
> - You need to use Foreign Keys
> - You need to use advanced stuff like defining your own data types etc.
> - You need advance concurrency row locks.
>
> These 2 DBs are well supported in most common languages. The your choice of your
> application's language will determined how easy/hard it'll be to interface with these DBS.
> Perl - pretty easy, C & C++ not as easy (unless you're C & C++ guru of course :)), PHP very easy.
>
> URLs
> MySQL:
> http://www.mysql.org
>
> Postgres
> http://www.postgresql.org
>
> Hope this helps

--
**************************************************************************
*Johann Kwiatkowski                                Spot The Dog Graphics *
*email: johann at spot-the-dog.com              http://www.spot-the-dog.com *
*P.O. Box 311, Helensvale                                                *
*Qld, Australia, 4210                                 ph  61 7 5501 5712 *
*mobile: 0418 797 419                                fax  61 7 5501 5713 *
**************************************************************************




--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.