|Subject||Re: [ib-support] Features and Comparisons to PostgreSQL|
> Hi all,If this means more than one transaction per connection, then yes.
> I have recently been considering Firebird. Is there any comprehensive
> comparison between Firebird and PosgreSQL? I found the following
> Firebird is not compared very favorably in these two links, probably
> because it is not as well known as PostgreSQL. The second link even
> has many unknowns(?) in the column for Fb features. This is why I
> thought it better to ask this ng.
> Could somebody enlighten me if Fb has support for the following:
> 1. Concurrent Transactions
But, if this means a transaction within another one, then no. FB 1.5
will support SAVE POINTS which is part of SQL-99.
> 2. SQL ANSI 99It's in the process. The developers are looking at following SQL-99
in further developments.
> 3. ODBC access (The first link suggests that it is not free for Fb)There are some open source ODBC and OLE-DB drivers, look on
> 4. Unicode supportYes it does. The only place where it's not fully supported and it's
when creating your WHERE clause, Firebird has a hard time coping with
the special characters in the search string. Other than that, it
> 5. SchemasYes.
> 6. Online backups
> 7. Cancel a query asynchronouslyIt's being talked about and a possibility for FB 1.5(I can't say for
> 8. Boolean field
> 9. unlimited row size (if not what is the maximum with v1.5/2.0)No. The row size limit is 32767 bytes. I find it to be more than
enough. Also, the BLOBs are stored outside of the row, so one could
say that the row size is unlimited by using BLOBs.
> 10. User defined typesFB has domains. But, if this means that the user could define a
datatype that is non-existent in FB, i.e. GUID, then no.
> 11. Full text indexingNo. But, can be implemented by third-party products. It's not a
feature that everybody uses.
> 12. Can functions written in other languages be used in StoredYes. These are the User Defined Functions.
> Procedures (via dll/lib)
> 13. Functions for default value of columnsNot that I'm aware of.
> 14. Regular expression supportYes. You use the LIKE in your WHERE clause.
> 15. EXPLAIN commandNo. And, it's not a SQL-92 or SQL-99 keyword.
> 16. LIMIT keywordFB has the FIRST keyword to limit the number of rows returns.
> 17. FETCH commandYes.
> 18. Indexes on functionsYes it's possible. You specify the position of the returned column in
your ORDER BY.
These were answered to the best of my knowledge.
Have a nice day.
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)