Re: PostgreSQL and Firebird comparison via digg

Donald Shimoda wrote:
Tony Caduto escribió:
http://digg.com/software/PostgreSQL_8_2_vs_Firebird_1_5_for_Enterprise_Use


Old comparison. FB actual version is 2.0.3.

And BTW, that kind of comments on Compiled External Function (UDF) Support about firebird:


"A User Defined Function (UDF) is a mechanism provided to extend the built-in functions InterBase provide. "

direct from:

"http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_howto6";

"The truth of the matter is, InterBase does not come with a very rich set of built-in functions. Some common functions that are missing are modulo arithmetic, floating point formatting routines, date manipulation routines and string manipulation routines."

direct from:

http://www.firebirdsql.org/index.php?op=useful&id=deatz_udf



It's a generally know fact that in order to get access to functions most other databases have built in, you HAVE to resort to UDFs to get that functionality. Since most of these UDFs out there are not included with FB, you run the risk of crashing your server because there is no guarantee that they are of quality design. If the source is included you can of course review it.

Now in Firebird 2.1 beta they have added some more built in functions, but 2.1 is not a production release yet and can't be used in any comparison.
.

Relevant Pages

  • Re: PostgreSQL and Firebird comparison via digg
    ... that kind of comments on Compiled External Function (UDF) Support about firebird: ... 'Yes Currently used to get around lack of built in functions.' ...
    (borland.public.delphi.non-technical)
  • Re: PostgreSQL and Firebird comparison via digg
    ... Why doesn't PostgreSQL support multithread? ... Support about firebird: ... "A User Defined Function (UDF) is a mechanism provided to extend the ... arithmetic, floating point formatting routines, date manipulation routines ...
    (borland.public.delphi.non-technical)
  • Days in month
    ... >Not a built in, but the UDF is pretty simple: ... >Dim dteTemp As Date ... >Chris Nebinger ...
    (microsoft.public.access.gettingstarted)
  • Re: countif based on fill color
    ... Not possible with built in functions unless you can use the criteria which made you colour them in the first place, otherwise you will need code, either a macro or a UDF ... count all cells I've filled in red. ...
    (microsoft.public.excel.worksheet.functions)
  • Conditional Sumproduct
    ... I have already written a UDF for another calculation in this workbook, so I can do that here, but I would rather use the built in functions in I can. ...
    (microsoft.public.excel.worksheet.functions)