Database of the Year
 

Always a hotly debated topic.

--jeremy

What about Most famous embedded database like Apache Derby, DB4O and ...

I think you should include Kexi.

Every single time I've had the need for a database, sqlite has been perfect for it. What it does it does well.

MySQL
 

Easy to install on Debian and smoothly integrated into powerful web apps like phpMyAdmin, Gallery2, wikimedia, phpBB, and so on. I have been using MySQL for years and never had a problem with. It just works.

@interndan
I think Kexi is just a graphical interface to the actual databases.

Well my vote here goes to sqlite. A small hidden database that many applications use.

i vote for mysql

I also vote for mysql. Iuse combined with R for analysing huge datasets.

I have used mysql and postgresql .... Mysql gets my vote. I just like it. 8-)

Jeff

Postgres, of course. How could I take a DBMS whose defaults
are to allow a date of 30 February or to truncate too long
fields and just write a notification to the log seriously
for any real-life application? :D

Not to speak of issues we ran into with MySQL in the past...



Cheers,
Tink

Go Firebird!

Firebird
 

Firebird, of course!

MySQL has always been my database for big apps.

Tricky, As I like MySQL using InnoDB

Larga vida a Firebird!

Nothing beats Firebird in ease of deployment without any compromise on functionality or performance.

Firebird !

I that the FireBird is the best open source database for tradition application

Firebird SQL RDBMS

Amazing how many people sign up to LQ for the sole purpose
of expressing their preference for firebird :D


Cheers,
Tink

Cause they have nothing better to do.. they only come to vote on firebird then never come back, contribute, etc. It's like allowing illegal immigrants to vote for a president, never to return. ;)

I brought up a long time ago the voting on these awards is just as bad as the United States election process. It's Member Choice Awards, I think you should have to have at least 30 legitimate posts before you can vote. Not, sign up to vote then leave Awards.

I closely audit the polls every year and new signups have never completely swayed a poll. Every member is welcome to vote, as it should be. Hopefully some of those that signup specifically to vote in the polls will remain as active members of the LQ community long after the polls are open.

--jeremy

actually it will also do standalone file based database. quite simple to use and perfect for smaller requirements.

Firebird!!!!!

I really disagree with your comments. First, because I'm here now, reading your comments, posting again and contributing with my opinion. Second, I think is not illegal to come here and express myself. I'm a member since I'm registered in the site.

Maybe you are asking for a Old member Choice Awards :D:D:D

I can see you point. But the thing is that this happens every year.
From my perspective you're an exception to a rule/a pattern that I
see. A huge influx of new members who come here to vote for firebird,
as if some aficionado mentions on some other forum or IRC channel
that there's a members choice going on at LQ, and "all hell breaks
loose" in terms new members voting for their RDBMS of choice, never
to be seen again (in most cases).

And coming back to the political take on it: here only "permanent
residents" can vote, and to become permanent you have to have been
here for a minimum amount of time, and I find that VERY sensible.

I think we should ask Jeremy to introduce a rule that only people
who have been members for more than 3 months or had more than 100
posts are allowed to vote ;}




Cheers,
Tink

-Use Firebird SQL Server, if you have the luxury to choose among many database systems.
-If you want to deal with the COMPLEXITY, try PostgreSQL Server.
-MySQL is trying to become a “proper” database system on VERSION 5
-If you fancy a POSH database system, try Oracle.
-If you are walking on the road, bricks of which are laid by Microsoft, I need not say anything; you are already using M$ SQL Server 200x.

My vote goes to Firebird!

I can see your point too. I'm moderator in forums at spanish site Club Delphi, and we have a lot of new members registering only to ask something, and go away.

I think it's the rule, and not the exception. I don't know the pattern here, but I'm sure people come and go not only because the awards, but all the time.

If you see it from the other side of the coin, some people will remain, and the community will be growing. If the site is not interested on that, I really can't figure out why the site let the users to register and vote.

You, guys, have the choice to do that. If you think that's the right way, I have nothing to say, because I'm the newbie here.

But, as devoted user of Firebird, if the next year I know about a new contest at (to say something) databasepolls.com, and I find that I have the chance to express my opinion, and vote, I will to that. It's the choice of the site, and if they allow that, I'm doing the things well, even when maybe I never go back to the site to contribute in any way.

Cheers,

Is their any way to make sure that one person doesn't make two LQ accounts? (This sounds like a bit dangerous of a post since I'll be deep-fried.)

Only if they're on a static IP. And while it's frowned upon it's not
explicitly forbidden (to the best of my knowledge - Jeremy could
elaborate on this). The only times we're trying to enforce it is when
someone who was banned comes back to haunt us with a new nick.



Cheers,
Tink

Don't forget the many automated proxy sites that allow you to create as many IPs + logins with a single click (mostly used for warez downloads with rapidshare and friends). Most of them are actually new and did not exist (at such a large scale) a few years ago...

It is frowned upon, but we do have non-IP related measures in place to detect. It's not, however, something we go very far to try to stop. That's strictly for registration though and has nothing to do with how the polls are audited. As I mentioned previously - everyone is more than welcome to vote (and join).

--jeremy

I have used Firebird for four years. I love it!

PostgreSQL
 

PostgreSQL of course, apart other things, the license is BSD! I can't understand why people are still using MySQL. :p

Oracle already bought InnoDB, and the MyISAM engine is just too old.

Also, MySQL doesn't support transactions on altering tables, so if I have to change the DB structure (which always happens), I have to stop the site and tell the users: "Oh, please wait a while... MySQL doesn't support transactions...". ;)

Firebird is the best!

Firebird!!

I can believe Firebird is even in the running. It's a two horse race, folks. MySQL and PostgreSQL (with EnterpriseDB on the PostgreSQL side.)

When it comes to building real applications for transaction processing, none of them can hold a candle to Postgres or EnterpriseDB.

EnterpriseDB
 

EnterpriseDB is Best of all and compatible

Long live Firebird. awaiting Vulcan merge.

Well, my vote went to sqllite for licensing,
but Oracle is still Oracle
and XE is a very nice free product
:)

PostgreSQL supports user defined data types, which is important in my line of work.

It uses SQLite as its inbuilt database. SQLite is much more scaleable than you would think. Kexi is on the right track here; has big plans to be the next easy DB for real users, and may well succeed.

i vote mysql if you will be having clustered db, and pgsql for standalone and for million transactions.

I have no idea of what do you mean with "real applications", but I know a lot of real applications outside the enterprise world.

I have no doubt in choose oracle when we are talking about real high transaction processing applications in 24/7 environments.

Hi,

There are some posts, reading it seems that is advertisement of Firebird.
Some users create fake accounts only for the purpose of voting.

Jeremy, you will have to do something. You are correct that everybody has right to vote here. But active and legitimate users should be given more weight-age.

I like MySQL

Sun Microsystems Announces Agreement to Acquire MySQL, Developer of the World’s Most Popular Open Source Database. More information here:

http://www.sun.com/aboutsun/pr/2008-...20080116.1.xml

jainforall, read my last post in this thread.

--jeremy

http://www.developer.com/design/arti...0925_3721761_1

YES! :}



Cheers,
Tink

And a very nice write-up on the good old Postgres (PostgreSQL) vs MySQL debate ...

http://people.planetpostgresql.org/g...Sabino-Mullane


Cheers,
Tink