Database of the Year
 

An extremely close Award last year!

Re: Database of the Year
 

And it should be this year too, although it doesn't appear to be turning out that way ;)

sure, I voted for MySQL, yet I wish that for the purposes of this poll I could have chosen my top three or four with check boxes.

Reason being, they're all great products. BerkelyDB is something that everyone uses (makemap hash /etc/mail/virtusertable < /etc/mail/virtusertable).

It's nice to see IBM's DB2 up there too :)

Sybase is what the original mACROsFOT SQL Server was based upon, although few people seem to be aware of that little ditty. The only REAL difference in the 4.x versions were that the mACROsFOT incarnation only ran on mACROsFOT b0x3s and was multithreading.

Oracle deserves much more attention than it's receiving here, and has it's place in high transaction environments where procedures make life simpler.

PostGREs, for some reason, never seems to get the attention it deserves either, although I rarely implement it myself - so I'm guilty too ;)

mSQL isn't listed.

hm.... nope. I wouldn't change my vote anyway though - heh. :)

Firebird SQL
 

My favorite Firebird SQL isn't on the list, so I'm not able to vore.

MySQL

Simply put the data I have is on Desktop, Laptop and Zaurus - with the help of MySQL - I cannot have a stronger case for this software.

haha, last year was a fluke...mysql all the way

Please consider adding sqlite

knoda is also a very useful database front-end.....

Postgresql!!
 

All the way..
Never had any serious problems with anything.. very stable..
Mucho data hungry seems to suck anything i throw at it.
The Copy command takes almost 1/2 a million records from our legacy system in a few seconds..
Executes extremely complex queries really fast..!! Perfect for large information systems and very good for small databases. I mean if you know your database is going to grow why not just do it on Postgres?

Oh.. you can write your own functions in PHP ? weee...

PostgreSQL
 

Recently handed the task of speeding up MS Access DBs.

Tried MySQL first, but many of the SQL statements used weren't supported in MySQL.

With very little effort they are all running in PostgreSQL with a tremendous speed increase.

Gotta love it.

Where's Firebird???
 

I'd like to vote for Firebird, but it isn't included ?!?!

That database is so good, that I think it could win this contest.

For those of you who don't know about it, go here:

firebird.sourceforge.net

or

www.firebirdsql.org

Firebird!!!!
 

Why isn't this a choice???

Firebird has been added.

--jeremy

I voted mysql, because it's like a standard... let me explain myself:
-I use external servers(lycos etc...); it's good to know I can just code without needing to know where I'm going to store my webpage.
-Most people know it, gettin' support is easy

That's about it.

Thank you very much voted :cool:

PostgreSQL rocks my planet, very fast, very advanced , very easy to use database, can't understand why it's not more popular than MySQL, I assume it's because many people haven't tried it?

<edit>Oh, and 7.4 was released today.</edit>

The name of Postgres should be PostgreSQL.
Check out it's new 7.4 release, just some of it's performance improvements:

# Hash aggregation in memory to make data warehousing and OLAP queries up to 20 times faster;
# Improvements in subquery handling by the planner resulting in up to 400% speed increases in some complex queries;

Wow and thanks once again to the PostgreSQL Global Development Group.

See http://www.postgresql.org/presskit/en/presskit74.html for details.

It's hard to narrow it down to a single database. Perhaps we should use the Debian voting system. :-)

http://seehuhn.de/comp/vote.html

Rich
--
Rich Dougherty
http://www.rd.gen.nz/

I think because it's not in people's consciousness the way MySQL is. And for most
things MySQL seems to work well enough. It's only when you get into complex
database designs that MySQL's weaknesses become apparent, and your typical
PHP && MySQL web app could probably work just as well with a file-based data retrieval
system.

Postgres is the only database which suits for all my commercial and internal projects.

Ummmm I vote for MySQL, but as my work is mostly over this things, I like to say a few words.

Database aren just as distros that you can choise your faivorite, there are diferences in these that ar as options in this poll, and that is for some reason. I can't make a php site using berkley as db engine, in fact, I can, but is wasting resources, and extremy slow (To code and to run). Also I can't run a OpenLDAP server using MySQL or the autentication could take hours :p

MySQL is great for applicacions, web sites, even for some other things (MTAS using MySQL to store information are a great option). But it dosn't make it 'the great'.

As I say, my vote was for MySQL, it grouw up a lot this year (Foreing Keys, Subquerys in 4.1 ALPHA).

SAP Db?
 

Hi,

why is SAP Db missing on the list? (http://www.sapdb.org/7.4/sap_db_gnu.htm)

It's pretty good en VERY fast. Whit nice finished admin tools.

Regards,

Jean

Yeah. Should be there. I'd still keep my vote for postgres tho ...

Postgres Vs SAP Db
 

Yeah, the license of Postgres is much more open for us to use it in commerciaal products we develop. SAP Db is good now, with the guys of MySQL are going to turn it into MaxDb with the MySQL license.

I was quite impressed by the performance of SAP Db, with I have to test Postgres 7.4 next week.

I can't believe Postgres is beating MySQL. Who won last year?

Awesome. TY. No prizes guesing which I voted for! ;)

Well, MySQL is just a glorified file system with an SQL interface. It is getting better but still a little to go before it can be called a true enterprise level RDMS.

Postgres could be OK but it's a little to cumbersome at this time.

Firebird is by far the most mature of the three, and available for more platforms than all the other ones put together. It's one of those "set and forget" systems. Rock solid, small footprint and unlike MySQL, it's 100% free for both personal and business use.

I think im implementing Postgres on my system, does it have an equal to mySql's PHPmyAdmin?? I need Web based?

