[H-GEN] databases for linux

[Opec Kemp ( Ozemail )]

[ 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


> -----Original Message-----
> From: lists.humbug.org.au Mailing List Manager
> [mailto:mdlishum at zerlargal.humbug.org.au]On Behalf Of Johann Kwiatkowski
> Sent: Thursday, December 07, 2000 4:16 AM
> To: general at lists.humbug.org.au
> Subject: [H-GEN] databases for linux
> 
> 
> [ 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 All,
>             I'm looking at installing a database for my company to help
> us catalogue our  graphical files and products. I figures while I'm at
> it I might as well add in a customer database and  make it part of out
> internal website. We have a mixture of Macs, PC and the odd linux box.
> 
> I know literally nothing about databases, but I know what I want to do
> with this setup. I've heard of MySQL and others, but I'm not too sure
> if they will fit my needs, now or in the future.
> 
> If someone can give me pointers as to where I could at least start
> reading about databases that would be much appreciated. I'm sure MySQL
> or PostgreSQL would do the job, but I want to get as much info before I
> start. And do make it more fun, I have never done any programing (which
> from my intial readings seems like something I will likely need,
> especially if I attach it to an internal web site). I wanted to try this
> out first as we run linux servers (which I administer) and would
> obviously be a cheaper option.
> 
> thanks in advance
> 
> Johann
> 
> --
> **************************************************************************
> *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'.
> 

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