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

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.

- 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

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?

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

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

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.