It's called phppgadmin and you can find it on http://sourceforge.net/projects/phppgadmin, other tools you can find on http://gborg.postgresql.org/ . I use the pgadmin III now, which workt pretty well.

Why don't you try Firebird. It's small, full featured and YES, it does have PHP support and at least 2 browser based admin tools are available for it.

are any of these web based, phppgadmin seems to be a non web based client

phppgadmin was web-based... last time I looked at i (about 5 minutes ago)..:D don't confuse it with pgadmin (without the php), the x(/windows) based tool

phppgadmin is an webbased client. a non web based example could be e.g. pgadmin III or pgaccess

ps. my vote for postgresql

I'm not surprised that Firebird is gaining popularity. There are many smart developers around recognizing it's power.

MySQL has it's place, half way between a flat file, and an RDBMS - Brilliantly fast, short on features.

PostgreSQL has it's place, as a swiss-army knife RDBMS/research tool - fast enough, heavily loaded with features.

Firebird proves to be the right match of Speed and Feature-set, with bullet-proof maintenance-free operation.

Haven't been back to MySQL, or PostgreSQL in 3 years..

p.s. - Does the thought of waiting for enterprise-grade features to be tacked on the side of a database engine(MySQL) seem a bad idea to anyone else?
Surely it's best to use a DB that was designed in the first place for Ref.Integ, SubSelects, Stor.Procs., Triggs., 2phase commits, etc..

PostgreSQL. And for good reason.

http://sql-info.de/mysql/gotchas.html

I like MySQL, warts and all, but only for content management. For handling date math, accounting, and complex stuff, I prefer PostgreSQL. It takes more hand holding type maintenance (vacuum, reindex (now no longer needed, yah!), analyze, etc...) but provides better scalability.

MySQL is dirt simple to install and use, and flies for simple data warehousing stuff.

They both have their place, and for Postgresql, that place is sitting on a large Sun Solaris system running the database behind the .org and .info domains.

Since this survey is on a .org site, every page view here is a testament to the reliability and scalability of PostgreSQL.

Huh? That is one heck of a claim, and very, very hard to believe.

Firebird
 

- some 20 years of experience (from Interbase)
- SQL92 compliant
- solid
- maintenance free
- stored procedures
- views
- triggers
- UDF (user defined functions, awesome feature!)
- tiny footprint ( between 1 and 3 megabytes of distributables depending on needs)
- available for many platforms (Linux, Win32 among others)
- really free under all circumstances including commercial redistribution (unlike MySQL)
- lots of 3rd part tools (free and commercial)
- PHP support
- has embedded version (win32 only)

oh, did I say it was very stable and suitable for distribution with your programs

My vote is for FirebirdSQL
 

Fast, easy, maintenance free, robust and feature rich, why not?

Oh, there are so many things in this world which are hard to believe. Fortunatelly we deal with databases here so little is a question of belief.

Would it be so hard to check it out for yourself instead of relying on beliefs?
Check Firebirds history.

http://ibphoenix.com
http://firebirdsql.com

I vote for firebird,i have been using firebird since the first time firebird is published. i think it is smart and powerful database system.

Voted for Firebird a while ago. Came from MySQL last year, never looked back. For those of you who haven't tried it, you don't know what you're missing.

Firebird rocks!

Firebird SQL? Hmmm... I just voted for it.
I thought of becoming a database admin somehow but I realized I don't need to. With its portability and support for on-line backup and restore among development tools, not to mention its tremendous features. I just have to focus on the business process and forget about it.

My first experience with MySQL is a bit traumatic. Thinking that it runs for windows and linux, we've created the data structure on a windows desktop during the development process. And when we deployed to the linux server, it can read the data but can't alter(update). Only database that was created on the original server can be manipulated!

I've attempted PostGres, but hey, do I have to borrow linux server at home for my development?

Firebird!
 

I voted for Firebird.... After I've discovered firebird 6 months ago I realized how much I was missing for using the popular MySQL. I never looked backed.... And Firebird 1.5 is almost getting released.

If firebird is getting so many votes this year I can guess who will win next year's poll..

Database of the year
 

*** Firebird! ***

- rock solid
- easy maintenance
- packed with features a true RDBMS should have
- lightning fast
- small footprint
- available on linux, freebsd, solaris, hp-ux, aix, mac os x, windows
- databases transportable across platforms
- excellent ng support
- not tied to any company
- no license fees whatsoever

check out: firebird.sourceforge.net

My vote for Firebird
 

I have nothing to say but: just try it. You won't be coming back to anything else any soon.

Nando

***Firebird***

Did I say Firebird 1.5 is more than 40% faster to Firebird 1.0 based on the comparison tests made? Unfortunately, we're voting for Firebird 1.0. ;)

FirebirdSQL
 

Fast
Easy
Maintenance free
Robust and feature rich
Multiplatform

Firebird!
 

Firebird of course!

Easy to use, pleasure to work with, powerful, lots of features and FREE as in BEER

Give it a try. Classic version for Linux (rpm) fits on a single 2.88 floppy!

http://ibphoenix.com (lots of info and links to visual tools)
http://firebird.sourceforge.net/
or
http://firebirdsql.com

Firebird SQL , normally !
It will never let you enter "2003-02-31" as a date in database. Just picky here :-)
I do developement at home on a WinXP WS. Stored procedures and triggers debugging (breakpoints, step, watch variables and parameters, etc) is a nice thing to have.

Just a little correction, the name is "Firebird" not "Firebird SQL".:cool:

Right, but I like the SQL at the end, no confusion with Mozilla Firebird.