[fpc-other] Firebird vs PostgreSQL

[Santiago A.]

El 25/10/2017 a las 21:19, Graeme Geldenhuys escribió:

> On 25/10/17 18:22, Santiago A. wrote:
>> I have some complains, but the overall feeling about Firebird is very
>> positive. It is a handy and powerful enough for almost everything . In
>> fact, I still have some production server running with no problems for
>> years.
> I've used Firebird for the last 10 years in various companies.
> Databases ranged from 100's of MBytes to multi TeraByte databases.

Well, I never reached that point. My databases were from 100 Mb to less
than 2 Gb.

> Comparing Firebird to MySQL.... All I can say is I really don't know
> why Firebird isn't more popular

That's my point. Why Firebird is not more popular?

Once I read two point about Firebird lack of popularity:
* In early days, firebird documentation was almost inexistent, there
were a few .txt with new features but you had to rely on Interbase 6.0
docs, that weren't very good either. So it looked like an almost
abandoned software maintained by a few fans.
* It had no administration tool, you had (and you still have) to rely on
third part tools. I think flamerobin is the administration tool "de facto"

PostgreSQL is more complete, but more complex as well. Nevertheless I
think Firebird does what 99% non-big-enterprise projects need, and works
perfectly in windows, Linux and other unices.
First time I heard about postgreSQL, it looked more a laboratory
test-tool to experiment with new academic advanced features than a
production RDBM. Compared to Firebird, Firebird looked more robust and
more aimed to real world.
Since then, postgreSQL has become the new darling RDBM in opensource 
world. I was wondering if firebird has some evident drawback , that I
can't see. or it is years behind PostgresSQL.
Am I missing important things?

> MySQL on the other hand is absolutely ridiculous!!!

MySQL was a low fingerprint for web servers. It even hadn't
transactions. When it appeared it was almost the only one.
Since then it has evolved to a more complete RDBM, but...

-- 
Saludos

Santiago A.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-other/attachments/20171026/5cfd1efb/attachment.html>