> Pavol STAREK wrote:
>> Firebird is missing:
>> 1. Lot of admin management tools. For example you do not know what
>> databases are opened in time, how much connections is there for server
>> not
>> database and other monitoring tools.
>
> Firebird 2.1 is the solution

will be :) don't forget we are talking about actual and past time.

>
>> 2. security - nearly all about this topic :)
>
> Agreed.
>
>> 3. performance limitations. As hosting provider you cannot let wrong
>> code
>> to kill your servers with infinite queries. Killing of query.
>
> Firebird 2.1

will be :) don't forget we are talking about actual and past time.

>
>> 5. client connectors support. php support is not very good
>
> Care to explain what is lacking?

for example: firebird have problem with long running connections AFAIK.
But current implementation of pconnect or even connect can lead to some
kind of long live connections. I miss feature to limit live of persistent
connection to time or number of transactions. I just started to check php
ibase code to better understand it.
And as Helen mentioned firebird is not interbase. But that module IS
interbase module.

>
>> 8. good client applications. There are some for windows, but for linux
>> there is only flamerobin AFAIK which is not as user friendly
>
> You meant: not as Windows-user friendly. :)
>
> FlameRobin is not meant to be, and probably will never be a copy-cat
> replacement for Windows tools. If you really want that, you can run DB
> Workbench in Wine - but maybe then you shouldn't be using Linux in the
> first place.

I personally see flamerobin as perfect tool. But you have to sugest
something to customers. :) Compare it to pgadmin3. and we are still
talking about hosting providers, aren't we?
Try to tell starting university absolvent or small bussines director that
you are offering him great hosting with best database ever but his 15
years old son working there as network administrator and web maintainer
cannot use his nice shining ubunt beacuse there is no click-click client.
Linux is not for geeks only for long time. Even my wife and 3 years old
son use linux. But they need that click-click features.
Anyway flamerobin is really great tool and am not blaming flamerobin but
nonexistence of other click-click solution in linux.

>
>> pgsql is rock stable, have no more downtimes then firebird, have great
>> support, great documentation and it works on windows since some time
>> ago.
>
> I don't see how is that argument *for* PG? Firebird is also 'rock
> stable', has 'no more downtimes' than itself, and works on Windows since
> a long time ago?
>

well we are talking about "Why is more hosting available for Mysql and
Postgresql". So we are not looking for pg advantages but firebird
advantages over pg :)

I use firebird as hosting database from version 1.0.3. We use postgres on
other servers with little more customers then fb. Postgres really do not
need any maintaince. You have to restart it every 2^32 transactions i
think. But without housekeeping it can go slower or less responsive but it
never fall down. No freezes, no crashes. Uptimes longer then 1 year are
not rare. With hundreds of databases. Yuo have to restart only when
upgrading.

On other side longest uptime with firebird is 27 days. For now with
version 2.0.3 i have freezes every 24 hours. Before upgrade there was
crashes every week or firebird just started to eat 100% of cpu. And for
this lot of corrupted databases. It looks that there was problem with OIT
and co. Now i do nbackup every hour on more then 100 databases. This can
be problem of administration work or somewhere between chair and monitor,
but somewher in text about firebird is: Firebird need no or little
maintaince. But actually we spend 100times more time by investigating
firebird issues then handling pg database.

>> And lot of other advantages.
>
> I don't see any advantage (that you listed) in the first place.

What about documentation, much bigger comunity, general application
support (give me 10 common web apps as cms, crm, webmail, unix daemons,
which work with firebird but not pg), several balancing and replicating
system, security, tools generally...

Dont forget we are still talking about "Why is more hosting available for
Mysql and Postgresql".

>
> --
> Milan Babuskov
> http://www.flamerobin.org
>