Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Tony Cadut » Wed, 22 Aug 2007 23:37:00


Hi,
I am doing a fair comparison of Firebird 2.x vs PostgreSQL 8.2
and would like input from Firebird users about features etc.

I have created a comparison table here:

http://www.yqcomputer.com/

Please let me know if I am missing any features and to help me fill in
the ? on the Firebird side.

You can post comments to let me know what features etc are missing here:

http://www.yqcomputer.com/ #comment-form

Also I would appreciate links to articles/documentation supporting the
feature claims.

Note: this is a comparison based on Enterprise use, so please don't add
any comments about embedded support, as the two products do not compete
in this area.


Thanks,

Tony
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Ray Marro » Thu, 23 Aug 2007 00:49:36


[SNIP]

That's one of the things I love about Pg - exhaustive online reference
materials. Want to know about stored proc syntax or not null constraints on
Firebird? Buy a book. (Anybody that replies "read the source" has way too
much time on their hands ;)

I use Firebird daily and like it, too. Just to fill in a couple of your ?s
(I didn't feel like registering), Firebird certainly supports not null and
unique constraints and unique indexes. The Firebird equivalent to Pg's
limit/offset is first/skip (select first 10 skip 10 * from...) I can cite no
supporting documentation besides watching these work (Fb 1.5).

--
Ray Marron

 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Tony Cadut » Thu, 23 Aug 2007 01:11:06


Thanks Ray,
Updating it now.
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Tony Cadut » Thu, 23 Aug 2007 01:22:50


Sorry I fogot that the main site comments where registered only.
You can post comments here:
http://www.yqcomputer.com/
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Tony Cadut » Thu, 23 Aug 2007 01:41:45


Sorry, I forgot the main page was locked down to registered users only.
Comments can be posted here and you don't need to register.

http://www.yqcomputer.com/

If there is a feature that Firebird has that PostgreSQL does not I want
to hear about it and I will add it to the list.

NOTE: this is for the OS projects only. I will not be posting features
of 3rd party versions such as EnterpriseDB or Fryacle.

Thanks,

Tony
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Jonathan B » Thu, 23 Aug 2007 01:45:39


You might find some info here:

http://www.yqcomputer.com/

Jon
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Tony Cadut » Thu, 23 Aug 2007 02:00:07


Thanks Jon,
I updated with the info from the site.

It was missing he max field size though, do you know what it is for
Firebird 2.0?

Thanks,

Tony
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Ryan J. Mi » Thu, 23 Aug 2007 04:22:17

Hi Tony,


I've posted a few update items for you on your website, but I'm not
sure I understand the above question? What field type are you asking
about?

This maybe a better question on one of the Yahoo Groups for firebird.

Ryan.
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Martijn To » Thu, 23 Aug 2007 06:12:22

Tony,


Firebird has "compound indexes", "unique indexes" and "functional indexes"
(usually called "Expression Indexes").

Firebird does not have "user defined types" the same way as PgSQL has,
but it does have "domains" which are subsets of standard datatypes. Does
PgSQL have these? btw, "user defined operators" make sense if you have
true user defined types, like PgSQL. Else, they don't.

Do note that MS SQL has Domains but calls them "user defined types"
(before SQL 2005).

I also suggest you rename "Compiled UDF support" to "External Function
Support" as MS SQL calles Stored Functions "User Defined Functions".

Firebird does not have Stored Functions, that might be something to add
to the list.

I'm not sure if "Write Ahead Logging" is actually a feature. I also see that
PgSQL uses this for incremental backups, Firebird has two backup tools:
a "dump" tool and a tool for very fast file system level backups, including
incremental backups.

Yes, Firebird has Savepoints.

From the link to the PgSQL documentation, I cannot see it has built-in
replication. Either way, Firebird has several 3rd party add-on products
that provide replication.

Firebird does have "database shadows", which are exact copies of your
database that can be useful for drive failures.

I also disagree with you saying "No, Firebird does not have a "true text/
memo" datatype". It does, it's called "blob subtype text", I thought it
understood
"clob", but it doesn't. Nevertheless, this is a good as it gets.

Yes, Firebird has "fully relational system catalogs".

Yes, there are add-on products for Firebird to create a usuable full text
search.



With regard to version updates, what exactly is the point? The Firebird
project
is active, but releases less often than, for example, MySQL. True. But have
you noticed why MySQL releases that often?



Also, a few of your "no" answers will be solved in Firebird 2.1 :-)


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.yqcomputer.com/
My thoughts:
http://www.yqcomputer.com/
Database development questions? Check the forum!
http://www.yqcomputer.com/
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Tony Cadut » Thu, 23 Aug 2007 11:53:13

What about SSL support, does FB have that?
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Tony Cadut » Thu, 23 Aug 2007 13:46:44

Martijn,

I think I added all your suggestions, check it out.

Thanks,

Tony
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Martijn To » Thu, 23 Aug 2007 15:29:18

> What about SSL support, does FB have that?

No, it doesn't.

It also doesn't have alternative authentication support (LDAP etc), although
it's being worked at.

I still disagree on the TEXT/MEMO issue.

How does PgSQL deal with charactersets and collations? In Firebird, you
cannot have a
collation per database (your page says "yes" to this, which is incorrect),
but you can have
a characterset per database, also not per table.

You can, however, define charactersets and collations on a per column level.
If you don't
specify these, the column will take the default characterset from the
database and it's
default collation.

Firebird has VERY VERY rich character and collation support and supports
creating your
own characterset and collations.

I noticed you changed FTS to "official part of the project" ;-)

Another note regarding "Max Row Size", with Firebird, BLOB contents does not
count
towards this limit, obviously.

Typos:
PgSQL: "max indexes" -> Unlimted
Stores Transaction -> Informatin <-


Hope this helps.


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.yqcomputer.com/
My thoughts:
http://www.yqcomputer.com/
Database development questions? Check the forum!
http://www.yqcomputer.com/
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Eduardo A. » Thu, 23 Aug 2007 22:01:52

Tony,

Take a look at this 2005 research paper. It compared FB 1.5.2, Ingres
r3 3.0.1, MaxDB 7, MySQL 4.1, and PostgresSQL 8.

http://www.yqcomputer.com/

- Eduardo
Stop Continental Drift!
-- Anon

Eminent Domain Software
"Custom Software Development For Your Domain"

Makers of EDSSpell, EDSPrint, EDSZipCodes and
XSpell, the IDE Expert.
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Martijn To » Thu, 23 Aug 2007 22:09:51


http://www.yqcomputer.com/

Ah yes, Thomas Steinmaurer (also working with Upscene) worked at that paper.

It's a very good comparison, but Tony is comparing PgSQL 8.2 and Firebird
2.0,
both products have changed quite a bit since PgSQL 8.0 and Firebird 1.5
(from
the paper).

Just so you know :-)


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.yqcomputer.com/
My thoughts:
http://www.yqcomputer.com/
Database development questions? Check the forum!
http://www.yqcomputer.com/
 
 
 

Need input from Firebird users for a PostgreSQL vs Firebird comparison.

Post by Eduardo A. » Thu, 23 Aug 2007 22:16:49

Good to know. Maybe when Tony finishes will have an up to date
comparison. We are still at FB 1.5.x. Be interesting to know if 2.x is
sufficiently better to justify the upgrade of our 150 +/- locations.

- Eduardo
Stop Continental Drift!
-- Anon

Eminent Domain Software
"Custom Software Development For Your Domain"

Makers of EDSSpell, EDSPrint, EDSZipCodes and
XSpell, the IDE Expert.