LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > 2003 LinuxQuestions.org Members Choice Awards
User Name
Password
2003 LinuxQuestions.org Members Choice Awards This forum is for the 2003 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2003. This is your chance to be heard!

Notices

View Poll Results: Database of the Year
MySQL 405 36.45%
Postgres 269 24.21%
Oracle 25 2.25%
DB2 2 0.18%
Sybase 3 0.27%
Berkley DB 4 0.36%
Firebird 403 36.27%
Voters: 1111. You may not vote on this poll

 
 
Search this Thread
Old 11-18-2003, 01:33 PM   #31
quadrumanous
LQ Newbie
 
Registered: Nov 2003
Posts: 4

Rep: Reputation: 0

phppgadmin was web-based... last time I looked at i (about 5 minutes ago).. don't confuse it with pgadmin (without the php), the x(/windows) based tool
 
Old 11-18-2003, 01:40 PM   #32
jabol
LQ Newbie
 
Registered: Nov 2003
Location: Poland
Distribution: slackware
Posts: 1

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

ps. my vote for postgresql
 
Old 11-18-2003, 03:39 PM   #33
n.weeks
LQ Newbie
 
Registered: Nov 2003
Distribution: FreeBSD
Posts: 3

Rep: Reputation: 0
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..

Last edited by n.weeks; 11-18-2003 at 03:40 PM.
 
Old 11-18-2003, 05:23 PM   #34
Scott Marlowe
LQ Newbie
 
Registered: Jan 2003
Location: Denver, CO
Posts: 8

Rep: Reputation: 0
Quote:
Originally posted by Crashed_Again
I can't believe Postgres is beating MySQL. Who won last year?
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.
 
Old 11-18-2003, 05:33 PM   #35
dfcarr
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
Quote:
Originally posted by z_darius

Firebird is by far the most mature of the three, and available for more platforms than all the other ones put together.
Huh? That is one heck of a claim, and very, very hard to believe.
 
Old 11-18-2003, 05:35 PM   #36
lowerbee64
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
Thumbs up 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

Last edited by lowerbee64; 11-19-2003 at 01:28 AM.
 
Old 11-18-2003, 05:36 PM   #37
nemesys
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
Thumbs up My vote is for FirebirdSQL

Fast, easy, maintenance free, robust and feature rich, why not?
 
Old 11-18-2003, 05:39 PM   #38
Alicia
LQ Newbie
 
Registered: Nov 2003
Posts: 2

Rep: Reputation: 0
Quote:
Originally posted by dfcarr
Huh? That is one heck of a claim, and very, very hard to believe.
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
 
Old 11-18-2003, 07:47 PM   #39
lmf
LQ Newbie
 
Registered: Nov 2003
Posts: 3

Rep: Reputation: 0
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.


Last edited by lmf; 11-18-2003 at 08:09 PM.
 
Old 11-18-2003, 08:13 PM   #40
ITenth
LQ Newbie
 
Registered: Nov 2003
Distribution: Mandrake
Posts: 3

Rep: Reputation: 0
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!

Last edited by ITenth; 11-18-2003 at 08:33 PM.
 
Old 11-18-2003, 08:41 PM   #41
mhsabado
LQ Newbie
 
Registered: Nov 2003
Posts: 13

Rep: Reputation: 0
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?
 
Old 11-18-2003, 10:22 PM   #42
boras
LQ Newbie
 
Registered: Nov 2003
Posts: 5

Rep: Reputation: 0
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..
 
Old 11-19-2003, 12:44 AM   #43
rehn
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
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
 
Old 11-19-2003, 01:35 AM   #44
nandod
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
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
 
Old 11-19-2003, 01:47 AM   #45
mhsabado
LQ Newbie
 
Registered: Nov 2003
Posts: 13

Rep: Reputation: 0
***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.
 
  


 


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
1 year from now... ghostwalker Linux - General 18 01-13-2006 08:38 PM
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 06:58 PM


All times are GMT -5. The time now is 05:42 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration