As a professional database admin, I have to say PostgreSQL is the best without a doubt.

And after having to deal with MySQL in a commercial/corporate environment in my previous and current job, I also agree that PostgreSQL is the more superior database that's opensource and free. I only use MySQL for web based PHP applications, etc.

Database of the year just has to be the one the British govt lost while sending a full copy of it between departments, unencrypted and by cheap commercial courier. 2 DVDs containing full details (social, financial) of every child and parent/guardian in the UK. Is there a category for security breach of the year?

Postgresql with PostGIS

sorry , can not vote due to the fact i do not use a data base...( c..not all new ppl vote for firefox)but am learning

How come no complaints about Oracle? I mean it's free if you don't go production (I.E. Business)

And if you do, the customer pays.

I think you're forgetting the eXpress edition. If it meet the requirements, your customer can go to production using this edition for free (even in business).

Best regards.

Dear Friends,
Oracle is not a Free software.
Free means Free in "freedom of speech". not in terms of money.
Oracle XE and Microsoft MSDE are a scale down versions for those who bites.
Those are Just Fish hooks. ones you develop something based on that and put it into production. situation will force you to buy the other versions.
If you already used it for production, you will have already experienced the same.
So if you are planing to use any of them, please make sure that you know all the limitations imposed in them.
Thank you.

I thank MySQL is the easiest to install and use!

So you clearly never tried SQLite

C'mon ... sqlite is great, and most certainly has its place, but
you can't really compare it with the stand-alone databases. You
*need* to be happy to do programming to use it. At least last
time I looked there was no stand-alone product.

That said: the ease of use and installation is what people
attribute to windows.
/me chuckles


Cheers,
Tink

MySQL. Been using it for a long time and will continue to do so.

Hi,

I love PostgreSQL, but I find triggers / functions difficult. There is not much documentation / examples available on these subjects. That withholds me from using it...

Best regards, Nico

I'm curious: what are you missing in terms of the docu?
A discussion would blow the context of this thread, please
post your questions in Linux-Software or Programming.



Cheers,
Tink

Hello !

Yes, sure, it's not the purpose to start a discussion on this thread. But to answer your question. Triggers / functions are different from let's say Firebird and I don't succeed to learn it. It would be great to have some example DB schema's full of triggers / functions. But that's off topic of course.

Thanks, best regards, Nico